I’m trying to create a simple dictionary app that will search a column of an airtable database for a user-entered string, and if it a match exists, then display the definition I’ve written (which is stored in another column of the same table). I think this is a pretty simple query, but I can’t find any blocks in the airtable section that seem to deal with queries directly.
I tried to get a SQLite extension (which seems to have querying built in), but I just found out I can’t use extensions with Thunkable X.
So then I think I need to write the query manually, but I don’t know how to do this. Do I need to dump the data from that column in airtable into a variable or list, then search the list somehow? Or can I query the airtable directly? If so, which blocks do I use?
I’m new to this, obviously. Thanks to anyone who has time to spare to help!