DBlookup
See above for Name, Width, Offset, Value, and Datasource.
Note: You can link the DBLOOKUP field to a datasource created in Form Studio, which can connect to a database table. This supports parent-child DBLookups and works consistently across all platforms, including the Self-Service Portal.
- ID Field
- This is the value that is sent to the backend. For example, if you have a datasource that is pulling employees, you can specify a value of 3.
- Label Field
- The label field that is visible in the DBLOOKUP. For example, you can specify User.
- Display Fields
-
The display fields in the DBLOOKUP.
This field can contain multiple values. Use either a comma (,) or pipe (|) to separate each value. For example:
emp_name,emp_fullname
emp_name|emp_fullname
- Multi Choice
-
Use this check box to create forms that allow the end user to select multiple values in forms rendered in the main application and the Self Service Portal.
Note: The selected values can also be used within any script extension that may be required for the custom form.