Dynamics Community Forum Thread Details

Custom dynamic filters on entity view

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

Quick Links

Leaderboard