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
Hey @Tina_Fountain, I think This 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)
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.
Do you initialize or set âapp taskâ as an empty list anywhere on that screen before you use it?
Hi again, thanks for the response. I do initialise it as an empty list.
Youâre supposed to use the = symbol with a slash in it Iâm pretty sure
Put the block to set the list viewer outside of the loop, for starters.
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
Tried and still no joy! also tried listviwer under the get all rows block.
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.
can you verify that there are no spaces that should be somewhere, like after a word
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
Thanks
It should not matter, but I have tried this too and no joy!
@domhnallohanlon any ideas?
Still not been able to solve this if anyone else has ideas or samples I can look at
can you share a post of the blocks you are trying currently? or a share link to your app?
i would try renaming columns
https://x.thunkable.com/copy/2ecf2402d004f0746076011d7eaaa485
is link to what i have now.
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
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.
@Michael_Rogulla, nice find!
The data need to be right!
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.