# Getting a list of data from an Airtable (searching for matches) **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** airtable\ **Created:** [March 17, 2021, 11:54am UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382 "2021-03-17T11:54:05Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![andreyandrievich](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andreyandrievich/32/94386_2.png) [@andreyandrievich](https://community.thunkable.com/u/andreyandrievich)\ **Post date:** [March 17, 2021, 11:54am UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/1 "2021-03-17T11:54:05Z")
Hi! I’m making a project where I need to save and retrieve data from an Airtable, and I have a problem getting a list of rows (possibly due to the fact that I have no experience with lists). **How it should work:** When a new row is added to Table1, we need to search for all the rows that match it in Table2. The search for matching rows is performed on 3 columns (Column1, Column2, Column3), which specify the value True or False. If in Table1 in one of the columns there is a True value, then in Table2 in the corresponding column we also look for the True value. But, if in Table1 in one of the columns there is a value False, then in Table2 in the corresponding column we are looking for the value False or True. I would be grateful for any help with this! ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 17, 2021, 5:34pm UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/3 "2021-03-17T17:34:40Z")
Are you connecting to your table using the Airtable component or the Data Sources connection? Each of them uses different set of blocks. ---
**Author:** ![andreyandrievich](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andreyandrievich/32/94386_2.png) [@andreyandrievich](https://community.thunkable.com/u/andreyandrievich)\ **Post date:** [March 17, 2021, 6:42pm UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/4 "2021-03-17T18:42:48Z")
To add new rows to table1, I use Data sources. But for finding rows in table2, I joined the table through the API. Can Data sources and API blocks work together (in one project) or better not mix them? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 17, 2021, 7:40pm UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/5 "2021-03-17T19:40:07Z")
That would be awkward but nevertheless remains doable. ---
**Author:** ![andreyandrievich](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andreyandrievich/32/94386_2.png) [@andreyandrievich](https://community.thunkable.com/u/andreyandrievich)\ **Post date:** [March 18, 2021, 9:12am UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/6 "2021-03-18T09:12:46Z")
I found the right solution in this Post: > [@\[Solved\] Retrieve data from Airtable based on condition](https://community.thunkable.com/t/solved-retrieve-data-from-airtable-based-on-condition/29281/14): > > Hi, First of all you need to get all records from a table in a list with a block of “getAllRows”. After that, local storage will contain all data from the table and they can work on any screen. List filterList stored filtered on two fields a “email” field and Age. This list is assigned to the ListViewer and it displays only the values for the field Name (values of \_id non visible). Selecting from the list with the value of the Name field is also a unique key of \_id entry in which the entry can … I was able to build my solution on the basis of this: ![getallrows](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/9/f92fe6098d63d93b26cca6121b73769b94109f9e.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 18, 2021, 9:55am UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/7 "2021-03-18T09:55:58Z")
Good. GetAllRows is only available in the Airtable component not in the Data Sources connection but as long as it works for you it shouldn’t matter. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:25pm UTC](https://community.thunkable.com/t/getting-a-list-of-data-from-an-airtable-searching-for-matches/1172382/8 "2024-11-08T13:25:56Z")