A Single select field lets people pick one option from a list you define. A Multi select field lets them pick one or more. Select fields are meant to help you keep answers consistent, for example a property type, a lead source, or a department.
Note:
Deleting an option deletes its values. Tape removes the option from every record in the database app, and you can't undo it.
You can convert between single select and multi select. Learn more about changing a field type →
Who can use select fields?
Select fields are available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.
You need
Full accessto the database app to create options. People with edit access to a record can choose from the options.
Add a select field
Open the database app, open the app menu, and select
Customize record layout.Click
+or type/in a text block.Under
New field, selectSingle selectorMulti select.Click the drag handle (
⋮⋮) of the new field and selectEdit field.
Add options
In Edit field, the section Options lists the options of the field.
Click
+next toOptions. If the field has no options yet, selectAdd option.Enter a name under
Add a new option….Repeat for every option you need.
To add many options at once, paste a list copied from a spreadsheet into Add a new option…. The tooltip of + reads "Type or paste in new options from a spreadsheet."
Tape gives every new option a color automatically and prefers colors the field doesn't use yet. You can change the color at any time.
To change an option:
Drag it by its handle to change its place.
Choose a color under
Colors:Default,Grey,Brown,Orange,Yellow,Green,Blue,Purple,Pink, orRed.Select
Add option descriptionto add a short explanation underAdd description….Select
Deleteto remove the option. Tape asksDelete category option?first.
Field settings
Sort: the order of the options. ChooseManual,Alphabetical, orReverse alphabetical.Show option icon: shows the icon of each option next to its name.Default: the option a new record starts with. SelectSelect default option….
Choose how the field looks
In Edit field display, Display as sets how people choose an option:
Dropdown: a list that opens when selected.Inline buttonsandButtons: all options as buttons.Radio buttonsfor a single select field, orCheckboxesfor a multi select field: all options as a list.Checkbox: only for a single select field. Shows the field as one checkbox.
For a dropdown, Dropdown style can be Badges or Text only. Learn more about field display →
Choose an option in a record
When the field is shown as a dropdown, click it in the record. A list of the options opens. Start typing to narrow the list down. While nothing is selected, the search box reads Search for an option…. If nothing matches, the list reads No options found. Then select an option:
In a single select field, the option you select replaces the current one.
In a multi select field, you can select several options.
With buttons, radio buttons, or checkboxes, all options are visible, and you select them directly.
Use select fields in views
You can filter, sort, and group views by a select field. For example, a board can show one column per option. Learn more about the board view →
FAQs
Can I paste a list of options from a spreadsheet?
Can I paste a list of options from a spreadsheet?
Yes. Copy the cells in your spreadsheet and paste them into the field Add a new option….
Can I create an option from the record?
Can I create an option from the record?
Yes, if you have Full access to the database app. Without it, the Add option button of an empty field is disabled and reads "You need full access to create options" when you point at it.
What happens to records when I delete an option?
What happens to records when I delete an option?
The option is removed from every record. Tape warns you before it deletes it.
Can I convert a single select field to a status field?
Can I convert a single select field to a status field?
Yes, with no loss of values. A database app can have one Status field. Learn more about the status field →
Should I use a select field or a status field?
Should I use a select field or a status field?
Use Status for the progress of a record, because its Show in focus setting can bring assigned records into your focus. Use Single select for everything else. Learn more about the status field →
Are there other field types?
Are there other field types?
Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →
Still have more questions? Find answers and get help from community experts in the Tape community →.
