Description:
This widget renames the 'label’ control of the form by querying the database when the page loads.
Inputs
- None
Design:
Example:
Let’s build and execute the “LabelFormDatabaseDef” example.
- Create a Form Definition called “LabelFormDatabaseDef.”
- Drag a “Label, Radio, LabelFormDatabase, and Submit” control to the canvas and arrange them as shown below.
- Double-click the “LabelFormDatabase” widget to configure its “Settings” properties. Provide a name and select the database connection from the drop-down list. Enter the SQL Select query as shown in the example below. Check the box to “Hide” the control during runtime and select “Run only on create.” Click the Save button. Repeat this process to configure all “LabelFormDatabase” widgets as described here.
- 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 labels 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.