I am posting my first query. I am working on integrating Airtable with Zapier. My goal is to have Zapier update a STATUS field whenever an ID in a specific column turns out to be an odd number. I searched online but did not find a clear solution, especially regarding the search formula. Any advice would be really appreciated. Thanks a lot!
I encountered a similar scenario during a recent integration project and found that using a Formatter step in Zapier significantly helped. I extracted the ID, computed the remainder when divided by two, and then passed that value to a filter step. This approach allowed me to ensure that only records with odd IDs triggered an update in Airtable. Although it involved some trial and error, the process ultimately provided a more dynamic solution than relying solely on a static search formula.
hey, try a filter step insdie zapier which checks if the id mod 2 equals 1, then update the status. might take some trial n error, but i think this could work for u