WPS Cascading Options Field is a layered option-entry feature in Smart Table; 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 |
| Membership limit | None | Stated in the feature description |
| Version limit | None | Stated in the feature description |
About This Feature
Overview
The Cascading Options Field lets you build linked option levels inside a table field. After a user selects a parent option, the field automatically filters and shows the matching child options. This is useful for scenarios such as province-city-district selection, product category filtering, and department hierarchy management.
On macOS, this feature mainly supports these tasks:
- Create a Cascading Options Field from the add-field entry on the right side of the table header.
- Edit cascading option content by setting level-1, level-2, and level-3 titles and adding option values.
- Enter data with linked levels so lower-level choices narrow automatically after an upper-level selection.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Mac device that can run WPS Office normally |
| App version | The latest version of WPS Office for Mac is recommended |
| Network | No mandatory network connection for local editing; internet access is needed for sign-in, sync, or online collaboration |
| Other | Use this field type in Smart Table or a related data-table scenario |
Download & Installation
Before using the Cascading Options Field, install WPS Office for Mac and make sure you can open Smart Table or a related data table successfully.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Before installation | Reserve available storage space and confirm that your device meets the basic runtime conditions |
| After installation | Launch WPS Office, open Smart Table, and check whether the “Cascading Options” entry is available from the add-field area in the table header |
Source: WPS download center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Smart Table supports a Cascading Options Field with up to 3 linked levels. After a parent option is selected, matching child options are filtered automatically. | Microsoft Forms supports branching logic that sends respondents to different follow-up questions. The official page does not describe a native cascading dropdown inside one field. | Google Forms add-ons can extend the form editor, but the official developer page says they cannot extend the form shown to respondents. The official page does not describe a native real-time cascading dropdown. | Notion databases support Select and Multi-select properties for creating and editing options. The official help page does not describe a native cascading options field. | Adobe Acrobat supports dropdown and list-box form fields in PDF forms. The official help pages do not describe native multi-level cascading linkage. |
| WPS Advantages | Advantage: Manage multi-level option relationships directly in one field. Distinct: Child options filter automatically during entry after a parent selection. | Compared with WPS: Microsoft Forms focuses more on branching question flow than on cascading selection inside a single field. | Compared with WPS: Google Forms is better suited to section-based routing or editor-side extensions, not native respondent-side cascading dropdown filtering. | Compared with WPS: Notion is stronger for database tagging and property management, but its official help does not present a native cascading options field. | Compared with WPS: Adobe Acrobat focuses on PDF form field setup, and its official help does not present native cascading option linkage. |
| Official Source | — | Use branching logic in Microsoft Forms | Extend Google Forms with add-ons | Database properties | Create PDF forms from scratch |
Overall Conclusion
WPS is a practical fit when you need hierarchical option entry and linked filtering directly inside a table field. Other products offer adjacent approaches for survey routing, database tagging, or PDF form building, but WPS provides a more direct path for single-field multi-level selection on this workflow.
Use Cases
| No. | Scenario | Suitable Users | Main Pain Point | How the Feature Helps |
|---|---|---|---|---|
| 1 | Province-city-district entry | Admin, customer service, and operations staff | Address hierarchies are long and manual entry is error-prone | Use a Cascading Options Field to select province, city, and district step by step |
| 2 | Product category management | Merchandising and warehouse staff | Category structures are complex and options are easy to mix up | Select a top-level category first, then filter subcategories automatically |
| 3 | Department hierarchy records | HR, admin, and project managers | Multi-level organization structures are hard to standardize | Limit entry through level-1, level-2, and level-3 department choices |
| 4 | Project archive filing | Team members | Filing standards vary across similar materials | Use layered options to standardize archive paths |
| 5 | Customer information organization | Sales and after-sales staff | Regional and business classifications need consistent entry | Use linked options to reduce free-text differences |
Membership & Benefits
Free vs WPS Premium
| Capability | Free Users | WPS Premium |
|---|---|---|
| Basic Writer, Spreadsheet, and Presentation features | ✅ Available | ✅ Available |
| Basic PDF features and PDF reading | ✅ Available | ✅ Available |
| Advanced PDF editing and more advanced tools | Limited or unavailable in part | ✅ Available |
| Cloud storage | 1 GB | 20 GB or more depending on the plan shown on the purchase page |
| AI tools and more advanced capabilities | Some limits apply | More usage and broader feature access |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Daily table entry and lightweight data organization | Free | The Cascading Options Field itself has no membership restriction, so it works well for basic data-entry tasks |
| Office work that also needs more PDF, cloud storage, or AI capabilities | WPS Premium | A better fit if you also use more advanced office features across the suite |
How to Subscribe
- WPS membership center: Subscribe now
- To compare plan differences, open the purchase page and review the Free, Pro+, and sharing plans.
Source: WPS Office pricing page