Table lookup (for synced table)

The Table Lookup field enables users to select a value from a list based on data stored in another table.

The Table Lookup field type enables users to select a value from a list based on data stored in another table.

This is useful for referencing or linking data from one part of your application to another, ensuring consistency and reducing manual data entry.

Input method: Table lookup

Table

Specify which table the lookup field will reference.

This setting allows you to choose from available tables within your application that contain the data you want to present in the lookup field.

Column

Determine which column from the selected table will be displayed as options in the lookup field.

It allows you to choose the specific column that contains the values users can select from.

For instance, if the table has columns for names and IDs, you might choose the "Name" column to display a list of names for selection, while storing the corresponding IDs in the lookup field.

Validation

For the validation on Table lookup field, you can set:

• Min selection: the minimum number of selections users must choose as the input value.

• Max selection: the maximum number of selections users can choose as the input value.