Hello everyone, new member here!
I’m trying to set up an automation between Zapier and Airtable. The goal is to check if a number in one field is odd, and if it is, then automatically change the value in a different status field.
I’ve been looking around online but can’t seem to figure out the correct formula to use in the search criteria. Does anyone know how to write the proper search formula for this type of condition?
Any guidance would be really helpful. Thanks in advance!
Had this exact issue last month with inventory automation. Use Zapier’s formatter before hitting Airtable - add a “Formatter by Zapier” step with the Numbers utility. Write {{your_number_field}} % 2 as your formula to get the remainder. Then create a conditional path: if the result equals 1, trigger the Airtable update. Way more reliable than trying to handle the math in Airtable’s search, especially with dynamic data from other apps.
Use the modulo operator in your Zapier search criteria. Set up a Filter action that checks if your number field modulo 2 equals 1 - this catches all odd numbers. When that condition’s met, it’ll update your status field. I’ve used this exact setup before and it works great. Just make sure you test it with both odd and even numbers first.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.