How to Use WPS Multiple Choice Field on Windows

Use Multiple Choice Field through 4 how-to topics, including creating the field, editing options, batch editing, and allowing new options during entry; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Create a Multiple Choice Field

Entry: + button on the right side of the table header → Multiple Choice

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

Success Criteria

• Interface result: a new Multiple Choice Field column appears in the data table.
• Next action available: you can open field settings and continue adding or editing options.

Tips While Using

• Common mistake: closing the dialog before confirming the field name may stop the field from being created.
• Environment note: the current data table must allow adding fields, and you need edit permission.

2. Add and Edit Options

Entry: right-click the field title → Field Settings → option list area

1. Right-click the Multiple Choice Field title and select Field Settings.
2. In the option list area, click + Add Option to add a new option.
3. Click the square color button before an option to change its display color.
4. Continue adding or adjusting options based on your classification needs.

Success Criteria

• Interface result: the option list shows the new or updated options.
• Next action available: these options can be selected directly when filling in cells.

Tips While Using

• Common mistake: if colors are too similar, later tag recognition may be less clear.
• Environment note: changing field settings requires edit permission.

3. Batch Edit Options

Entry: right-click the field title → Field Settings → Batch Edit

1. Right-click the Multiple Choice Field title and select Field Settings.
2. Click Batch Edit in the option list.
3. Enter one option name per line, or paste multiple lines of text.
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 continue adjusting colors or removing unneeded options.

Tips While Using

• Common mistake: pasted content with blank lines or duplicates should be checked before saving.
• Environment note: when many options are involved, a naming rule helps later filtering and analysis.

4. Allow New Options During Entry

Entry: right-click the field title → Field Settings → Allow adding options during entry switch

1. Right-click the Multiple Choice Field title and select Field Settings.
2. Turn on Allow adding options during entry.
3. While entering data, type content that is not yet in the preset option list.
4. Add that content as a new option and save it to the option list.

Success Criteria

• Interface result: new content can be added to the existing option list during entry.
• Next action available: later records can reuse the new option.

Tips While Using

• Common mistake: without a naming rule, similar tags may appear with different wording.
• Environment note: it is helpful for a field owner to review newly added options regularly.