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
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
Microvellum Foundation Library Release Notes | Build 26.0220
The following release notes apply to the Microvellum Foundation Library build 26.0220. Additions Added DTC Magic Pro and Magic Star Ultra drawer systems. Magic Pro Items added in hardware file 300 and 600 lengths for all drawer heights. Add 60kg ...
Microvellum Release Notes | Build 25.2.0223.641
The following release notes apply to Microvellum build 25.2.0223.641. Add 2D Elevation Tokens to 3D Drawings Fig. 1: The new 2D Elevation setting. A popularly requested feature by the community has been added to the Microvellum software: the checkbox ...
Microvellum Processing Center Application
The standalone Processing Center application provides shop-floor tools for managing and executing manufacturing data generated from Microvellum projects. It enables users to: Print part labels View and print reports Create and re-create manufacturing ...
Microvellum Release Notes | Build 25.2.0213.641
The following release notes apply to Microvellum build 25.2.0213.641 File Name Fix An issue was occurring when processing work orders with the Create Sequential File Names setting enabled. When the setting was enabled, a work order being processed ...
Microvellum Release Notes | Build 25.2.0206.641
The following release notes apply to Microvellum build 25.2.0206.641. Item Number Fix An issue was reported regarding item numbers in composite drawings. Users who processed work orders with multiple products reported that the item numbers would ...