Filtering list of text using list of text?

[battra]

Hi,
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?

[boston85719]

Here are a couple of forum posts that might help

Help with do a search for:filtering many to many using a custom state list based on an option set list

I’ve never used the intersect method and not sure if it would return different results than the method I use. I also don’t use custom states in most cases and opt to use URL parameters, so that the user can navigate using browser navigation and not lose their search…this also allows them to save the URL to the DB as a single text field if they want to save a search. Here are some screen shots from an application I use during a lesson on Data Modeling in Bootcamps I run. [Screen Shot 2021-03…

How to set up a search results page

After much frustration and time spent on getting my search results page to function correctly and the great amount of help from the community, I felt it necessary to provide some insight into how I accomplished this feat. My project is a hotel listing site. This could be redone for any type of listing site. Firstly, the database needs to be set up correctly. My search results are displaying hotel listings. So, I set up in the database a Data Type of Hotel Listing. The hotel listings will have …

Learn More

Boston85719 is an expert Bubbler with a decade experience as an educator. Real name Matthew, he has been actively building SaaS apps, marketplace apps, scheduling apps and more for clients, himself and for sale as templates.

As an official Bubble Bootcamp Instructor, he leads Bubble Bootcamps on a regular basis.

Always willing to offer advice via the Bubble Forum, Matthew also offers Private Personal and Group Training Sessions.

Through his site, NoCodeTrainer, Matthew provides a range of tutorials with editor access to help you jumpstart your Bubble development.

Always accessible you can send Matthew a private message via the forum or send an email directly with your requests.

Be sure to checkout the Stripe Integration Course when you are ready to integrate Stripe payments to start monetizing your application via product sales or subscriptions.

[battra]

Thanks @boston85719 ! I’ve been reading both threads a few times and still trying to apply them on my app. So far I’ve managed to make it works but only when filtering with 1 attribute.

For example if I filter by Materials alone and select 2 or more values, the RG is correctly displaying products that have at least 1 material. The same thing happen if I filter by Certifications alone, it works. However, I still can’t get RG to display correctly if I filter both by Materials and by Certifications.

I’m probably missing something here so I’ll tweak it some more and come back for further help.

Once again thanks for pointing me to the right direction!