Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
WCrihfield
in reply to: arkelec

Hi @arkelec.  The best way to see what you need to see and understand it better is to right-click on the iPart factory table in your model browser tree, then select 'Edit via Spreadsheet...' option.  Within that spreadsheet you can see that when a column for an iProperty is present, it has extra text to the right of its name, like "Part Number [Project]", instead of just "Part Number".  That extra text is the short iLogic version of the PropertySet name that the iProperty is associated with (the name you would specify when using the iLogic shortcut snippet 'iProperties.Value()'), but within brackets.  That is one little complication to keep in mind.  What really sucks in this case is that the iPartTableColumns.Item property will only accept an Integer as input, instead of a String, so you would have to use a 'For Each' or 'For i As Integer = 1 To #' type loop to loop through the columns, to check which one you have.  So, if you need to work with specific columns, and maybe don't want to specify that odd name, you might want to include a loop of the columns, and check if the Heading of the column .StartsWith() a specific name for each one before using it as needed.

Wesley Crihfield

EESignature

(Not an Autodesk Employee)