---
title: "Forms - Form Field Select Report ID"
slug: "forms-form-field-select-report-id"
updated: 2023-03-22T22:20:22Z
published: 2023-03-22T22:20:22Z
canonical: "docs.interprose.com/forms-form-field-select-report-id"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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**

![mceclip0.png](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/reportid.png?sv=2026-02-06&spr=https&st=2026-10-31T17%3A50%3A37Z&se=2026-10-31T18%3A50%3A37Z&sr=c&sp=r&sig=mtOOr3wHfDq5TqFSaQymEVhNP7I%2BJoBBxbEdzRM3Ksc%3D)

Here is an example of a custom SQL report used as the source for a Select or Multi-Select Form Field Type:

```
SELECTauth_user_passwd.username AS "identifier",auth_user_passwd.username AS "label",auth_user_passwd.first_name || ' ' || auth_user_passwd.last_name AS "value"FROMauth_user_passwdWHEREauth_user_passwd.user_type = 'USER'AND auth_user_passwd.active = TRUEAND auth_user_passwd.first_name <> 'Agent'
```

<font color="#0000ff" size="2" style="box-sizing: border-box;"><strong style="box-sizing: border-box; font-weight: bold;"><em style="box-sizing: border-box;"><span style="font-family: Arial;">Watch the video below for additional guidance.</span></em></strong></font>