Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to filter a record based on 2 conditions

Topic Labels: API
882 2
Showing results for 
Search instead for 
Did you mean: 

Hi all, I am new to the Airtable community. I have menu items table it contains 15 records. I want to filter the menu key and restaurant key in menu items table. Because i am getting all restaurants and all menus in menu items table. How to filter the both Restaurants and Menus at a time.

I placed this code for filtering the menu items:-
[{“key”:“filterByFormula”,“value”:“Find(“Sides”, Menu)&(“The Montauk”, Restaurant)”}]

2 Replies 2



Check the following simple base to get started.


It looks to me like this is a question about the Airtable API, not something that is supposed to happen in the main application. I’m going to move the thread to the API category.