Description:
The lookup control displays a data table; once a row is selected, data from the selected row is entered into other fields.
Inputs
- ID/Name - Name of widget generated by FlowWright
- Lookup Button Text - Enter the description text for the lookup button
- Select Connection - Choose the connection string (previously configured)
- Select Query - Enter a SQL Query
- Field Mappings - Map the query field with form fields for display
- Hide - Select the checkbox to Hide (tick mark)
- Read Only - Select the checkbox to Read-Only (tick mark)
- Save - Save the input values
- Delete - Remove this form widget from the designer page
- Close - Close the input popup window
Design:
Example:
Let’s build and execute the “LookUpDef” example.
- Create a Form definition called “LookupDef.”
- Drag the “BootstrapGrid, Label, Text, LookUp, and Submit” controls to the canvas and arrange them as shown below.
- In this context, the labels and text boxes shall store the User ID, Full Name, and Email ID after selecting a lookup value.
- Double-click the “LookUp” control to configure the “Settings” properties. A pop-up window is displayed for configuration. Provide a name for the control. Provide the Lookup button text. Click the Save button.
- Select the “Conditions” tab. Select the DB connection from the drop-down list. Provide a SQL Select query. Click the plus sign (+) to insert an empty row. Provide the SQL table column and select the mapping Form field. You may include multiple mappings as below. Select the “Hide” checkbox to hide this widget during runtime. Select the “Read-Only” checkbox to view the list and not make any selection. Click the Save button.
- Select the “Globalize” tab. The application will alert you if there is nothing to globalize, as shown below. Otherwise, select the language from the drop-down list and click the Translate button. Click the Save button.
- Save the Form definition. Select Actions - Create Form Instance menu option. Generate a new Form instance and select the check box to edit this Form instance.
- The Form is rendered to the user as below. Click the LookUp button.
- The LookUp popup window displays the SQL result set as below. Select a row and click the Ok button.
- The Form fields are populated as below. Click the Submit button to complete the form. You may click the LookUp button again to redo the selection.
Definition Sample:
You may download the sample definition(s) from the link here and later import them (drag-and-drop) to your FlowWright Process Definition (XML file) or Form Definition (HTML file) page.
NOTE: Please verify and complete the process steps for any missing configurations, such as file path references and database connections, after import. Then, save the definition to confirm the changes.
Click here to download the sample file.