match/convert attribute with another attribute with lookup

[djurk_haas]

Hello,

I have a block with some attributes. One of the attributes presents masterdata (ID) of a database.

This attribute contains e.g. the following ID’s: 001, 002, or 0003. These values you can be chosen from a lookup (lookup table matches the table in the database).

The software, which uses the database, reads the data (attribute with ID) from the drawing and converts these ID’s automatically to:

0001 = A

0002 = B

0003 = C

In my drawing I also want to have an attribute which converts automatically 0001 to A , 0002 to B etc. because the people who only receives a drawing don’t know the meaning of the ID’s but do understand the meaning of A,B and C.

Is this possible with a field?

[leothebuilder]

Maybe you can use a Block Table in lieu of a LookUp?

In the block table you can enter the values 0001, 0002 etc.

Add a column where you can add corresponding values A, B, C etc.

Add an attribute that extracts A, B, C etc. from this block table column.

[Anonymous]

According to this thread, you can create IF statements using Diesel - but I think Diesel can't reference object attributes, only file properties eg filename, layout tab name, author etc.

This thread refers to lookup tables which might help?

or you could look in the app store to see if there's anything which extends the usability of autocad fields/tables to be more like excel (proper conditional IF statements etc)