Description:
The lookup control displays a data table; once a row is selected, the data from that row is entered into other Form 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 new Form Definition called “LookupDef.”
- Drag the “BootstrapGrid, Label, Text, LookUp, and Submit” controls onto the canvas and arrange them as shown below.
- In this context, the labels and text boxes will display the User ID, Full Name, and Email ID after a lookup value is selected.
- Double-click the “LookUp” control to configure the “Settings” properties. A pop-up window appears for configuration. Enter a name for the control. Enter the Lookup button text. Click the Save button.
- Select the “Conditions” tab. Select the DB connection from the drop-down list. Enter a SQL SELECT query. Click the plus sign (+) to insert an empty row. Enter the SQL table column and select the mapping Form field. You may include multiple mappings as shown below. Select the “Hide” checkbox to hide this widget at runtime. Select the “Read-Only” checkbox to view the list without making any selection. Click the Save button.
- Select the “Globalize” tab. The application will notify you if there is nothing to globalize, as shown below. Otherwise, select the language from the drop-down list, then click the Translate button. Click the Save button.
- Save the Form definition. Select Actions > Create Form Instance. Generate a new Form Instance, then select the check box to edit it.
- The Form is displayed to the user as shown below. Click the LookUp button.
- The LookUp pop-up window displays the SQL result set as shown below. Select a row, then click the OK button.
- The Form fields are populated as shown below. Click the Submit button to complete the Form. You may click the LookUp button again to reselect.
Definition Sample:
You may download the sample definition(s) from the link provided and later import them (drag-and-drop) into 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 the import. Then, save the definition to confirm the changes.
Click here to download the sample file.