How to Use WPS Multidimensional Multiple Choice Field on macOS

Use the WPS Multidimensional Multiple Choice Field with 4 how-to topics on Mac; 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a multiple choice field

Entry: Click the "+" button on the right side of the header → Select "Multiple Choice"

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

Success Criteria

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

Tips While Using

• Common mistake: If you choose another field type, the cell entry method will be different.
• Environment note: You need edit permission for the current multidimensional table.

2. Add and edit options

Entry: Right-click the field title → Field Settings → Option list area

1. Right-click the multiple choice field title.
2. Select "Field Settings."
3. In the option list area, click "+ Add Option" to add a new option.
4. Click the square button before an option to change its display color.
5. Adjust the option content as needed and save the settings.

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, tags become harder to distinguish later.
• Environment note: It is helpful to keep a consistent naming rule for filtering and grouping.

3. Batch edit options

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

1. Right-click the multiple choice field title.
2. Select "Field Settings."
3. Click the "Batch Edit" button in the option list.
4. Enter one option name per line, or paste multiple lines of content.
5. Click "OK" to save the generated options.

Success Criteria

• Interface result: The option list generates multiple new options at one time.
• Next action available: You can continue selecting these generated options in cells.

Tips While Using

• Common mistake: Extra characters in a line will also be kept in the generated option name.
• Environment note: Prepare clean one-line-per-option text before batch import.

4. Allow new options during entry

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

1. Right-click the field title.
2. Select "Field Settings."
3. Turn on the "Allow adding options during entry" switch.
4. Enter content that is not already in the preset options during data entry.
5. Add that content as a new field option and continue using it.

Success Criteria

• Interface result: The switch in field settings is turned on.
• Next action available: New content can be added directly as a selectable option during entry.

Tips While Using

• Common mistake: If the switch is off, you cannot add new preset options directly during entry.
• Environment note: In collaboration scenarios, agree on naming rules in advance to avoid near-duplicate options.