Hi,
I have a table that is populated from an API call. I want users to be able to filter this table dynamically using multiple multiselect dropdowns. For example, the API data has one column called ‘company’, and another called ‘programme name’. The table then has all of the api data on page load, but there are two multiselect dropdowns where users can select various companies and programme names (the table shows a list of job roles). The multiselect dropdown values are populated dynamically from al possible values in the api data.
I have tried creating a custom state as the data source for the table, and each time a dropdowns value is changed a workflow triggers the custom state with :filtered and then advanced to make the data contain the values from the dropdown selected. This works when just one dropdown is used, but I can’t figure out how to make this work when there are multiple dropdowns filtering the table, and have all of the selected values intersect to filter the table.
It would be simple to do if the data was from a bubble database as I could just do a search for within the custom state, but I can’t figure out how to achieve this with API data.
Any help would be much appreciated 