WPS Multiple Choice Field on macOS FAQ

Common questions about Multiple Choice Field usually focus on field differences, grouping, deleted options, and option limits; this FAQ covers 4 frequent questions and quick answers.

FAQ

What is the difference between a multiple choice field and a single choice field?

1. A single choice field lets you select only one option at a time.
2. A multiple choice field lets one cell store several selected options.
3. If one record needs to belong to several categories, use a multiple choice field.

How do I group records by one option inside a multiple choice field?

1. Open the grouping settings for your data sheet.
2. Select the target multiple choice field.
3. View the grouped result by individual option to see record counts for each option.

What happens to existing records after I delete an option?

1. After an option is deleted, the corresponding value in records that used that option is cleared.
2. Check whether the option is still in use before deleting it.
3. If needed, replace those records with another option first.

How many options can one multiple choice field contain?

1. One multiple choice field can contain up to 1000 options.
2. You can check the current option count on the bulk edit page.
3. When the list is large, use a consistent naming rule to make search and maintenance easier.

Glossary