• Blog posts

    Bio

    By Anite Ramgi

    cover_art.png

    I previously wrote a blog about a workaround which changes text according to the part size. However this workaround requires the user to go to the embedded excel sheet and change the parameter value, which can be tedious.

    You can simplify the process by using a form to drive the part.

    From the Parameters manager, add a new parameter. I have called mine ACE.

    parameter.png

    The original iLogic script needs to be amended to the below:

    iLogicVb.UpdateWhenDone = True

    GoExcel.CellValue("3rd Party:Embedding 1", "Sheet1", "B1") = ACE

    MultiValue.List("ACE") = GoExcel.CellValues("3rd Party:Embedding 1", "Sheet1", "C6", "C9")

    Description=GoExcel.CellValue("3rd Party:Embedding 1", "Sheet1", "B3")

    GoExcel.Save

    GoExcel.Close

    After copying the script, click Save & Run. 

    The last step is to create the form, where the ACE parameter will need to be inserted onto the Form Design Tree. 

    form.png

    Now whenever the parameter changes through the form, the part and description will change accordingly. 

    DEMO.GIF

    The key to this workaround is the iLogic script. From the above script, line 2 writes the length value from the parameter ACE to the excel sheet, while line 4 writes the description parameter from the excel sheet to the part via the parameter manager.

    Line 3 turns the ACE parameter from a single to a multi-value parameter. Please note "C6", "C9" reads the values to make the multi-value parameter.