WPS Single Option is a single-choice field type for multidimensional tables on iOS; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Single Option is a field type in WPS Office multidimensional tables on iOS. It lets you create a predefined list of choices for each record and limits each record to one selected value at a time. It works well for status, category, priority, and other scenarios that need consistent input.
Core tasks include:
- Create a Single Option field: add a field column that supports one choice per record.
- Add options: add selectable values, set color markers, and adjust order.
- Edit options: update existing option text while keeping records aligned with the latest value.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory requirement for local editing; an internet connection is recommended for sign-in, sync, or collaboration |
| Other | You need access to a multidimensional table and permission to edit the table |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office, open a multidimensional table, and check whether the Single Option field type is available in field editing |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In multidimensional tables, WPS provides a single-choice field that supports field creation, option adding, option editing, color markers, and order adjustment. | Excel supports list-based drop-downs through data validation so users can choose one value from a predefined list. | Google Sheets supports in-cell dropdown lists with editable items, display styles, and range-based updates. | Notion database Select properties let users choose one option from a list and edit tag names and colors. | Acrobat form drop-down and list box fields support item lists, sorting, adding, and deleting items. |
| WPS Advantages | Advantage: WPS places single-choice field setup, option maintenance, and color marking in one field-editing flow for multidimensional table records on iOS. | Compared with WPS: Excel focuses on worksheet cell input control through data validation. | Compared with WPS: Google Sheets focuses on cell-level dropdown rules and display styles. | Compared with WPS: Notion Select is more oriented to database tagging than a table-style field editing flow. | Compared with WPS: Acrobat dropdown capabilities are mainly designed for PDF form configuration. |
| Official Source | — | Create a drop-down list in Excel | Create an in-cell dropdown list in Google Sheets | Database properties in Notion | Field properties for form components in Acrobat |
Overall Conclusion
WPS Single Option is well suited to structured record management in multidimensional tables on mobile devices. Other products offer similar single-choice or dropdown features, but they are more focused on worksheet input, database tagging, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How Single Option helps |
|---|---|---|---|---|
| 1 | Task status tracking | Project members | Status values are entered inconsistently | Use Single Option to standardize values such as Not Started, In Progress, and Completed |
| 2 | Customer category records | Sales and operations teams | Category names can become duplicated or inconsistent | Preset customer level or source options so users can select instead of typing |
| 3 | Priority marking | Team collaborators | Important items are hard to identify quickly | Add color markers to priority options for faster recognition |
| 4 | Approval result logging | Admin and management staff | Result fields are entered in different formats | Create fixed options such as Approved, Returned, and Pending Update |
| 5 | Mobile field entry | Field staff or inspectors | Typing on a phone is slower | Use a single-choice list to reduce manual input and speed up entry |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic Single Option field usage | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available with broader coverage |
| Templates and advanced office benefits | Partially available | More benefits available |
| Cloud storage | 1 GB | 20 GB, based on the official pricing page |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| You only need Single Option for everyday multidimensional table records | Free plan | This feature itself has no membership restriction and fits light daily use |
| You also need more PDF, template, or cloud storage benefits | WPS Premium | Suitable when you need broader office benefits in addition to this feature |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page