Hello,
I would like to use a multi-value custom iProperty 'item_finish' in the part or assembly model to drive an iLogic rule.
'item_finish' would be 1-24 from the list.
The part file would have an embedded spreadsheet with column A corresponding to the 'item_finish'.
The spreadsheet would have column B containg long text descriptions of the finish process.
The ilogic rule must take the 'item_finish' number, find the corresponding row and then return the B column cell text to a user parameter 'defined_finish'.
The 'defined_finish' parameter can be called in a sketched symbol to describe the finish.
It appears this is all possible, but I cannot find enough information describing the snipped code requiremnets to accomplish the goal.
All help and advice appreciated,
Mark
Solved! Go to Solution.
Solved by MjDeck. Go to Solution.
rowNumber = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "item_finish", "=", item_finish) If (rowNumber <= 0) Then MessageBox.Show("item_finish row not found: " & item_finish, "iLogic") End If defined_finish = GoExcel.CurrentRowValue("defined_finish") iProperties.Value("Custom", "defined_finish") = defined_finish
Mike,
It must take a lot of patience to work this forum. Once I performed the tutorials on iLogic I found most of the answers to my questions. We have a very elegant little solution now. I do have one remaining question however. Is there any way to modify the size of the muti-value window that is presented to the user?
Again, thank you for your time and patience....perhaps it would be alright to 'from time to time' ask the question; did you do the tutorial? Maybe even RTFM!
Regards,
By multi-value window, do you mean the Value List Editor dialog that pops up when you select Edit Multi-Value List in the Parameters dialog? If so, then yes you can control its size. If you resize it once manually it will retain that size the next time you use it.
Or do you mean the drop-down list that you see when you select a value from the list (directly in a cell in the Parameters dialog)? The size of that drop-down can't be set. I think it grows to about 25 items, and above that it will give you a scroll bar. Would you prefer a shorter list, and a scroll bar if you have maybe 10 items or more? What number would you go with?
OK, that's the InputListBox function, called from a rule. I guess we should provide arguments to set the width and height, and maybe also calculate a better default width to fit the contents. You can't do it now, but we should be able to provide that in a future version.