How to Use WPS Single Choice Field on Windows

Use Single Choice Field through 5 how-to topics in Smart Table data tables; 5 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a Single Choice Field

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

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

Success Criteria

• Interface result: A new Single Choice Field column appears in the data table.
• What you can do next: You can open field settings and continue adding options.

Tips While Using

• Common mistake: Similar field names can make later maintenance harder, so use a clear business label.
• Environment note: You need to open a Smart Table data table before the field entry is available.

2. Add and Edit Options

Entry: Right-click the field title, choose Field Settings, then use the option list area.

1. Right-click the Single Choice Field title and select Field Settings.
2. In the option list area, click + Add Option.
3. Enter the new option name.
4. If needed, click the square color button before the option to change its display color.

Success Criteria

• Interface result: The option list shows the new or updated option.
• What you can do next: Users can click a cell and select from these options.

Tips While Using

• Common mistake: Before deleting or renaming an option, check whether existing records are already using it.
• Environment note: In collaborative tables, field setting changes affect later entries in the same column.

3. Bulk Edit Options

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

1. Right-click the Single Choice Field title and select Field Settings.
2. Click Bulk Edit in the option list area.
3. Enter one option per line, or paste multiple lines into the text box.
4. Click OK to save the generated options.

Success Criteria

• Interface result: Multiple options are created in one action.
• What you can do next: You can continue adjusting colors or removing unneeded options.

Tips While Using

• Common mistake: If pasted content includes blank lines or duplicates, review it before saving.
• Environment note: This method is useful when building a field for the first time or reorganizing categories in batches.

4. Allow Adding Options While Filling

Entry: Right-click the field title, choose Field Settings, then turn on Allow adding options while filling.

1. Right-click the Single Choice Field title and select Field Settings.
2. Find the Allow adding options while filling switch.
3. Turn the switch on.
4. Later, when a user enters a value that is not in the preset list, it can be added as a new option.

Success Criteria

• Interface result: The switch is shown as enabled in field settings.
• What you can do next: New values can be added to the option list during data entry.

Tips While Using

• Common mistake: If your category rules must stay strict, use this setting carefully to avoid too many near-duplicate options.
• Environment note: This is useful for business tables where categories are still expanding.

5. Set a Default Value

Entry: Right-click the field title, choose Field Settings, then use Default Value.

1. Right-click the Single Choice Field title and select Field Settings.
2. In the Default Value drop-down list, choose an existing option.
3. Save the setting.
4. New records will automatically use that option as the default value.

Success Criteria

• Interface result: The selected default value is shown in field settings.
• What you can do next: When you add a new record, the field is filled automatically with the default option.

Tips While Using

• Common mistake: After setting a default value, confirm that it fits most new records.
• Environment note: Default values depend on existing options, so it is better to finish option maintenance first.