How to get rows from Airtable with Data Viewer List

[sysads]

Hi

I am working on a new project with multiple screens. My airtable has 2 tables with data as follows
table1

table2

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

[jared]

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

[muneer]

Check this example

Thunkable

I made it as an example of a similar request.

Happy Thunking

[jared]

Great work!