I have a product table in Airtable that I want to use and filter using multiselect dropdown. I’ve tried to search and read past discussions but still can’t figure out how to do it or if it’s possible at all.
The table has several multi-select columns (converted to list-of-text columns once connected to Bubble) and users need to be able to filter like this:
So the filter needs to return every product that meets AT LEAST one value (everything must be ‘OR’-ed). One suggestion I saw was to search Materials, Certification, Brand, Features separately and merge the results. However I still can’t get past list-of-text (dropdown) vs list-of-text (data) filtering.
Anyone has idea how to solve this please?