Now I’m struggling when retrieving data from airtable by “switch” procedure. With my other “switch” procedure it’s work but in this case, the compiler when I “Do it” doesn’t return the same result. It keeps telling me that the list length is 0 while the variable already accepted the value from the airtable, anything seems wrong guys? Thanks in advance!
I want to check from the table if there are any “hadir” value in every column on each specific row (the tinyDB already stored the “absen” which is an ID). And the list on the airtable is not an empty list. When I test with “Do it” it seems like it can retrieve the value of every column but can’t stored to each variable
In that case your using the logic block kind of complicated… instead of using direct select list item is not equal to “hadir” …why not use is in list thing list block if any value exist in the list? Once you call data from airtable, were transfering or copying the data from table and stored it in variable list… try to check the list first… using the in list thing block if what your looking value exist then get the index, and youll get the present row from airtable with that value.
but isn’t that just show if there are “hadir” on the entire column? I want to check on the specific row (which is exactly the same as the user ID). In this case my ID is 1 so I want to check if the “hadir” is on the Materi1, Materi2, Materi3, and Materi4 column
so like on the table on Materi2, there are no “hadir” so the app will erase the “hadir” value of the tinyDB. But considering on the solution you’re provided there are no error, it seems like the app can store the value “hadir” from the airtable to the variable but if I use specific row it seems like it detect there are empty list, now I’m confuse how to solve this
This is a new airtable extension. Maybe you can get the row data first, it’s a jsonarray. You can parse it with dictionary, then check if the data contains some word.
Ps: normally if the value is empty,this column will not exist in the returned data.
Hmm… I think for you to solve your issue, you can use Kevin Airtable Extension for a better option, since your using airtable looks complicated, i suggest to format your data using a formula provided by Airtable, merge all the column in one column, in this case you will only call one column but your taking all data, your just need to parse everything by blocks and split it in different variable list. For your issue check kevin airtable features