# \[Solved\] Filter from airtable issues **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** solved\ **Created:** [March 8, 2020, 8:52am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292 "2020-03-08T08:52:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 8, 2020, 8:52am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/1 "2020-03-08T08:52:32Z")
Hi i am having a real issue filtering data in airtable I have followed several different posts but nothing. can anyone see what I am missing ![Screenshot 2020-03-08 at 15.34.27](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/f/9f921e2dc5577f01e911d488d372f2e9168a8f89.png) ---
**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:** [March 8, 2020, 12:05pm UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/2 "2020-03-08T12:05:40Z")
Hey @Tina_Fountain, I think [This](http://community.thunkable.com/t/i-need-help-with-airtable-searching-through-rows/497051/16) may help you out. Basically you need to get first, “all rows” Throw the green value block from “all rows” into a loop Then in the loop(Using whatever variable you choose to store the info) In list (VariableName) insert last as (get property ‘task’ of object j) ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 1:28am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/3 "2020-03-09T01:28:00Z")
Tried that. but no joy. here are two attempts. I have also followed several other posts with no joy. The base ID is correct as are the column names. if I take out the filter the data loads. so I am confident that it’s related to the filter. I have tested with a value in place of the variable. I have tried calling the columns individually and calling a row by counting the iteration not sure what I am missing. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/e/fe64ea8e0b39b83806c02833d6566ebf3891adf8.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/1/d1fc74ed2d437443405d126818a4db8973d48948.png) ---
**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:** [March 9, 2020, 1:39am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/4 "2020-03-09T01:39:29Z")
Do you initialize or set “app task” as an empty list anywhere on that screen before you use it? ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 2:04am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/5 "2020-03-09T02:04:59Z")
Hi again, thanks for the response. I do initialise it as an empty list. ---
**Author:** ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)\ **Post date:** [March 9, 2020, 2:17am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/6 "2020-03-09T02:17:16Z")
You’re supposed to use the = symbol with a slash in it I’m pretty sure ---
**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:** [March 9, 2020, 2:21am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/7 "2020-03-09T02:21:00Z")
Put the block to set the list viewer outside of the loop, for starters. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/e/bebd31fbfc118db0f351e3a0586bdce27039a8ef.jpeg) My blocks are right to get info from a table on airtable. Then try to change the logic, if property … of object j doesn’t equal … continue to next iteration. No else. Below that bock, your query blocks Like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c716cc596d336a0fd30fb27b3205716d1be21245.jpeg) ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 2:37am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/8 "2020-03-09T02:37:20Z")
Tried and still no joy! also tried listviwer under the get all rows block. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/0/200e1bdfde2781cb6265ee375467271ceef89a8e.png) ---
**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:** [March 9, 2020, 2:50am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/9 "2020-03-09T02:50:39Z")
Can you post a screenshot of your airtable with headers? I would also make sure there is something in the app year variable. You could just put it onto a lane as the first thing that happens when you open the creek as a way to debug. The process is right. If it’s not getting data there’s a bump in the blocks. First make sure the baseID and API key are correct. Then try and send data. Then try to get data from just 1 row. Then try all rows again. You could try putting text into the filter instead of the variable. ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 2:52am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/10 "2020-03-09T02:52:58Z")
Thanks for sticking with it. If i take out the filter I can populate the app no problem. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/b/abc66abcaedf2c450a0d68c15813aca55ecc0fb4.png) ---
**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:** [March 9, 2020, 3:35am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/11 "2020-03-09T03:35:39Z")
can you verify that there are no spaces that should be somewhere, like after a word ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 3:45am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/12 "2020-03-09T03:45:02Z")
Yes. Tried that also. Spent hours trying to trouble shot yesterday. Like I say it works minus the filter so I know the base ID and API key and table name are all OK its very odd. I have done this before with no problem. also tried this way ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/b/cb2e7391f38883c4ed0a32298a91f51e54a46851.png) ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 9, 2020, 11:04am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/13 "2020-03-09T11:04:35Z")
Thanks It should not matter, but I have tried this too and no joy! ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 10, 2020, 7:09am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/14 "2020-03-10T07:09:28Z")
@domhnallohanlon any ideas? ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 13, 2020, 6:48am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/15 "2020-03-13T06:48:36Z")
Still not been able to solve this if anyone else has ideas or samples I can look at ---
**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:** [March 13, 2020, 11:56am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/17 "2020-03-13T11:56:31Z")
can you share a post of the blocks you are trying currently? or a share link to your app? i would try renaming columns ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 15, 2020, 5:11am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/19 "2020-03-15T05:11:03Z")
[https://x.thunkable.com/copy/2ecf2402d004f0746076011d7eaaa485](https://x.thunkable.com/copy/2ecf2402d004f0746076011d7eaaa485) is link to what i have now. [https://1drv.ms/u/s!Ak\_PdQ6HqP2Jm1UG6FNivTkEAV77](https://1drv.ms/u/s!Ak_PdQ6HqP2Jm1UG6FNivTkEAV77) its purely test data here as i changed to a new table and recreated to see if i could see what i was missing ---
**Author:** ![Michael\_Rogulla](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@Michael\_Rogulla](https://community.thunkable.com/u/Michael_Rogulla)\ **Post date:** [March 23, 2020, 11:11pm UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/20 "2020-03-23T23:11:40Z")
Hi @Tina_Fountain, I checked your code and the data in OneDrive (excel). I think there might be a problem, when a row does not contain correct data: - First: the column (in Excel) is called “Group”, but in thunkX the block uses “GroupNumber” - Second: you have three rows in “Homework”, but only two in column “GroupNumber”. When you ask the data for the **third** row with “get property GroupNumber of object”, it does _not_ contain an element called “GroupNumber”. In this case, the loop will stop, and it might happen, that the result in “app task” does not contain anything. So please add a condition: “does list ‘get object properties of’ j contain GroupNumber” then “get property GroupNumber of object j” etc. ---
**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:** [March 24, 2020, 12:23am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/21 "2020-03-24T00:23:48Z")
@Michael_Rogulla, nice find! The data need to be right! ---
**Author:** ![Tina\_Fountain](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@Tina\_Fountain](https://community.thunkable.com/u/Tina_Fountain)\ **Post date:** [March 24, 2020, 6:45am UTC](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292/22 "2020-03-24T06:45:52Z")
Thanks. I had change the column names between this post and when you have looked to try and see what I am missing so the code is now simple Group as in the sheet I also added more data as suggested and added a condition nothing has worked! I feel like i am flogging a dead horse with this one. [Next page](https://community.thunkable.com/t/solved-filter-from-airtable-issues/504292.md?page=2)