How to Use WPS Multiple Choice Field on macOS

Use Multiple Choice Field with 4 how-to topics, all available without membership; the index below covers creating the field, maintaining options, bulk editing, and allowing new options during data entry.

How-to Index

How-to Guide

1. Create a Multiple Choice Field

Entry: Click the + button on the right side of the header, then choose Multiple Choice.

1. Click the + button on the right side of the header.
2. Select Multiple Choice from the field type list.
3. Enter the field name.
4. Click OK to finish.

Success Criteria

• Interface result: A new multiple choice field column appears in the data sheet.
• Next action available: You can open field settings and continue adding options.

Tips While Using

• Common mistake: If you close the window before confirming the field name, the field is not created.

2. Add and Edit Options

Entry: Right-click the field title, then open Field Settings and go to the option list area.

1. Right-click the multiple choice field title and select Field Settings.
2. Click + Add Option in the option list area.
3. Click the square color button in front of an option to change its display color.
4. Continue adjusting option names and colors for your category setup.

Success Criteria

• Interface result: The option list shows the new or updated options.
• Next action available: You can select these options directly in cells.

Tips While Using

• Common mistake: If colors are too similar, later tag recognition becomes less clear.

3. Bulk Edit Options

Entry: Right-click the field title, open Field Settings, then click Bulk Edit.

1. Right-click the multiple choice field title and select Field Settings.
2. Click Bulk Edit in the option list.
3. Enter one option name per line, or paste an existing list.
4. Click OK to save the generated options.

Success Criteria

• Interface result: Multiple new options appear in the option list at once.
• Next action available: You can select the generated options in cells right away.

Tips While Using

• Common mistake: If several options are entered on one line, they are treated as one option name.

4. Allow New Options During Entry

Entry: Right-click the field title, open Field Settings, and turn on Allow adding options during entry.

1. Right-click the multiple choice field title and select Field Settings.
2. Turn on Allow adding options during entry.
3. Enter content that is not yet in the current option list while filling in data.
4. Add that content as a reusable option.

Success Criteria

• Interface result: The newly entered content can be added to the option list.
• Next action available: Later records can reuse the new option.

Tips While Using

• Common mistake: If the switch is off, newly entered content is not added to the option list automatically.