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."
- Draw a Base Starter Horizontal
- Set the Main.Width prompt to 36.
- Set the Main.BayQty prompt to 2.
- Set the Bay1.Bay1Options to "Base Single Door" and click the option button for Bay1.Bay1LeftSwing.
- Set the Bay2.Bay2Options to "Base Single Door" and click the option button for Bay2.Bay2RightSwing.
Fig. 1
- Click Modify > Edit Design Data and select the product just drawn.
- Click the tab Subassemblies and select the row containing the first Base Single Door subassembly.
- Add the following text string to the cell in the "Prompt Values" column of the row for the first Base Single Door:
="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.
- 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:
="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.
- 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
Toolbox Release Notes | Build 24.1.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...
Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...
Toolbox Release Notes | Build 24.1.1125.641
The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...
Toolbox Release Notes | Build 24.1.1105.641
The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...
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 ...