Hey everyone! I’m new here and could use some help.
I’m trying to set up an Airtable-Zapier integration. The goal is to automatically update a status column when an ID in another column is an odd number. I’ve been searching online but can’t seem to find the right solution, especially for the search formula part.
Has anyone done something similar? Any tips or tricks would be really helpful! I’m not sure if I need a specific Zap or if there’s a way to do this directly in Airtable.
Thanks in advance for any advice you can give. I’m excited to learn from this community!
I’ve found a neat workaround for this using Airtable’s scripting feature. It’s more flexible than automations and doesn’t require Zapier. Here’s the gist:
Create a new script in your Airtable base. Use the scripting block to write a simple function that checks for odd IDs and updates the status. You can schedule this script to run at regular intervals or trigger it manually.
The script would look something like this:
let table = base.getTable(‘YourTableName’);
let query = await table.selectRecordsAsync();
for (let record of query.records) {
let id = record.getCellValue(‘ID_Column’);
if (id % 2 !== 0) {
await table.updateRecordAsync(record, {
‘Status_Column’: ‘Odd’
});
}
}
This approach gives you more control and can be easily modified for more complex logic if needed.
hey alexr1990, try using airtable’s automations insted of zapier. set it to trigger on changes and check if MOD({ID Column},2)=1. if true, the status updates automatically. it’s faster and saves you a buck! ask if u need more details.
I’ve actually implemented something similar in my workflow. Here’s what worked for me:
Instead of using Zapier, I found it more efficient to use Airtable’s built-in automations. You can set up an automation that triggers when a record is created or modified. In the automation, use a ‘condition’ step to check if the ID is odd.
The formula for checking odd numbers is pretty straightforward:
MOD({ID Column}, 2) = 1
If this condition is true, you can then use an ‘update record’ action to change the status column.
This approach is faster and doesn’t require leaving the Airtable ecosystem. It’s also more cost-effective if you’re working with a large number of records.
Hope this helps! Let me know if you need any clarification on setting up the automation.