Property Set Lookup

[Valentin_Belets]

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.

[samir.rezk]

Hi @Valentin_Belets 

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,

 

[Valentin_Belets]

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.

[samir.rezk · Accepted solution]

Hi @Valentin_Belets 

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!

Solved: Property set formula property: Lookup value from file - Autodesk Community - AutoCAD Archite...

Also, Dynamic Block lookup table might be a good option, if you're working with Blocks! as opposed to Property Sets.

Hope this helps,

[rl_jackson]

@samir.rezk 

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

[samir.rezk]

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,

[rl_jackson]

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.

[essam-salah]

Hi,

you can do lookup directly from excel using VBA, and lookup value from another Property