Form Field Select Report ID

  • Updated on Mar 22, 2023
  • Published on Dec 23, 2022
  • 1 minute(s) read
  • Gina Magana
 Prev Next

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

mceclip0.png

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.