Hi!
I have searched quite a bit, but could not find a suitable solution for the following problem:
I have a csv file (say car_brands.csv) with a list of objects (say cars) that belong to a certain category (say car brand). So for example:
car1, bmw
car2, opel
car3, opel
car4, nissan
...
What I would like to have on a dashboard is one dropdown input field and one multiselect input field. The dropdown should get all the categories (car brands) dynamically and have one static value (all). The multiselect input field should have all cars (car1, car2..). All of them should be selected by default. I have succeeded to make a search that dynamically populated both input fields. However I did not manage to make all the cars selected by default. Moreover, I also want that as soon as the user chooses a category (car brand) in the dropdown then all the cars belonging to that brand should appear selected in the multiselect field (obviously, upon selecting 'all' , all cars should appear in the multiselect field.
In other words: all the different cars should remain always available in the multiselect input field, but the user should be able to use the first dropdown as a way of selecting a subset of them (without having to select them one by one) in the multiselect field.
What is the best way to accomplish this?
It is not preferred, but if there is no other way, I could hard code the category names, instead of getting them from the lookup table (there are not that many).
Thanks!
... View more