Jump to content
bapelaj

Schedules with Custom Symbols

Recommended Posts

In the attached snapshot, I've created 5 simple symbols - circles with varying colors and sizes. These could be anything - trees, shrubs, lights, doors, etc. I've attached a record for each of these symbols to include COLOR and NUMBER (or size) so that the schedule can include this information.

 

Question - is there a way to create a schedule that includes the custom symbol in the schedule as shown in the inset schedule / legend?

 

I'm continuing to look for answers online, sifting through a lot of content. If someone knows how or if this is possible, I would appreciate the help!

 

Thank you.

 

vw.thumb.jpg.6f47aa8a293864676015f16bb4d8f643.jpg

Share this post


Link to post

If I understand correctly what you're looking for, the answer is yes.

 

= IMAGE will return the image of the symbol.

 

But you may be trying to do something more complicated.

 

It might help to post the file here so we can see how you're setting up your database.

  • Like 1

Share this post


Link to post

There are several threads floating around try searching for "=Image" and you should find them with more information on how to make it work. One of the tricks is to set the scale and the cell size so the image displays reasonably.

 

  • Like 1

Share this post


Link to post

Perfect, that did the trick! Exactly what I was trying to do. Thank you for the quic k response!

 

The "add custom field" is a whole new world for me. I didn't quite figure out why the "length" of the line wasn't calculated in the spreadsheet, but I think I can continue to tinker with it and figure it out.

 

Am I correct in assuming that creating a report is ideally performed once, at end of project or before printing? Is there an easy way to edit from "create report" pop-up without having to re-create a report?

200415_VW Symbols.vwx

Share this post


Link to post

Yes, If a report has already been defined and you select the Report (database) row, the right click option changes to Edit Report.

 

And once you have it setup, all you need to do to get the current data is Recalculate from the Worksheet File menu (Or right click on the Worksheet image in the drawing if you don't have it open for editing)

Share this post


Link to post

@Pat Stanford - do you know if there's a way to show the symbol as 2d geometry, rather than an image? In similar files we have to this (such as electrical schedules) the 2d symbol is shown as an image, which then creates a larger file size when exported to PDF rather than or old way of having a legend with 2d geometry in it on the sheet layer.

Share this post


Link to post

All of the formatting possibilities are in the Worksheet Format Menu:Cells...: Images Tab.  You can display whatever view you want, but I don't think there is an option for the data type to be exported.

Share this post


Link to post
Posted (edited)

Diving deeper into the functions.

 

I'm trying to create another report but instead of symbols, want to have a column showing fills (color, patterns or hatches).

 

I'm using the "hatchfill" function but what displays is the name of the hatch (09 Square 1/16in HF), not the visual of what it looks like (tiny square grid).

 

I've scrolled through all the functions and it doesn't seem like there is anything that qualifies. There's only something for a hatch, but not for a solid color, pattern or tile. Is there a function I am overlooking? Is this possible?

 

image.thumb.png.7d0f50336d87c080acac3dc28614db33.png

 

Edited by bapelaj

Share this post


Link to post

There is no easy way to do this. I can't find the file where I tested something similar a long time ago using colors. The best I came up with at that time was to put hidden objects with the colors somewhere and naming them. I was then able to bring them into the worksheet by using an =Image('MyName') command I think.

 

Good Luck.

Share this post


Link to post

Doesn't =Image do this if you format for 2D attributes rather than for Thumbnail?

 

Or are you trying to get the hatch from an object that is part of a symbol?

 

image.thumb.png.f853e5d32c869d7dc76d425d63e5ecdb.png

Worksheet Hatch.vwx

  • Like 2

Share this post


Link to post

Many thanks, michaelk. That was exactly what I was trying to do.

 

It worked like I wanted it to in the file you sent, testing in my file now...

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...