# How to get rows from Airtable with Data Viewer List

**URL:** <https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660>\
**Category:** Questions about Thunkable X\
**Created:** [December 23, 2020, 9:39pm UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660 "2020-12-23T21:39:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\
**Post date:** [December 23, 2020, 9:39pm UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660/1 "2020-12-23T21:39:20Z")

</div>

Hi

I am working on a new project with multiple screens. My airtable has 2 tables with data as follows  
table1  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/8/784af5dff28dcb2cd0b300d67a6afb0e78da8b7b.png)

table2  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/01feb1b1dcf873fe94c677114433ee20d4715fda.png)

In screen1, the data viewer list loads entries in table1

When you click any of the list, it switches to screen2 which also has a data viewer list and that also loads everything in table2.

The challenge is I don’t want screen2 to load everything in table2. It should only load the rows that matches the name column. So if I click on Yoga exercise on screen1, screen2 should only load yoga level 1 and yoga level 2 list.

How can i accomplish this since the rowID on both tables won’t match. Thanks

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [December 23, 2020, 9:52pm UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660/2 "2020-12-23T21:52:10Z")

</div>

You’ll want to filter data into a localDB and use that as your data source

Save exercise choice to app variable “exerciseName”  
Call airtable for table 2  
Get all rows  
Save rows to app variable “allRows”  
For each item in all rows  
If get property Name of object j contains text exercise name  
_ **Add row to local DB** _  
Else  
Continue with next iteration

---

<div class="post-metadata">

**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:** [December 23, 2020, 10:04pm UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660/3 "2020-12-23T22:04:25Z")

</div>

Check this example

> **[Thunkable](https://x.thunkable.com/projects/5fb9fb1dbfeb240011084d78/cfd9093a-fc92-4b6b-880c-47a749dffddf/designer)**

I made it as an example of a similar request.

Happy Thunking

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [December 24, 2020, 3:28am UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660/4 "2020-12-24T03:28:05Z")

</div>

Great work!

---

<div class="post-metadata">

**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, 12:19pm UTC](https://community.thunkable.com/t/how-to-get-rows-from-airtable-with-data-viewer-list/1041660/5 "2024-11-08T12:19:30Z")

</div>