Similar to a single select field, a multiple select field lets you choose from a list of predefined options. However, unlike a single select field, you can choose as many options as you want for each cell. This doesn’t create two fields, but rather a field with two entries in it.
To create a single select field, add a new field with the + button and select the Multiple select type from the dropdown menu.
An autocomplete menu will appear when you edit a cell in a multiple select field. You can input to limit the list of alternatives or choose the desired option from the dropdown menu.
A small token representing each choice option is shown and can be removed from the row by clicking the x
.
In the multiple select field customization menu, you can add, remove, reorder and update a selection of choices.
A multiple-select field can save time when edits need to be made. For example, if you have a multiple select field that contains ‘red’, ‘blue’ and ‘yellow’ but decide that ‘yellow’ should really need to be ‘green’, you only need to change this once. As soon as the change has been made, all the records that reference ‘yellow’ will be changed to ‘green’. You don’t need to re-enter the values yourself. This can save you lots of time, especially if you’ve already got hundreds of records with ‘yellow’ as a value in the field.
To create a new multiple select option,
Alternatively, add new select options on the fly as you’re filling out the cells without going to the field configuration menu. You can create a new select option by typing in the name of the option you’d like to create and selecting the ‘+ Create new option’ button. New multiple select fields will be added automatically whenever a new, unique value is entered in the designated field.
You can also reorder the select options by clicking and dragging on the reorder icons, which appear on the left-hand side of each select option.
You can also delete a select option by clicking on the x
icon, which appears on the right-hand side of each select option. Note that when you delete a select option, the option will be removed from any cell configured.
You have a choice of 15 different colours for your select options.
If you want to limit the information related to each select option, consider converting the multiple select field into a single select field.
Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.
Contact support for questions about Baserow or help with your account.