# Help with airtable to filter data by column

**URL:** <https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423>\
**Category:** Questions about Thunkable X\
**Created:** [February 6, 2020, 9:30am UTC](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423 "2020-02-06T09:30:51Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [February 6, 2020, 2:30pm UTC](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423/3 "2020-02-06T14:30:42Z")

</div>

Welcome to the community @komchalachp this code below and reading through the form lost I linked at the bottom may help.

I use get all rows and then filter out rows as I don’t need them. I filter out by date and username. You could easily switch filtering for dates to filtering for a quiz name or something similar.

Do a get all rows call to airtable  
Put the results into a loop  
Do a if/then block for

If property (quiz name) of object j doesn’t equal var (quiz name set by user) → continue with next iteration of loop

I then extract the info I need and put it where it goes!

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

See this link

> [@\[Solved\] How to query and filter data from airtable?](http://community.thunkable.com/t/how-to-query-and-filter-data-from-airtable/368045):
>
> This has been asked in the past but I did not find an answer that helped so I am hoping someone can help me construct the blocks. I am wanting to query some data from airtable however, I have many users data coming into the same table because they all use the same app. (no duhh!) I want to be able to call specific rows based on qualifiers from 2 columns the UserName and TypeOfData. from those row I want to get data from the behavior counts to create 3 lists of data to be used as paired coordi…

---

_[View the full topic](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423)._
