WPS Cascading Options Field helps you build up to three linked option levels in Smart Forms tables on Windows; this guide covers 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 |
| Supported levels | Up to 3 | You can configure first-level, second-level, and third-level linked options |
| Membership limit | None | The feature itself can be used directly |
About This Feature
Overview
Cascading Options Field is a field type in WPS Smart Forms on Windows. It lets you create linked option levels inside one field so that selecting a higher-level option automatically filters the lower-level options. This works well for scenarios such as province-city-district selection, product category filtering, and department hierarchy entry.
Core tasks include:
- Create a cascading options field from the add-field entry beside the table header.
- Edit cascading option content by adjusting first-level, second-level, and third-level titles.
- Maintain options with Add Option and Batch Edit.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest WPS Office version so Smart Forms entries are available |
| Network | No mandatory requirement for local table editing; online features such as sign-in and sync require a network connection |
| Other | You need access to open Smart Forms and edit the target data table |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Download the Windows installer and complete setup by following the on-screen prompts |
| Post-install check | Open WPS, enter a Smart Forms table, and confirm that the add-field button appears beside the table header |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Smart Forms can create a Cascading Options Field directly and let you maintain up to three linked option levels in field settings. | Microsoft Forms provides branching logic that routes respondents to later questions, but the official page does not describe a native cascading dropdown field inside one question. | Google Forms supports answer-based routing across sections, and dropdown questions can be used for section routing. | Notion Forms connects to databases and supports multiple question types and dropdown display; conditional logic is available on Business and Enterprise plans. | Adobe Acrobat forms support combo boxes and other form fields, and form behavior can be extended with JavaScript. |
| WPS Advantages | Advantage: WPS keeps multi-level linked options inside one field and combines field creation, field settings, and option editing in one workflow. | Compared with WPS: the official guidance focuses on branching between questions instead of multi-level linked options inside one field. | Compared with WPS: the official capability focuses on section routing for form flow rather than in-field cascading options. | Compared with WPS: conditional logic has plan limits, and form creation and customization are handled on desktop and web apps. | Compared with WPS: dependent behavior relies on scripting, which fits PDF form customization rather than direct table field setup. |
| Official Source | — | Use branching logic in Microsoft Forms | Show questions based on answers | Forms | Using JavaScript in Forms |
Overall Conclusion
WPS is well suited to table-based data entry where hierarchical options need to be maintained directly inside one field. Other products offer related approaches for form branching, database-backed forms, or scripted PDF forms, but their setup paths and use cases are different.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | How WPS Helps |
|---|---|---|---|---|
| 1 | Province-city-district entry | Admin and support teams | Address hierarchies are long and manual entry is error-prone | Use a cascading options field for step-by-step regional selection |
| 2 | Product category management | Operations and merchandise teams | Category structures are complex and hard to standardize manually | Preset first-level to third-level categories and keep selection paths consistent |
| 3 | Department hierarchy registration | HR and admin teams | Multi-level organization structures make lower-level choices easy to miss | Filter lower-level department options based on the selected parent department |
| 4 | Project tag classification | Project managers and team members | Large tag sets slow down selection | Choose a main category first, then show matching subcategories |
| 5 | Customer segment grouping | Sales and customer success teams | Industry and sub-industry values need consistent entry | Use multi-level options to standardize industry classification |
Membership & Benefits
Free vs WPS Premium
| Capability | Free Users | WPS Premium |
|---|---|---|
| Create a Cascading Options Field | ✅ | ✅ |
| Set first-level to third-level titles | ✅ | ✅ |
| Add options and use Batch Edit | ✅ | ✅ |
| Other premium benefits | Depends on the current account benefits | More value-added benefits may be available based on the selected plan |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Daily data entry and basic table structure maintenance | Free | The Cascading Options Field itself has no membership limit |
| Individuals or teams that also need broader value-added office benefits | WPS Premium | Suitable when you also need additional benefits across WPS components |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page