Hello
In my environment, there is a product table. A record can have 3 parameters ("Indoor/outdoor", "Water Toys/Sand Toys/Wooden Toys/Rubber Toys", "red/blue/green/yellow".
ID | Product | Indoor/outdoor | Type | Color |
1 | Waterblast | Outdoor | Water Toys | blue |
2 | Waterblast | Outdoor | Water Toys | yellow |
3 | Sandshell | Outdoor | Sand Toys | green |
4 | Bucket | Outdoor | Rubber Toys | yellow |
5 | Trainset | Indoor | Wooden Toys | red |
6 | Trainset | Indoor | Wooden Toys | blue |
7 | Trainset | Indoor | Wooden Toys | green |
8 | Trainset | Indoor | Wooden Toys | yellow |
9 | Bounce-Ball | Indoor | Rubber Toys | blue |
10 | Bounce-Ball | Indoor | Rubber Toys | red |
something like this (I let my imagination run wild)
Now I want to filter this view based on the filtered records through three dropdowns The dropdowns will be filled in in a non-logical order. The first dropdown that gets filled in, let's say indoor/outdoor, shows all the possible values (indoor or outdoor). When outdoor gets picked. The next dropdown that will be filled in (in this example color) should only show the values (blue, yellow and green) because there are no red outdoor toys. Let's say yellow gets picked. When the type-dropdown gets opened, only water toys and rubber toys should be visible.
I was thinking of letting my view update everytime a value in a dropdown gets chosen. And was hoping of retrieving the distinct values of the corresponding attribute and putting them in the correct dropdown. This possible solution can only be achieved through a custom javascript function i guess.
Does someone have a prior experience with a scenario like this or with a custom javascript function which can retrieve the remaining values of a filtered view and putting them in a dropdown?
Thank you so much