Control - Cascading
In the cascading field, it displays the options based on your previous selection.
Use Case
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.
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
Have questions about this article？ Send us feedback