Description:
This widget retrieves data from a database and fills the Form fields when the form page loads.
Inputs
- None
Design:
Example:
Let’s build and execute the “FillFromDatabaseDef” example.
- Create a Form Definition called “FillFromDatabaseDef.”
- Drag a “Label, TextBox, FileFormDatabase, and Submit” control to the canvas and arrange them as shown below.
- Double-click the “FileFormDatabase” widget to configure the “Settings” properties. Provide the name and description for the lookup button text. Select the checkbox to “Run only on create”. Click the Save button.
- Navigate to the Configuration tab. Select the connection from the drop-down list. Provide the SQL Select syntax as shown in the example below. You need to map the SQL “Query Field” to the "Form Controls". Click the Save button.
- Save the Form Definition. Select Actions - Create Form Instance from the menu. Generate a new form instance and check the box to edit it. The page will then display as shown below. The form fields are populated and displayed when the page loads.
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 any missing configuration steps after import, such as file path references and database connections. Then, save the definition to confirm the changes.