Skip to main content

Single select & multiple select fields

Let people pick one or more options from a list. Add options, give them colors and descriptions, paste them from a spreadsheet, and choose how they look.

Written by Leo

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.

The single select field Investment stage in a record with its colored options open, such as Sourcing, Under contract, and Due diligence

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 access to the database app to create options. People with edit access to a record can choose from the options.

Add a select field

  1. Open the database app, open the app menu, and select Customize record layout.

  2. Click + or type / in a text block.

  3. Under New field, select Single select or Multi select.

  4. Click the drag handle (⋮⋮) of the new field and select Edit field.

Opening Customize record layout from the app menu, clicking + next to a field, and pointing at Single select, then clicking Multi select under New field so the new field appears in the layout

Clicking the drag handle of the single select field Investment stage in the layout editor and selecting Edit field

Add options

In Edit field, the section Options lists the options of the field.

  1. Click + next to Options. If the field has no options yet, select Add option.

  2. Enter a name under Add a new option….

  3. Repeat for every option you need.

Clicking + next to Options in the Edit field menu of the single select field Investment stage, typing Refinancing under Add a new option…, and pressing Enter so Refinancing appears as a colored option at the top of the list

The Edit field menu of the single select field Investment stage with its colored options under Options

The option Duplex of the select field Property type opened in the field menu, with its name, Delete, and the Colors list

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, or Red.

  • Select Add option description to add a short explanation under Add description….

  • Select Delete to remove the option. Tape asks Delete category option? first.

Field settings

  • Sort: the order of the options. Choose Manual, Alphabetical, or Reverse alphabetical.

  • Show option icon: shows the icon of each option next to its name.

  • Default: the option a new record starts with. Select Select default option….

The Sort setting of a single select field open with Manual, Alphabetical, and Reverse alphabetical

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 buttons and Buttons: all options as buttons.

  • Radio buttons for a single select field, or Checkboxes for a multi select field: all options as a list.

  • Checkbox: only for a single select field. Shows the field as one checkbox.

The Edit field display menu of a single select field with Display as open, showing Dropdown, Inline buttons, Buttons, Radio buttons, and 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.

Opening the dropdown of the single select field Property type in a record, typing pl so only Duplex and Fourplex are left, and selecting Fourplex

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 →

A board view of Properties with one column per option of the select field Investment stage

FAQs

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?

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?

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?

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?

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?

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 →.

Did this answer your question?