# How should I get only filtered values from Airtable?

**URL:** <https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807>\
**Category:** Questions about Thunkable X\
**Tags:** airtable\
**Created:** [September 6, 2019, 4:18pm UTC](https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807 "2019-09-06T16:18:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\
**Post date:** [September 6, 2019, 4:18pm UTC](https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807/1 "2019-09-06T16:18:23Z")

</div>

Hello Community! 🙂  
I want to get filtered data from Airtable…  
Filtered like,

- first get a column, named **“Content Genre”**.
- Look **for each** in the column, if Author’s Genres (from his tinyDB) = item (j).
- Then, collecting every item, from column named **“Company Name”** (only if the above filter applies well in the **“Content Genre”** column) and show he filtered list in a listview.

* * *

> More clearly, **if** item from column **=** tinyDB Genre, then take the object **Company Name** and add it in a listview.  
> When listview item clicked, look for the name in the column **Column Name** , get the particular row, and text message it’s “ **Contact No.** ” object.

* * *

### This is what I’ve tried so far - (I’m stuck after if…)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/7/b7f7232244754d584d639bac198eed868518ae2a.png)

* * *

Any help is appreciated!  
Thanks a lot! 😄

---

<div class="post-metadata">

**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\
**Post date:** [September 7, 2019, 7:53am UTC](https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807/2 "2019-09-07T07:53:54Z")

</div>

Anyone?  
I am just stuck with it 😔

---

<div class="post-metadata">

**Author:** ![jane](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jane/32/27575_2.png) [@jane](https://community.thunkable.com/u/jane)\
**Post date:** [September 9, 2019, 12:38pm UTC](https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807/3 "2019-09-09T12:38:01Z")

</div>

Hi there,

Have you looked at Domhnall’s instructional post for [searching and filtering a Local DB](http://community.thunkable.com/t/search-filter-localdb/68902)?

It should be very similar!

Of course, you can ignore the steps relating to getting a search term from a Text Input if you are searching for things that match a stored value!

As always, I recommend using a stored variable over a local storage component!

In short, you should create a new list, which I’ll call Result List. If j = value, add j to Result List.

You don’t need that else if block, as the ‘for each item in list’ block will in fact continue with the next iteration of the loop whether j = your search term or not!

---

<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:09pm UTC](https://community.thunkable.com/t/how-should-i-get-only-filtered-values-from-airtable/213807/4 "2024-11-08T12:09:05Z")

</div>