- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Select elements
- Apply to Select & Multi-Select form field types
- Determine the Label, Value and Identifier associated with Select & Multi-Select form fields
- Are entered, by default, in a list associated with the Select or Multi-Select form field
Select Report ID
- Allows a SQL report to be chosen as a source for the Select Element list
- Is an alternative to manually entered select element lists
- Requires SQL columns for the Label & Value
- Optionally may include an Identifier for each select element
Setup
A SQL report can be selected as the source for select list elements under Setup - Forms - Form - Select Field - Select Report ID
Here is an example of a custom SQL report used as the source for a Select or Multi-Select Form Field Type:
SELECT
auth_user_passwd.username AS "identifier",
auth_user_passwd.username AS "label",
auth_user_passwd.first_name || ' ' || auth_user_passwd.last_name AS "value"
FROM
auth_user_passwd
WHERE
auth_user_passwd.user_type = 'USER'
AND auth_user_passwd.active = TRUE
AND auth_user_passwd.first_name <> 'Agent'
Watch the video below for additional guidance.
Was this article helpful?