Multi Dropdowns to RG using Airtable DB

Need help Database
1

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 Restaurants
Airtable Restaurants841×402 23.1 KB

Airtable Atmosphere (Cuisine and Specials tables are similarly structured)

Airtable Atmosphere
Airtable Atmosphere767×496 16.5 KB

Bubble RG

image
image1323×837 36.3 KB

Bubble Dropdown (the other two dropdowns are similarly structured)

Bubble Atm dropdown 1.6
Bubble Atm dropdown 1.61210×840 31.7 KB

Thanks in advance for the assistance.

2

@chelseap815

  1. I guess you are using the bubble’s airtable plugin
  2. I guess each of the atmosphere, cuisine and specials are all list of items on the restaurant table on airtable
  3. I guess the dropdown for atmosphere, cuisine and specials in your app selects a single item each.
  4. 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.

3

Thanks this worked!