Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

FilterByFormula IF syntax

Topic Labels: API
498 0
Showing results for 
Search instead for 
Did you mean: 


I’m trying to use the API encoder to find if a value exists using filterByFormula, and in response get a certain string if it exists and another string if it doesn’t.

This is where I’m at but it seems it’s not the direction
IF(FIND(“5z”,{Field 6})=0, “DOESNT”, “EXISTS”)

Any ideas?

0 Replies 0