Description:
This widget renames the 'label’ control on 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 onto the canvas and arrange them as shown below.
- Double-click the “LabelFormDatabase” widget to configure its “Settings” properties. Enter 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 “Hide” box to hide the control at 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, then 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 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.