Select List

Select List columns configuration includes:

Data source
- Select 'Custom values' to create your own options, then add them in the input field under Options (manually or via CSV import).
- Select an external database from which to import the selected options. A database connection is required first for this option to be displayed
- Select list option can contain a maximum of 100 characters.
Maximum number of selected options
Turn your select list into a single-select field by setting '1'
Any set number that is >1 will make the field a multi-select.
Unique values
Check the box to hide the option from the select list drop-down if it is already selected in the table at least once.
Cascading Select
Default value
Pre-fill cells with one of the options.

Configuration screen for a new select list column

It is also possible to import Select List options from a CSV file. To do this, prepare a CSV file in the following format:

name 
Option 1 
Option 2 
Option 3

Each row under the name column will be imported as a separate Select List option.

If a select list option includes a comma, wrap it in double quotes in the CSV file to ensure it's treated as a single value during import.