Configure lookup

Field lookup maps a key–value structure from a shared table definition to a field. This allows reference data to be reused consistently across applications while displaying user-friendly values in list and table fields.

Configuration applies to:

Business use cases

Field lookup supports reuse of shared reference data while maintaining clean, readable lists. Key scenarios include:

  • Data normalization: Map reference data from shared tables into list templates.

  • Consistency across datasets: Ensure aligned values across multiple data sources.

  • Simplified maintenance: Centralize value definitions while reusing them across apps.

Prerequisites

  • You have configured a table definition to use for the lookup in the Table Definition tool.

Procedure

The following procedure uses the example of an asset inventory list to display readable Asset Category names while internally storing standardized category keys sourced from a central reference table.

  1. In the Application tree, select the table or list field that should display lookup values.

  2. In the Settings/properties pane, in the Value section, set Source to Lookup.

    The Lookup Table field appears.

  3. Open the lookup configuration by selecting the Settings icon next to the Lookup Table field.

  4. In the Lookup dialog that opens, select the table definition that contains the reference key-value data in Table.

    Example: Select an AssetCategories table containing CategoryID and CategoryName.

    Result: The lookup table definition source is defined.

  5. In Text Field, select the field from the chosen table definition that should be displayed in the list.

    Example: Select CategoryName.

    Result: Users see readable category names instead of internal IDs.

  6. (Optional) Select Hide Key Value if you do not want to display the underlying key.

    Result: Only the descriptive value is displayed, while the key remains stored internally.

  7. In Field Mapping, match the source field from the adaptive list to the corresponding target field in the table definition and select Use.

    Result: The lookup relationship between the list field and the reference table is established.

  8. In the Shell bar, select Save.

  9. In the Preview pane, open the adaptive list and confirm that values are displayed using the configured lookup text field and that the underlying key values remain mapped according to the field mapping.

Result

  • You have configured a field lookup that maps reference data from a shared table definition and displays consistent values in an adaptive list.

Related topics