Cascading dropdown
Was this helpful?
Was this helpful?
Dropdowns dynamically populated from the same worksheet can now act as an hierarchy and cascade automatically. When selecting a category from a dropdown in a form, the next dropdown for sub-categories will only show relevant values for the previous selected Category. NOTE: Do not use the cascaded sheet for displaying and filtering because that messes up the behavior, connect to a separate sheet.
Open the configuration of the extension to link to the sheet that holds the cascading information and choose the category.
Your dropdown fill only be filled with relevant data based on the cascaded filter.
