Skip to main content

Control - Cascading


In the cascading field, it displays the options based on your previous selection.

Application Scenario

For example, when selecting the province, city, and county, if Henan Province is selected, the available options are the cities that belong to Henan Province.

After adding the cascading control, you need to configure the data source. The data source is essentially a worksheet with the org view.

Configuration

In the Customer worksheet, it is necessary to show the city where the customer is located, for easy statistics by region.

1. Add the cascading control

2. Select the data source

There are two ways as follows:

  • Add a new data source worksheet directly, and there is an org view in the new worksheet.
  • Select an existing worksheet with an org view as the data source.

When selecting an existing worksheet as a data source, the worksheet must already be configured with an org view associated with the current worksheet.

How to configure the org view

Let's take the new data source as an example and click [OK] to continue the configuration.

3. Configure the fields

A. Modify the field name  

B. Data source

Here you select the automatically created worksheet and org view, which is automatically marked as hidden and not in the ordinary user's navigation.

C. Style of drop-down menu

Cascading menu: Show each level horizontally

Tree selection: Show each level vertically

D: Setting

  • Select to the final level

    For example, for Jinshui District/Zhengzhou City/Henan Province, there are three levels. If checked [Select to the final level], you must select to the county or district level. If unchecked, you can select only the province, or select province and city as well (such setting is not available for tree selection).

  • Results display hierarchy path

    • If checked, the fields are displayed as Henan Province/Zhengzhou City/Jinshui District.
    • If unchecked, only the last level, Jinshui District, is displayed.

How to cascade through associated fields

Video introduction


Have questions about this article? Send us feedback