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

    • 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 ...
    • 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 ...
    • 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

    • Toolbox Release Notes | Build 24.1.0416.641

      The following release notes apply to Toolbox build 24.1.0416.641. Maestro Toolfile Fix There was an issue with Maestro SCM Toolfiles reportedly experienced by some users, wherein the labels output by autolabeling would be in incorrect positions, an ...
    • Toolbox Release Notes | Build 24.1.0409.641

      The following release notes apply to Toolbox build 24.1.0409.641 Saw Delimited Processing Station Figure 1: The Saw Delimited option in a custom processing station. New options have been added to saw processing stations to allow for control over data ...
    • Toolbox Release Notes | Build 24.1.0328.641

      The following release notes apply to Toolbox Build 24.1.0328.641 Fillet Token Fixes Issues were discovered in the use of fillet tokens on products that also had the IRIB setting enabled: Some users processed work orders with rounded parts, which ...
    • Microvellum Foundation Library Release Notes | Build 24.0322

      Additions Added the Master Angled Ends Cabinet. Added a Global prompt, "Hinge Plate Offset From Front" for easier control. Added “Double Division” option to Horizontal Designer Cabinets, 3 Door Cabinets, and other similar products. Added a new ...
    • Common Floating License Connectivity Issues

      This document lists common issues reported by users regarding the topic of Microvellum’s Floating License Activation (FLA) and the connectivity required for FLA to function. Firewall Blocking Activation of Floating License Some users have had an ...