I have a name, date and status column in airtable. What is the best way to see if a row exists with a given name AND date and if so set status to a variable in my thunkable app? I’m very new to airtable so any help is greatly appreciated!
Thanks,
Robin
Use the airtable get column block to extract a list of “names” and use another for “dates”, and loop through to find the corresponding index to the name in the list. Then use the index (equates to the row number in airtable) with the set cell, get cell or get row blocks to change/access your contents in airtable.
Hi @rwilenskyz,
it is possible to perform search operations in airtable. Please have a look at the issue #479 in github (https://github.com/thunkable/thunkable-issues/issues/479) or the solved issue #518 (https://github.com/thunkable/thunkable-issues/issues/518).
You can build complex filter operations like “{Name} = … AND {Date} = …”.