Cascaded Selections help you to set options connected to another selection field depending on what is selected previously.
Setting up Cascaded Selection
To set cascaded selections for a selection field, you must first create at least 2 selection fields in the Design Mode.
Select the field "Minor Category" and check the Set Cascaded Selections box, then select "Major Category" from the drop-down menu.
Click on the Set button, a pop-up menu will display all options of the referenced selection field. You can add the cascaded selections to each parent option. Each cascaded selection must be written on one line.
Don't forget to click on the Save button after you finished.
It is possible to set cascaded selections referring to a field already with cascaded selections, so you can have a chain of cascaded selections.
1. Both the parent selection field and the child selection field need to be added to the listing page if you would like to display one of them there. If you do not want one of those fields displayed on the listing page, you may hide that field.
2. Multiple selection field doesn't support Cascaded Selection.
3. The maximum number of selections in a cascaded selection field is 10000. When reaching the limit, the selection settings on the cascaded selection field will be reset after saving the sheet's design. If it is required to have more than 10000 selections, please use link & load with dynamic filtering applied.