By selecting this column type, you can retrieve information from a custom property in the SOLIDWORKS document. For this column type, if you change the value in the bill of materials, it will automatically be updated in the 3D documents.

You can use the "$" character to retrieve the property name and the "& " character to concatenate multiple properties.

For this type of column—and only for this type—you can define a list that suggests values when editing the bill of materials.

Filling in the " Default Value " field allows you to set a value in the column if the component's property has not been specified. If the field is left blank and the property has not been specified in the 3D file, then the column will remain blank.


-->  


You can use conditional statements ( IF) to retrieve properties. The syntax is the same as that used in the SmartProperties tool.


 


The " IIF " syntax can be written in uppercase or lowercase as " iff ". The “|” character is typed by pressing the “AltGr” and “6” keys together. To retrieve a property, place the “$” character before the property name (case-sensitive).


Example: IFF($Material=Steel|Polishing|Painting)

If the " Material " property is equal to " Steel," then the cell in that column will be equal to " Polishing "; otherwise, the cell in that column will be equal to " Painting."