Description:
This widget retrieves data from a database and populates 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 onto the canvas and arrange them as shown below.
- Double-click the “FileFormDatabase” widget to configure the “Settings” properties. Enter the name and description for the lookup button text. Select the “Run only on create” checkbox. Click the Save button.
- Navigate to the Configuration tab. Select the connection from the drop-down list. Enter the SQL Select syntax as shown in the example below. 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, then 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 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 any missing configuration steps after import, including file path references and database connections. Then, save the definition to confirm the changes.