Single Select

Use the Single select field to select one option from a predefined list. Use it for fields such as status, priority or category.

Ask NocoAI

Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.

Add a [Status] field with the options [Backlog, In Progress, Review and Done]
Suggest options for a [Stage] field in this table
Change [field name] to a single select using the values already in it

Create a Single select field

Click the + icon next to the last field in your table.
Enter a name for the field.
Select Single select from the list of field types.
Click Add option to add the available options.
(Optional) Select a default value for the field from the options.
Click Save Field. NocoDB adds the field to your table.

Refer to the general guidelines on creating a field.

✨✨✨ NocoAI can help you generate options for your Single select field. Click the Auto Suggest button. NocoAI suggests options from your field name and existing options.

Edit options

Rename options

To rename an option, click its text box and type the new name. To save the changes, click Save Field.

Configure colors

Give options background colors to make them easy to tell apart. For example, make High red to show that it is urgent.

Click the color icon next to an option. The picker opens.
Select a color. The default colors are a grid of hues in four shades, from light washes to deep tones. Every swatch is easy to read in light mode and dark mode.
To select a different color, switch to Custom colours.
To save the changes, click Save Field.

Reorder options

To reorder options, drag and drop them with the drag icon. The dropdown in the cells shows the new order.

The order you define for options is preserved in the cell dropdown list.

Turn on the Alphabetize toggle to sort the options A to Z. NocoDB saves the alphabetical order with the field, and the cell dropdown shows it. While Alphabetize is on, you cannot reorder options manually.

Delete options

To delete an option, click the x icon. Before you save, you can restore deleted options with the undo icon.

When you remove an option, NocoDB clears it from all cells that have it. If the deleted option is the default value, NocoDB clears the default.

Cell display

The Single select field shows as a dropdown in table cells. The dropdown shows the configured options with their colors. You can select only one option at a time.