Cannot have proper Formulas and Expressions in Content Center Family Table

Cannot have proper Formulas and Expressions in Content Center Family Table

jeromeQTZLB
Participant Participant
253 Views
1 Reply
Message 1 of 2

Cannot have proper Formulas and Expressions in Content Center Family Table

jeromeQTZLB
Participant
Participant

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

0 Likes
254 Views
1 Reply
Reply (1)
Message 2 of 2

jan_priban
Alumni
Alumni

Hi Jerome,

 

there are more ways how to work with parameters, custom iProperties. There are more related topic on the Inventor forum... What are the possibilities:

 

- Modify family table, define expression to ROUND, FLOOR, CEIL tube length parameter. Than define Part Number using such expression

https://help.autodesk.com/view/INVNTOR/2025/ENU/?guid=GUID-EE98BCED-5623-4E3B-9E98-432C6738B081

https://forums.autodesk.com/t5/inventor-forum/content-center-filename-part-number-length-precision-a...

https://forums.autodesk.com/t5/inventor-forum/content-center-table-math/td-p/12522075

 

- Define user parameter in family template using ROUND, FLOOR, CEIL functions and export it + set format of exported parameter. Than define Part Number using such exported iProperty

https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-round-up-th...

 

- Define iLogic rule in family template - iLogic can do almost everything. This is my best way. Steps described here

https://forums.autodesk.com/t5/inventor-forum/content-center-custom-description-with-length-fails-wh...

 

The iLogic rule could be like:

 

Dim PartNumber_G_L As Double
PartNumber_G_L = Parameter("G_L") * 1000
Dim sPartNumber_G_L As String
sPartNumber_G_L = PartNumber_G_L.ToString("00000")
iProperties.Value("Project", "Part Number") = "Modified_" & sPartNumber_G_L
InventorVb.DocumentUpdate(False)

 

Code needs to be run automatically, best way is trigger = OnBeforeSave

 

As described in the (https://forums.autodesk.com/t5/inventor-forum/content-center-custom-description-with-length-fails-wh...) you can reference B_L parameter in your Part Number -B_L is always same and you may want to have same part Number, or G_L that get changed by any Frame Generator modification (Trim, Notch command) = reflects current frame / tube length (that can be change by end treatment operation / command)

 

Regards

 

Jan Priban