Records and worksheets

[VerhoevenJ]

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 January 16, 2017 by VerhoevenJ

[Hippocode]

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.

[SamIWas]

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.

[Hippocode]

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

[SamIWas]

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.