A multiple select field is similar to a single select field; it allows you select predetermined options from a list. Unlike a single select field, however, you can select as many options as you'd like per cell.
on Mac and Ctrl
on Windows with the selection picker window open to quickly add multiple values to a record at once.
When you edit a cell in a single select field, you will be presented with an autocomplete menu. You can select the desired option from the dropdown menu, or type to narrow down the list of options.
Each select option is displayed as a small token that can be removed by clicking the x.
You can reorder your multiple select options from within an expanded cell by clicking and dragging.
You can add, remove, and edit select options in the field customization menu.
You can change the order of the options as they appear in the field customization menu by clicking and dragging on the reorder icons, which appear when you mouse over the left-hand side of each select option.
As with single select, if you find yourself wanting to keep track of more things related to each select option, consider converting the multiple select field into a linked record field. Then, you can have a full record's worth of information for each option.
On the Airtable free plan, you can choose from 7 different colors for your select tokens. On the Airtable Pro plan, you can choose from 40 different colors! Interested in upgrading to Pro to get more colors? Check out our pricing page!
Is it possible to dynamically create new options in a multiple select field?
Yes, you can using a combination of formulas and automations. The general workflow here would be to:
- Setup the formula that would return the value that you'd like to insert into your multiple select (this value would depend on your individual workflow).
- Create a new automation with the trigger, "When a record is updated", and have that trigger watch the formula field you just created.
- Add the Update Record action then, within that action, update your multiple select field with the value from the formula field you previously created.
Now, if your formula field updates with a value that didn't previously exist as a multiple select option—a new option will be created and set on your multiple select field.
When grouping records via a multiple select field with multiple options selected for a single record— can I group on the individual options instead of the combination of those options?
We do not currently support creating customized multiple select options for grouping records. In the meantime, we suggest adding additional views to the table and filtering them to only show records with certain multiple select options. In the example below, you can see how grouping on a multi-select field gives poor results. In this case, adding views that filter exactly what you're looking for works better than grouping.