Jump to content
  • 4

Ability to concatenate multiple values in worksheets, just like we can in Graphic Legends



In Graphic Legends, whenever I summarize objects I can set a Dynamic Text to show Multiple Values:



So, for instance, in a Light Fixtures Graphic Legend where I have the same fixture in different rooms, and I have a record field in my symbol like this: "LightFixtureRoom" I can show them like this in my Graphic Legend. "Bedroom A |  Bedroom B | Dining". Works smoothly.

Wish list: Achieve the same result when summarizing items in my worksheet. By default, when I summarize and there are different values, I get "---" as result.



  • Like 1
Link to comment

1 answer to this question

Recommended Posts

  • 0

In worksheets you can use =getspacenameforobj


This will return all room names in the worksheets that your light fixture is located in.


I used to do the same thing before i discovered these functions. Note - it will use your databade query to populate the space names.


There are alot of functions in vw. If you want to learn more about more functions - go to the insert menu in the worksheet and click insert function...there will be a useful (looong) list of functions on how to use them

Edited by Samuel Derenboim
Link to comment

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.

Answer this question...

×   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.

  • Create New...