Tutorial 1: Passing Prompt Information Between Workbooks (Doors)

Tutorial 1: Passing Prompt Information Between Workbooks (Doors)

This tutorial shows you how to configure a subassembly to pass information between the L! workbook (local prompts), and the S! workbook (subassemblies). This example expands on the overview article "Overview: Passing Prompt Information Between Workbooks" and shows how to configure the door subassemblies in a very simple Base Starter Horizontal product to receive and react to the upper-level product prompts for the bay swing. It will demonstrate the simplicity of using this method to establish data communication between workbooks.

In this simple example, we want to pass the data for a prompt named "Bay_1_Left_Swing" from the top-level product prompt to a subassembly named "Base Single Door."

  1. Draw a Base Starter Horizontal
    1. Set the Main.Width prompt to 36.
    2. Set the Main.BayQty prompt to 2.
    3. Set the Bay1.Bay1Options to "Base Single Door" and click the option button for Bay1.Bay1LeftSwing.
    4. Set the Bay2.Bay2Options to "Base Single Door" and click the option button for Bay2.Bay2RightSwing.

    Fig. 1


  2. Click Modify > Edit Design Data and select the product just drawn.
  3. Click the tab Subassemblies and select the row containing the first Base Single Door subassembly.
  4. Add the following text string to the cell in the "Prompt Values" column of the row for the first Base Single Door:
  5. ="Left_Swing;"&Bay_1_Left_Swing&"|Right_Swing;"&Bay_1_Right_Swing

    This formula evaluates to a pipe-delimited list of prompts and values that will be passed from the product prompts to the subassembly prompts. 

    Left_Swing;1|Right_Swing;0

    Fig. 2

    The syntax and definition of each element in the formula are found in the article link in the first paragraph above. Left_Swing in the evaluated formula refers to the subassembly prompt that will be searched for, and if found, populated with the data immediately following the semi-colon (1). The name in the evaluated formula must match the subassembly prompt name exactly for the prompt data to be passed through to the subassembly prompts.

  6. Repeat step #2 above for the next Base Single Door subassembly by adding the following text string to the cell in the "Prompt Values" column of the row for the first Base Single Door:
  7. ="Left_Swing;"&Bay_2_Left_Swing&"|Right_Swing;"&Bay_2_Right_Swing

    Fig. 3


    Left_Swing and Right_Swing in the evaluated formulas refer to the subassembly prompts that will be searched for. If the program finds a subassembly prompt name that matches exactly, the subassembly prompt will be populated with the data immediately following the semi-colon (1). The name in the evaluated formula must match the subassembly prompt name exactly for the prompt data to be passed through to the subassembly prompts. Right-click on the first Base Single Door subassembly and select "Show Subassembly File." Compare the prompt names specified in the subassembly Prompt Values cells with the corresponding subassembly prompts and values in the figures below.


    Fig. 4



    Fig. 5


    In the examples above, the  product prompts  passed to the two Base Single Door subassemblies are named "Left_Swing" and "Right_Swing."  Therefore, the program looks for a  subassembly prompt  named "Left_Swing" in the first subassembly, and if it finds it, it populates the value cell of that prompt with the PROMPT_VALUE parameter that is passed through. It looks for a subassembly prompt named "Right_Swing" in the second subassembly, and if it finds it, it populates the value cell of that prompt with the prompt value. That value may be a hard value or the result of a formula.

    This newly modified product with the prompt data passed product to the subassembly replaces the need for lookup tables and their associated complexity.

  8. Save and close the subassemblies. Access the product prompts and set the bay 1 and bay 2 door swings. Redraw the product. The subassembly door swing is now directly controlled by the parent product prompts and not through the lookup tables.

    • Related Articles

    • Tutorial 2: Passing Prompt Information Between Workbooks (Face Frames)

      This tutorial shows you how to configure a subassembly to pass information between the L! workbook (local prompts), and the S! workbook (subassemblies). The article:  "Overview: Passing Prompt Information Between Workbooks" discusses how the new ...
    • Overview: Passing Prompt Information Between Workbooks (Subassembly)

      We have added the ability to pass custom information from the L! workbook (local prompts) to the S! workbook (subassemblies). Without that ability, the number of prompts is greater, and the complexity of formulas increases. When the formula ...
    • Understanding the Edit Design Data Interface

      The Edit Design Data interface is a spreadsheet editor, similar to Microsoft Excel.  The interface includes tools located at the top of the window. Below the tool icons is a drop-down list of defined names that can be used to locate the cell’s ...
    • Tutorial: Add a Custom Prompt

      This tutorial will give a step-by-step procedure for adding a custom prompt to the existing prompts. For a description of the various prompt properties, please see the information at: Reference: Control Types & Other Prompt Properties For this ...
    • Overview & Tutorials: Edit Multiple Prompts from Drawing

      We are working to improve the usability of Microvellum software. Some of our Users have asked for the ability to edit multiple prompt values from the drawing. This boosts the speed at which the program may be used since the prompts do not require ...
    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...
    • Toolbox Release Notes | Build 24.1.1030.641

      The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...
    • Toolbox Release Notes | Build 24.1.1010.641

      The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...
    • Toolbox Release Notes | Build 24.1.1001.641

      The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...
    • Microvellum Foundation Library Release Notes | Build 24.0919

      The following release notes apply to Microvellum Foundation Library build 24.0919 Additions Added 5 new special Wine Rack products and 9 new Wine Rack Insert subassemblies. Products: Master Vertical Wine Rack Corner Frame Master Vertical Wine Rack ...