Skip to main content

Select Data

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

Configuration

To configure Select Data for a collection:

  1. Navigate to AreasGeneral.
  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 users see in dropdowns) and the underlying API results for the collection's select view.

General Settings

View general settings
SettingDescription
Allow Public AccessAllows unauthenticated users to view records in this collection through the select view.
Lazy LoadEnables lazy loading for the select view, improving performance for large collections by loading data as needed.

Display Fields

This section controls what the user sees when selecting a record in a relational field or form dropdown.

  • Display Fields: Select one or more fields to represent the record (e.g., firstName and lastName).
  • Display Fields Separator: Specify the character(s) used to join multiple display fields (e.g., a space or a comma).

Select Fields (API)

Enable Configure Select Fields to define which fields are returned by the Select View API.

info

These settings define the fields available in the generated frontend code when calling the Select View API. They do not change the fields displayed in the Frontend UI dropdowns, which are controlled by Display Fields.

  • Select Fields: Use the multi-select dropdown to choose all fields that should be included in the API response for this collection's select view.

Example: Order Selection

When a user is selecting an Order in a "Return Request" form:

  1. Display Fields: Select orderNumber and orderDate.
  2. Display Fields Separator: Set to - (e.g., "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.