belmore

Thanks again Pat. I mostly followed along.... Step 1, I added a field to the structure type String. When I had it as a Integer type, I got an error. Step 2, I needed to add a colon before the = in the procedure but other than that no errors. Step 3, I modified SortArray and it does change the sort, just not by hoist ID... I can't tell what it's sorting from. Thoughts? Ben

Thank you @Pat Stanford for putting this out there. I have picked up the ball and run with this one so I appreciate all your hard work and excellent script comments. I have tweaked the sticker symbol, added to the record format and the script, and everything is coming together swimmingly. The one stumper I can't get over is the SORT function. Is there any way to do the SortArray by HoistID? Could I or should I somehow add HoistID to the Structure? I'm stumped. Thanks in advance!

Great to know, thanks a fortune!

Here I made this using the examples above. The last database row does not function. Referenced Cell Stumper.vwx

Tried both, no dice.

This is driving me crazy. I am trying to use a worksheet cell as an argument. I can do it one way, but not another. First off: This works: =DATABASE((L='Design Layer 1')) I get a list of everything on that layer. And instead of a hard value, I can substitute worksheet cell B1: This works: =DATABASE((L=B1)) ...and then I can modify cell B1 to change the database. I can instead make a database based on a fieldvalue if it's hard-coded: This works: DATABASE(('TestRecord'.'TestField'='101')) ....and it will return all objects that have that record field being 101. But when I go to reference a cell in that formula, I get nothing but errors: This does not work: DATABASE(('TestRecord'.'TestField'=B1)) What am I missing? I have tried everything I can think of. Thanks in advance!