Hi all,
Could find a solution to seemingly simple task I am trying to achieve.
Essentially, is it possible to use a formula in property sets to lookup a value from an array of values? Something similar to Excel lookup?
I've got a list of values I'm providing using a list definition, and I would like to implement a lookup of another value from a config table.
And just generally, is there a reference guide somewhere for the formulas we can use for Property Definitions? I've only found those which are dealing with extracting civil 3d database object properties, but I'm interested in some more trivial ones.
Any help or pointers to sume supporting resources would be much appreciated.
Regards,
Val.
Solved! Go to Solution.
Solved by samir.rezk. Go to Solution.
You can do something similar to a lookup by creating a List definition first (to compose a list of items) and
then reference that list as the source for the property set attribute.
Hope this helps,
Samir Rezk
Technical Support Specialist
Hi Samir,
this is exactly what I did for the values in the red box in my screenshot.
I just wanted for the respective values in the green box to be looked up in another property definition.
I understand better now what you'd like to do! Lookups are not a native function in Property Sets, but I did find this thread with a similar situation, not sure if you came across it already!
Also, Dynamic Block lookup table might be a good option, if you're working with Blocks! as opposed to Property Sets.
Hope this helps,
Samir Rezk
Technical Support Specialist
I created a lookup/list that has multiple values in each list to define various items, as shown below.
However, when I go to my point label style to apply the items that are part of the list within the label style they don't appear in the selection list, is there something I'm missing or does this function not exist.
Thanks, Rick
Rick Jackson
Survey CAD Technician VI
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Hi @rl_jackson
List definitions do not show up in the drop down menu in the label style composer automatically, however we are able to write the label code directly. type the following:
<[PSD Name:PS Name(CP)]>
Based on your screenshot, an example will look like:
<[Structures:A_Direction(CP)]>
CP means case preserved, this can be changed to CU or CL
same code applies for creating table styles!
Hope this helps,
Samir Rezk
Technical Support Specialist
Thanks @samir.rezk that was very helpful, I honestly didn't even think about hard typing it. I also would not have thought the list would be any different than the normal property set and its exposure to the label style.
Rick Jackson
Survey CAD Technician VI
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Can't find what you're looking for? Ask the community or share your knowledge.