# Advanced Querying for Airtable
**URL:** https://community.thunkable.com/t/advanced-querying-for-airtable/77026
**Category:** Questions about Thunkable X
**Created:** [May 26, 2019, 5:22pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026 "2019-05-26T17:22:39Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Sairam\_Pantham](https://community.thunkable.com/u/Sairam_Pantham)
#### Post date: [May 26, 2019, 5:22pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/1 "2019-05-26T17:22:39Z")
Hey all!
So, I’m creating a cooking app where the user can enter the ingredients and equipment they want and get recipes based on that. I have an Airtable where the created recipes are displayed, but I can’t seem to find a way where all of the text in the column “Name” of the row containing the user’s desired ingredients and equipment (these are in other columns [each recipe is a row]). And remember, there may be multiple rows where the ingredients and equipment are present.
Any help? Thanks!
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [May 26, 2019, 7:09pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/2 "2019-05-26T19:09:23Z")
Hey,
What format have your data in the table?
---
### Author:  [@Sairam\_Pantham](https://community.thunkable.com/u/Sairam_Pantham)
#### Post date: [May 27, 2019, 6:45pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/3 "2019-05-27T18:45:40Z")
Hi,
My Airtable is in a Grid View.
Here’s a screenshot
---
### Author:  [@Sairam\_Pantham](https://community.thunkable.com/u/Sairam_Pantham)
#### Post date: [May 27, 2019, 6:46pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/4 "2019-05-27T18:46:11Z")
The recipes are completely phony for testing purposes, by the way.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [May 28, 2019, 6:33am UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/5 "2019-05-28T06:33:28Z")
So, you have two fields - equipment and ingredients - for which you need to get a recipe.
Which option to enter values for the search you choose?
1. Random input - in this case, the user can enter arbitrary names of equipment and ingredients
2. Entering equipment and ingredients from the lists - in this case, the user can select field values from lists only. The advantage of this method is that the user will be guaranteed to choose only the equipment and ingredients that are in the database
Since you can search for several values of equipment and ingredients, the search string should consist of a comma-separated list:
water, white sugar, rice
After that, through the entire database, make a cycle for searching records, in which there is water, rice, and sugar. You will have 2 cycles - on the entire table and on all the words specified in the search bar.
Do you understand the general idea?
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/advanced-querying-for-airtable/77026/6 "2024-11-08T12:13:40Z")