# How to show filtered airtable data on my app

**URL:** <https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563>\
**Category:** Questions about Thunkable X\
**Created:** [July 27, 2021, 12:09pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563 "2021-07-27T12:09:43Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 27, 2021, 12:09pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/1 "2021-07-27T12:09:43Z")

</div>

My user will input some data on Airtable, and they will only have access to his own data. I want to filter this by the User ID, that’s in the first column of my table. I’m using the beta interface, and tried a lot a ways to do this, but none of them gives the result that i want. Sorry if i’m not clear, trying to explain in English!

---

<div class="post-metadata">

**Author:** ![overturner](https://avatars.discourse-cdn.com/v4/letter/o/53a042/32.png) [@overturner](https://community.thunkable.com/u/overturner)\
**Post date:** [July 27, 2021, 12:16pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/2 "2021-07-27T12:16:21Z")

</div>

This will help you a lot  
https://www.youtube.com/embed/videoseries?list=PLArgGKS_QtY6Pyo-6TJQNusmI6Uzt-37U&wmode=transparent&rel=0&autohide=1&showinfo=1&enablejsapi=1  
Video playlist from @darren

---

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 27, 2021, 12:42pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/3 "2021-07-27T12:42:30Z")

</div>

I’ve already seen this series of videos. But one of the features that he uses is no longer available.  
He uses the Getallrows, and i don’t know where is this function now.

---

<div class="post-metadata">

**Author:** ![overturner](https://avatars.discourse-cdn.com/v4/letter/o/53a042/32.png) [@overturner](https://community.thunkable.com/u/overturner)\
**Post date:** [July 27, 2021, 12:52pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/4 "2021-07-27T12:52:11Z")

</div>

Are you using Snap to face interface or Drag and drop?

---

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 27, 2021, 1:13pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/5 "2021-07-27T13:13:03Z")

</div>

Drag an drop…

---

<div class="post-metadata">

**Author:** ![overturner](https://avatars.discourse-cdn.com/v4/letter/o/53a042/32.png) [@overturner](https://community.thunkable.com/u/overturner)\
**Post date:** [July 27, 2021, 1:23pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/6 "2021-07-27T13:23:00Z")

</div>

oh! drag drop doesn’t have airtable component so…  
Making on stp would have been better.  
This is all i know maybe someone else knows better?

---

<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:** [July 27, 2021, 1:29pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/7 "2021-07-27T13:29:31Z")

</div>

Are you displaying your result in a Data Viewer List?

If yes, you can use the `list of values` block in `Data Sources` drawer to get a list of values and do your conditional test.

You can show a screenshot of your blocks so others can give a better advice

---

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 27, 2021, 1:47pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/8 "2021-07-27T13:47:01Z")

</div>

My blocks are in portuguese, so i’ll translate to you.  
Lista ID Meus Equipamentos is the mails list.  
The User ID in purple block comes from my table, giving the users e-mail, and it works.  
I’ve got a list of this e-mails, but i’ve done the conditional test, and don’t know where to go on the next step.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/c/2c92a385c58b0519a7ada443c465b4b24e39d1fb.png)

---

<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:** [July 27, 2021, 4:29pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/9 "2021-07-27T16:29:17Z")

</div>

Your if condition should not work. First start with a loop to take the entries of the list one by one and test the condition per item in the list.

See this example  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/a/da99a9f76c45aba1fa091937bfd78edec41c933e.png)

---

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 27, 2021, 6:32pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/10 "2021-07-27T18:32:39Z")

</div>

It Works! The list show only the selected mail. Now i want to show some data on this row.  
😀 😀

---

<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:** [July 27, 2021, 7:31pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/11 "2021-07-27T19:31:06Z")

</div>

Glad that this helped

---

<div class="post-metadata">

**Author:** ![rrocha.gabriel](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rrocha.gabriel](https://community.thunkable.com/u/rrocha.gabriel)\
**Post date:** [July 28, 2021, 2:16pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/12 "2021-07-28T14:16:55Z")

</div>

It helped a lot. But i’ve used the row id, and then used the mail to filter.

Thanks @muneer

---

<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, 1:17pm UTC](https://community.thunkable.com/t/how-to-show-filtered-airtable-data-on-my-app/1416563/13 "2024-11-08T13:17:44Z")

</div>


