Guide to Using Single Select Field Feature in AirSheet

Feature Summary

The Single Select field is one of the basic field types in a data sheet. It allows you to select one option from a preset range to fill in a cell, making it suitable for scenarios requiring categorical constraints, such as project status, affiliated team, and region classification.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction

Steps

Create a Single Select Field

Feature Entry
「+」 button on the right side of the header → 「Single Select」 option

1. Click the 「+」 button on the right side of the header
2. Select 「Single Select」 from the pop-up field type list
3. Settings options, enter the field name and click 「OK」 to complete creation

Add and Edit Options

Feature Entry
Right-click 「Field Title」 → 「Field Settings」 → 「Option List」 area

1. Right-click the Single Select field title and select 「Field Settings」
2. Click 「+ Add Option」 in the option list area to add a new option
3. The sheet will automatically assign distinguishing colors to different options
4. Click the square button in front of an option to modify its display color

Batch Edit Options

Feature Entry
Right-click 「Field Title」 → 「Field Settings」 → 「Batch Edit」 button

1. Right-click the Single Select field title and select 「Field Settings」
2. Click the 「Batch Edit」 button in the option list
3. Enter one option name per line in the text box; pasting will Batch Generate options
4. After confirmation, click 「OK」 to save

Set Allow Adding Options During Entry

Feature Entry
Right-click 「Field Title」 → 「Field Settings」 → 「Allow adding options during entry」 toggle

1. Right-click the Single Select field title and select 「Field Settings」
2. Turn on the 「Allow adding options during entry」 toggle
3. During entry, if the input content does not exist in the preset options, you can add it as a new option with one click

Set Default Value

Feature Entry
Right-click 「Field Title」 → 「Field Settings」 → 「Default Value」 option

1. Right-click the Single Select field title and select 「Field Settings」
2. Select an option from the 「Default Value」 dropdown list
3. This default option will be automatically filled when adding a new Record

FAQ

Q1: How to quickly delete unwanted options?

• Solution: Right-click the field title, select 「Field Settings」, and click the trash can icon on the right side of the corresponding option in the option list to delete it.

Q2: How to search for existing options during entry?

• Solution: After clicking a cell to open the option list, enter keywords in the search box at the top to quickly search and narrow down the option range.

Q3: Can the Single Select field support multiple selections?

• Solution: The Single Select field only supports selecting one option. If you need to select multiple options at the same time, please create a new field of the 「Multiple Select」 type.

Notes

• The Single Select field only supports selecting one option. If you need multiple selections, please use the Multiple Select field
• When deleting an existing option, the value in Records that have selected that option will be cleared
• Color settings only affect visual display and do not affect data statistics and filtering
• Each Single Select field can create up to 1000 options. You can view the current number of options on the 「Batch Edit」 page