WPS Single Choice Field is a single-select field type in Smart Table data tables on macOS; it includes 5 core tasks, with 5 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 5 | Matches the number of rows in the How-to Index |
| Available without membership | 5 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Membership limit | None | This feature can be used directly |
| Version limit | None stated | No version threshold is described for this feature |
About This Feature
Overview
Single Choice Field is a built-in field type in WPS Office Smart Table data tables on macOS. It is used to let users choose one value from a predefined list and write that value into a cell. It works well for scenarios such as project status, team ownership, and region categories where consistent classification matters.
Core capabilities include:
- Create a single choice field: Add a new field from the table header and name it.
- Add and edit options: Maintain an option list and assign display colors to different options.
- Batch edit options: Enter or paste multiple lines to generate several options at once.
- Allow adding options while filling: Add new content to the option list during data entry.
- Set a default value: Auto-fill a preset option for new records.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A macOS device that can run WPS Office normally |
| App version | The latest version of WPS Office for Mac is recommended |
| Network | Local field setup usually does not require a constant connection; keep the network available for sign-in, sync, or collaboration |
| Other | You need access to a Smart Table data table and permission to edit fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a Smart Table data table, and confirm that the add-field entry is visible on the right side of the header |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Smart Table data tables support creating a single choice field, maintaining an option list, batch editing options, setting a default value, and adding options while filling. | Microsoft Forms Choice questions support adding options, and the Multiple answers setting controls whether respondents can select more than one answer. | Google Forms Multiple choice and Dropdown questions both support one selected answer from preset options, with branching support in forms. | Notion database Select properties let users choose one option from a list of tags and manage option names and colors. | Adobe Acrobat Sign radio buttons are used for one selection from a predefined set in online forms. |
| WPS Advantages | Advantage: The field is built directly into a table column structure for ongoing category management. Distinct: It combines batch option editing, default values, and add-while-filling behavior in one table workflow. | Compared with WPS: It is more form- and quiz-oriented, so it focuses on response collection rather than table-column field management. | Compared with WPS: It is effective for form collection and branching, but not centered on table field configuration. | Compared with WPS: It is closer to a database property workflow, but the official guidance focuses more on tag management than table-entry defaults and add-while-filling behavior. | Compared with WPS: It is more suitable for e-signature or PDF form scenarios than column-level category maintenance in a data table. |
| Official Source | — | Microsoft Forms choice questions | Google Forms question types | Notion database properties | Adobe Acrobat Sign radio buttons |
Overall Conclusion
If you need to maintain consistent categories inside a data table over time, WPS Single Choice Field is closer to a spreadsheet-style workflow. Microsoft and Google focus more on form responses, Notion is closer to database tag management, and Adobe is oriented toward online or PDF form selection.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|---|---|---|---|
| 1 | Project status tracking | Project managers and execution teams | Status values are entered inconsistently and are hard to filter | Use a single choice field with preset values such as Not Started, In Progress, and Completed |
| 2 | Team ownership labels | Admin, HR, and operations teams | The same team name is entered in different ways | Build a fixed option list for departments or groups |
| 3 | Region category entry | Sales and channel teams | Region names are repeatedly typed and easy to mistype | Standardize region categories with a single choice field |
| 4 | Faster record creation | Data entry staff | Common values must be selected again for every new record | Set a default value to reduce repeated actions |
| 5 | Dynamic category expansion | Business maintainers | New categories appear during live entry and need to be added later | Turn on add-while-filling so new options can be added during entry |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Writer, Spreadsheet, and Presentation core apps | ✅ Available | ✅ Available |
| Basic PDF features and PDF reading | ✅ Available | ✅ Available |
| Advanced PDF editing and conversion | Partly limited | ✅ Available |
| Cloud storage | 1 GB | 20 GB on some plan listings |
| AI tools and advanced templates | Partly limited or quota-based | More access and expanded capabilities |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You mainly use Single Choice Field for daily table maintenance | Free | This feature has no membership limit, so everyday field setup can be completed directly |
| You also need more PDF, cloud, or AI capabilities | WPS Premium | Suitable if you need broader advanced office features beyond table fields |
How to Subscribe
- Membership page: Subscribe to WPS Premium
Source: WPS Office pricing page