# 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:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![komchalachp](https://avatars.discourse-cdn.com/v4/letter/k/b5e925/32.png) [@komchalachp](https://community.thunkable.com/u/komchalachp)\
**Post date:** [February 6, 2020, 9:30am UTC](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423/1 "2020-02-06T09:30:51Z")

</div>

Hi all  
I have created a quiz that has multiple topics which are all stored in one table in airtable. I want to use one screen to present the questions from the table one by one. I have this working. However i now need to filter the topics. i have a screen that has the topics store in a listviewer. the user picks a topic and how many questions they want to attempt. This is where I cant get passed.

I can’t work out how to filter the questions and then show 1 by 1 the questions as the uses work through the quiz.  
below is the code so far without a filter

Thank you

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/7/e728aae8a6f8922560d56f89f34593ba81e26304.png)

---

<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…

---

<div class="post-metadata">

**Author:** ![komchalachp](https://avatars.discourse-cdn.com/v4/letter/k/b5e925/32.png) [@komchalachp](https://community.thunkable.com/u/komchalachp)\
**Post date:** [February 20, 2020, 2:11am UTC](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423/4 "2020-02-20T02:11:47Z")

</div>

Hi thanks for the response.

I took the code and tried to replicate it into my own. I tried many options to filter it, however, I am still having problems with populating the questions and the answers into text boxes and buttons.

This is what I have so far

 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/b/fb9ccfa9e5bb1e783f0459ee7f43a2f15771793f.png)

---

<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, 11:40am UTC](https://community.thunkable.com/t/help-with-airtable-to-filter-data-by-column/448423/5 "2024-11-08T11:40:56Z")

</div>


