Property Equals Another - Two Properties in BOM

Hi all

In my Solidworks 2017 custom properties file, I have defined two separate properties which are the part number (133 06 01) and its index (-C). Unfortunately, I can't bring them together in one property. My problem lies in the nomenclature of an assembly that contains this part. In the nomenclature, I can only display one property per column. So I'm looking to either display two of them (number + subscript) one after the other, or to create a custom property that would be the concatenation of the two previous properties, in order to be able to display the latter in the nomenclature. At the moment I am forced to fill in these boxes of the bill of materials by hand, which greatly increases the risk of error.

I hope I have been clear enough. Thank you for your help.

Have a nice day

Raphael.

 


proprietes_solid.jpg

Hello

Logically you can easily add a column and display the "index" property

Right-click on the BOM -> insert -> Column

Then double click on the box above your new column, and choose the property you want to display.

 

 

Hello

There, from what I understand, you have your two columns following each other (name + clue). It all depends on which column you want to keep to concatenate your properties in. To concatenate them, you just have to select the whole column by clicking 1x, then you select the acronym of equations, then the window opens with the beginning of an equation that you have to delete. There you go to custom properties and you look for your properties to concatenate with the formula that works well...

1 Like

Hello

For me, the easiest way is to create a custom property which is the concatenation of the other 2 and then display it in the BOM column.

To do this, you can add a text box in your property form based on the following principle:

Of course you have to change the values according to your needs, for you it should look like $PRP:"Numéro_prt_asm"-$PRP:"Index" and then you link your nomenclature column to the NumPlusIndex property.

Kind regards

2 Likes

•Guillaume

Thank you but the goal was to avoid a "hint" column that would be empty most of the time.

• D.Roger,

It was the first solution I thought of but I never managed to make it work. Each time, my property keeps the value $PRP:"Numéro_prt_asm"-$PRP:"Indice_prt_asm". I made sure to save and update everything several times... Thank you.

• Cobra 427,

This solution is the one I have been looking for for a while but I didn't know how to go about it, thank you very much. However, I can't seem to get it to work properly either. I get either this or this (see attachment). Any idea ???

Thank you very much

Raph


sol_ok_3.jpg

Which "Values/Text Expression" do your variables "Numéro_prt_asm" and "Indice_prt_asm" use in your custom properties?

If these variables already use computed values such as "$PRP:"SW-File Name" or others, then it seems to me that it's normal that it doesn't work. Then put your original values directly without going through the intermediate variable (see the difference between NumPlusIndex and NumPlusIndex2 below).

Kind regards

1 Like

Hello

Due to the too limited possibilities with the BOMs under SW and the possible formulas, we went through a development that manipulates the BOM in excel. This is very constrained, but it opens the door to a multitude of possibilities behind it.

 

Thank you very much d.roger it works perfectly!

and thank you A.Mendes, but we chose not to work with the BOMs in Excel format, which are (for our taste) too difficult to handle.

Kind regards

Raphael