Lookup Tables

Lookup tables are key-value data tables that can be referenced from LOOKUP() expressions in the Designer. They are useful for mapping codes to display names, storing static reference data, or providing configuration values that change infrequently.

Navigate to Settings > Lookup Tables to manage tables.

Creating a Lookup Table

1. Click New Table
2. Enter a name (e.g. “StoreLocations”, “StatusCodes”)
3. Optionally enter a description
4. Click Create

The table is created with no data. Click the edit icon to start adding columns and rows.

Editing Table Data

Click the pencil icon on any table to open the inline data editor.

Adding Columns

1. Type a column name in the “Column name” field at the bottom of the editor
2. Press Enter or click Add Column
3. New tables start with key and value columns by default

Adding Rows

Click Add Row to add a new empty row. Click into any cell to edit its value.

Removing Columns and Rows

• Click the X icon next to a column header to remove the column
• Hover over a row and click the delete icon to remove it

Saving Changes

Click Save to persist your changes. Click Cancel to discard unsaved edits.

Using LOOKUP() in Expressions

Reference a lookup table from any data-bound element in the Designer using the LOOKUP() function:

LOOKUP("StoreLocations", key_column, match_value, return_column)

Example

Given a table named “StatusCodes”:

The expression LOOKUP("StatusCodes", "code", ${status}, "label") would return “Operational” when the bound status value is “OK”.

Deleting a Table

Click the delete icon on any table in the list. A confirmation prompt appears before the table is permanently removed.