Hi Pat, I hope this feedback is helpful to all. You were correct in saying some work had to be done in connection with fixed choice menus. I enjoyed exploring this. And thank you for your introduction to Vector Scripting, another fascinating room to explore in the complex fun-palace of Vectorworks!
So with your help I created the worksheet needed including one workaround:-
='I-Beam - 3D'.'Length' returned lengths as needed for all series types and sizes.
='I-Beam - 3D'.'__series_2' returned series types with correct differentiation. So for data base rows generated by one criterion containing a mix of series types, AISC (Metric) and BSI (Joists) , the appropriate types appeared in the column with this function. I assume use of the numeral 2 in the function corresponds to the second field providing the fixed choice menue in the OIP?
='I-Beam - 3D'.'__size_2' returned the correct sizes of series type 2 beams (AISC (Metric)), but an apparently random default size for any beam of another series type, regardless of its size.....
.....so I used datebase criteria and a record format as a workaround to re-order my worksheet into separate groups of rows. Each group with one series type. Then for each group, e.g. of AISC (Metric) sections, I used the appropriate function :- So ='I-Beam - 3D'.'__size_2' for AISC (Metric) and ='I-Beam - 3D'.'__size_3' for BSI (Joists).
Maybe there is a function including "if" ..."then" etc (Boolean?) which includes more than one numeral to return differentiated sizes within rows generated by one data base rule set.....
....breaking out now then will try to earn some fees!! PS El Segundo looks warm! Cold and damp here, ideal for silk weaving which is how Macclesfield developed economically in the nineteenth century.