Skip to main content

Select Data

Select Data defines how records from a collection are presented and retrieved when used as options in relational fields or lookup dropdowns.

Select Data settings​

To set up Select Data for a collection:

  1. Go to Areas → General.
  2. Click Collection Configuration on the collection you want to modify.
  3. Select the Select Data tab.

Reference​

This affects both what you see in dropdowns and the underlying API results for the collection's select view.

Configuration cards​

Select Data has these configuration cards:

CardDescription
Allow Public AccessAllows unauthenticated users to view records in this collection through the select view.
Configure Select FieldsTurn on to choose which fields appear in the select dropdown.
Lazy LoadTurn on to enable lazy loading for this collection's select view. This reveals additional performance settings.
Apply ScopeDefine who can access records in the select dropdown and under what conditions. See Apply Scope for details.
warning

To include a relational field in an auth collection's Register Form, turn on Allow Public Access in the Select Data config of the related collection. The registration form loads before a visitor signs in, so without public access the related records can't be fetched and the register form crashes.

Lazy Load settings​

Visible when Lazy Load is enabled.

SettingDescription
Page SizeNumber of records to fetch per page.
Max RecordsMaximum number of records to return.
Debounce Search (ms)Time in milliseconds before search triggers after you stop typing.
Min Search LengthMinimum number of characters before search debounce activates.
  • Display Fields: Select fields that appear as results in relational tables and form dropdowns.
  • Filter Fields: Select fields used as allowed query filters for the Select Data API.
  • Select Fields: Visible when Configure Select Fields is enabled. Select fields to use in the select view.

Example: Order selection​

When you are selecting an Order in a "Return Request" form:

  1. Display Fields: Select orderNumber and orderDate.
  2. Display Fields Separator: Set to - (for example, "ORD-101 - 2023-10-25").
  3. Select Fields (API): Include customerId and totalAmount so that the frontend code can access these order details immediately after the order is selected, without making another API call.