Greetings,
I have a question regarding Content Center.
I have to standardize the Part Number for our Stainless Steel Tube family so that when we create a new length, the Part Number should end with five numbers, so that the first two correspond to the tens and ones before the decimal points, and the last three correspond to the tenths, hundredths and thousandths after the decimal points (ex: a 0.5" long tube would end with -00500, a 6.75" long tube with -06750 and a 36.375" long tube with -36.375).
On Excel, I can easily use formulas such as ROUND(), LEN() and IF() to obtain the desired results. Unfortunately, inside the Family Table of the Inventor when I edit Content Center, I cannot use the formulas directly in the column's expression, Edit via Spreadsheet won't work because the cells turn back to Text format after leaving. I even tried Replacing the Family Template to an identical Tube Template, but with an added Model State to unlock the Edit via spreadsheet to use the formulas and add Text Parameters, but once I place the components, the values are not updating. I also cannot Right-Click in the iLogic tab of the copied Template to add Rule.
I would really need help to understand what is the best way to proceed, or if what I am trying to achieve in Content Center cannot be done with the tools at hand.
Thank you and have a nice day,
Jérôme
