Jump to content
VerhoevenJ

Records and worksheets

Recommended Posts

I have made a symbol and attached a record. In this record I have made a field where you can give a length and a drop down menu that has 4 options.
Now I want to make a worksheet that gives me the sum of the length fields with the specific option selected in the drop down menu.
Can anyone help me? 

Worksheet_&_records.vwx

Edited by VerhoevenJ

Share this post


Link to post

when you want to show any kind of record field in a database row, this is the structure you should use:

=RECORDNAME.FIELDNAME

 

In case the record or field name contains spaces, you need to add ".

="RECORDNAME"."FIELDNAME"

 

In case of a parametric object, the default record has the same name has the object. In your case you need to use the name of your custom record.

Share this post


Link to post

Wait...does 2017 have drop-down menus in record formats???  I might have to retry it this week and see if it's stable for me now!  That was one of my biggest wishlist items, and I didn't even realize it.

Share this post


Link to post

I thought earlier versions as well. You can create a list of possible values that can appear in the drop down.

Share this post


Link to post

If there's a way to do that in record formats in 2016 and prior, I've never found it.  I can do it within Spotlight fields.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

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.

×