How to Use WPS Cascading Options Field on macOS

Last updated:July 21, 2026

Use the Cascading Options Field through 3 topics, including creating the field, setting cascading option content, and entering data by level.

How-to Index

No.TopicMembership Requirement
11. Create the fieldFree
22. Set cascading option contentFree
33. Enter data by levelFree

How-to Guide

1. Create the field

Entry: “+” button on the right side of the table header → “Cascading Options”

  1. Find the “+” button on the right side of the table header.
  2. Click the “+” button to open the field type list.
  3. Select the “Cascading Options” field.
  4. Enter a field name.
  5. Click “OK” to finish creating the field.

Success Criteria

  • Interface result: A new Cascading Options field column appears in the table.
  • Next action available: You can continue to open field settings and edit option content.

Tips While Using

  • Common mistake: If you are not working in the correct data table first, the field may be added to a different table.
  • Environment note: Use this in a data-table scenario that supports field management.

2. Set cascading option content

Entry: Right-click the field title → “Field Settings” → “Edit Options”

  1. Right-click the title of the Cascading Options field.
  2. Select “Field Settings.”
  3. Click the “Edit Options” button.
  4. In the edit window, set the level-1, level-2, and level-3 option titles.
  5. Click “+ Add Option” or “Batch Edit” as needed to add content for each level.
  6. Click “OK” to save the settings.

Success Criteria

  • Interface result: The field settings show a configured multi-level option structure.
  • Next action available: After you return to the table, you can choose values by level in a cell.

Tips While Using

  • Common mistake: If parent options are not set first, the child-option structure may be incomplete.
  • Environment note: The feature supports up to 3 linked levels.

3. Enter data by level

Entry: Click a cell in the Cascading Options field

  1. Click the target cell in the Cascading Options field for the record you want to edit.
  2. Select a level-1 option first.
  3. Based on that selection, choose the matching level-2 option.
  4. If level-3 options are configured, continue by choosing the matching level-3 value.
  5. Check the final displayed result after the selection is complete.

Success Criteria

  • Interface result: Lower-level options change automatically after the upper-level selection.
  • Next action available: You can continue editing other fields in the current record or save the data.

Tips While Using

  • Common mistake: If the parent option is selected incorrectly, the available child options will also change, so go back and reselect the upper level.
  • Environment note: Only configured hierarchy content appears in the dropdown choices.