Hi There, the query API puzzles me a little.
I have an AirDrop table that gathers questions. I have two columns „Asked“ (type „checkmark“) and „Category“ (dropdown 2 Possible values).
Now I would like Zapier to find the first record that is „not asked“ and of „category1“.
In the Zapier extended search, I tried something along the lines of what is explained here: https://support.airtable.com/hc/en-us/articles/218151657-Using-Zapier-s-Multi-Step-Zaps-to-find-and-update-records#formula
But with no success:
AND({Asked}=true, {Category}=„category1“)
Any idea?
Thanks!
PS: is there a place in AirTable where I can test the search queries? Going through Zapier to do trial & error is a bit painful.