WPS Cascading Options Field on macOS: Introduction

WPS Cascading Options Field is a hierarchical option field in WPS tables that filters lower-level choices based on the parent selection; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None stated	No version threshold is described for this feature

About This Feature

Overview

Cascading Options Field is a field type in WPS Office for Mac tables that lets you build linked option levels. After a user selects a parent option, the field automatically filters and shows the matching child options. It works well for structured input such as province-city-district selection, product category trees, and department hierarchies.

Core tasks include:

Create a Cascading Options Field: add a new field from the table header and choose the Cascading Options type.
Configure multi-level option content: edit first-level, second-level, and third-level titles, then add or batch edit options.

Common use cases include address entry, product classification, and organizational data collection. This feature helps reduce irrelevant choices and keeps layered data entry easier to manage. It supports up to 3 linked levels, with creation and editing entry points grouped in the field controls.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office for Mac
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory connection is required for local editing; sign-in, sync, and online collaboration require internet access
Other	You need access to a table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Mac installer and complete setup by following the on-screen prompts
Post-install check	Open WPS Office, open a table, and confirm that the add-field entry is available on the right side of the header

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS tables support a Cascading Options Field with up to 3 linked levels, and the field settings let you edit titles and options for each level.	Microsoft Forms supports branching to direct users to follow-up questions, but the official help does not describe a native multi-level cascading field inside one field.	Google Forms supports dropdown questions and section routing based on answers, but the official help does not describe native multi-level cascading field editing inside one field.	Notion databases support a Select property for choosing one option from a dropdown list, but the official help does not describe a native multi-level cascading field.	Adobe Acrobat forms support dropdown and list fields with configurable properties, but the official help does not describe a native three-level cascading field workflow for table-style data entry.
WPS Advantages	Advantage: WPS manages multi-level option relationships inside one field configuration. Distinct: it is designed for layered data entry workflows with a focused setup path.	Compared with WPS: Microsoft Forms focuses on branching between questions instead of maintaining multiple linked option levels inside one field.	Compared with WPS: Google Forms mainly routes users between sections rather than editing multiple linked levels inside one field.	Compared with WPS: Notion Select is suited to single-level tagging, and layered relationships usually need extra database design.	Compared with WPS: Acrobat focuses on PDF form field setup rather than a table-oriented cascading field workflow.
Official Source	—	Use branching in Microsoft Forms	Show questions based on answers	Database properties	Field specific properties

Overall Conclusion

WPS Cascading Options Field is a practical fit when you need to maintain layered option relationships inside a single field during data entry. Other products can cover nearby needs such as form branching, single-level tagging, or PDF form setup, but their interaction model is different from a dedicated cascading field.

Use Cases

No.	Scenario	Suitable for	Main challenge	How WPS helps
1	Province, city, and district entry	Administrative and operations teams	Address hierarchies are long and easy to misselect manually	Filter child options automatically after the parent region is selected
2	Product category management	E-commerce and product teams	Category structures are complex and hard to standardize	Build first-level to third-level category relationships in field settings
3	Department hierarchy registration	HR and management teams	Multi-level structures slow down manual entry	Select department information level by level in one field
4	Project ownership entry	Project managers and collaborators	Project, module, and subtask relationships can be unclear	Standardize ownership input with linked option levels
5	Customer region management	Sales and support teams	Large region lists create too many choices at once	Show matching cities or subregions after the main region is selected

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of Cascading Options Field	Available	Available
Basic PDF features	Available	Available
Advanced PDF editing and more advanced tools	May be limited by feature	Includes more advanced capabilities
Cloud storage and multi-user sharing plans	Basic allocation	Higher allocation or more plan options

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily table work with cascading data entry	Free	This feature is described without a membership limit, so you can start using it directly
Workflows that also need more PDF tools, advanced utilities, or broader sharing benefits	WPS Premium	Suitable when you need expanded office capabilities and additional benefits

Membership page: Subscribe to WPS Premium