Adding a lookup in the Form Builder transforms a column field into a dropdown that lists all possible values allowed for that field. The process is the same as adding a lookup from the Table Builder.
For a fixed number of values, use an enum data type.
To create a lookup, start the lookup wizard by opening the Form Builder > COLUMNS > navigate to a column > Lookups, and follow the instructions. A lookup must return a single unique column value.
Lookups support single selections only. For multiple value selections, use the set data type.
Demo of adding a lookup in the Form Builder #
