Hello!
I have a dataset of products with a column for ‘Status’ (either ‘Live’ or ‘Discontinued’). By default, the search view shows only ‘Live’ products, which works as expected.
I also have two dropdown searches:
1. Status - allows users to switch between ‘Live’ and ‘Discontinued’.
2. Product Category - used to filter products by category.
The issue is that the Product Category dropdown includes options for discontinued products, even when the status is set to ‘Live’. This can be confusing for users.
I want the Product Category dropdown to dynamically filter its options based on the selected status. For example:
• If the Status is ‘Live’, only categories for live products should appear.
• If the Status is ‘Discontinued’, only categories for discontinued products should appear.
Is this possible to achieve?
Thanks!