[Solved] Search for a particular AirTable table entry from Zapier


#1

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.


#2

You could create a formula field to test it:
IF(AND(…your criteria…), “MATCH”, “NOT MATCH”)


#3

Thanks for the tip, the following indeed works. I changed the type of the “Asked” column to be a “short text” with “true/false” as values (can anyone tell me how to test the value of a checkbox?). Then I created a new column with type “Formula” in AirTable and pasted the following in the field:

IF(AND(Asked="true", Type="Category1"), "MATCH", "NOT MATCH")

But I didn’t find how to put this into Zapier yet. The “{ }” around the column names do not seem to change anything… has anyone tried that before?


#4

for checkbox, just compare with 1 (checked) or 0 (not checked) (i.e. AND(Asked=1, Type=“Category1”)

For zapier, if your value is coming from a previous step, then you would need to wrap with Step Value

See docs: https://support.airtable.com/hc/en-us/articles/218151657?utm_source=zapier.com&utm_medium=referral&utm_campaign=zapier#formula


#5

Thanks a lot, the 0 and 1 was the missing information!