Multi Dropdowns to RG using Airtable DB

chelseap815 · 2025-01-07T01:18:56.163Z

Hi All!

I’ve been noodling on this for a bit and can’t seem to get over the hump with similar forum info. I’m creating a page that is a multi-filter directory of restaurants.

Goal: Create a multiple filter dropdown (atmosphere, cuisine, specials) that displays the restaurants that match the selected filters.

Data source: Airtable DB with a table for restaurants with columns for names, atmosphere (linked), cuisine (linked), and specials (linked). Another 3 separate tables for atmosphere, cuisine, and specials that have columns for the tag names, and linkages for the matching restaurant names. Images below.

Airtable Restaurants

Airtable Restaurants841×402 23.1 KB

Airtable Atmosphere (Cuisine and Specials tables are similarly structured)

Airtable Atmosphere767×496 16.5 KB

Bubble RG

image1323×837 36.3 KB

Bubble Dropdown (the other two dropdowns are similarly structured)

Bubble Atm dropdown 1.61210×840 31.7 KB

Thanks in advance for the assistance.

iwakinomotoye · 2025-01-07T11:01:36.885Z

@chelseap815

I guess you are using the bubble’s airtable plugin
I guess each of the atmosphere, cuisine and specials are all list of items on the restaurant table on airtable
I guess the dropdown for atmosphere, cuisine and specials in your app selects a single item each.
if the 3 above are true, then you should be able to create a call for restaurants on the bubble airtable plugin. After this, in your RepeatingGroup Restaurant, just call Airtable Restaurant. On this expression, you should be able filter by Atmosphere contains dropdown atmosphere value, Cuisine contains dropdown cuisine value and Specials contains dropdown specials value. (since you are dealing with list contains item)

Let us know if this works for you.

chelseap815 · 2025-01-09T00:56:49.106Z

Thanks this worked!