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 configuration affects both the user interface (what you see in dropdowns) and the underlying API results for the collection's select view.

Configuration cards​

CardDescription
Allow Public AccessAllows unauthenticated users to view records in this collection through the select view.
Configure Select FieldsTurn on to configure the fields that will be displayed 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.

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 will appear as results in relational tables and form dropdowns.
  • Filter Fields: Select fields that will be 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.