Jump to content

Dynamic Block Lookups and Data Extraction


Recommended Posts

Posted

Hello,

 

I am working on creating a dynamic block with lookup parameters and/or visibility filters.

 

I am trying to achieve a block that can do the following:

- be one of a series of different materials (Sheet PVC, Melomine, Masonite, etc.) selected through a lookup named 'material'.

- for each of these materials there are a set of different colours available also achieved with a lookup named 'colour'. this lookup is actually a list of all the available colours in one list.

- report the material and colour in a data extraction that is exported to Excel.

 

I have had the success of getting it out... but would like to take this a step further...

 

What I would like to do is have the 'colour' lookup filtered by the 'material' lookup to only display those colours that are available for the material. This will reduce the possibility of errors through selecting a colour that is not available for the selected material.

 

I was able to get close to this using a visibility filter for the material, and a number of lookups for the colours of the different materials individually, but the problem with this approach was that each material colour needed a unique name, and therefore created another column in the data extraction (I am currently at 8 different materials).

 

Anny suggestions would be appreciated. BTW I am trying to avoid any actual programming if at all possible as I am not a coder...

 

I am attaching a drawing that has two blocks (test1 and test2). Test1 has the visibility filter and Test2 has only lookups.

 

Thank you,

Todd

 

AutoCAD Version 2011

Material - Colour Data Extraction.dwg

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

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