Form Field Select Report ID

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.