Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am trying to synchronize Airtable with Zapier. The goal is to check the modified field in Airtable. Once a field is modified, every fifteen minutes it will trigger a Zap in Zapier. I want Zapier to first search if the record already exists. If it does not exist, create the record. If it does exist but has been updated, update the record.

I have used Make.com for years and created many automations. I am knowledgeable about automation workflows but new to Zapier, so I must be making an error in identifying the correct fields for search, update, and create.

I have noticed when looking at the loft that an id field is equal to the record ID from airtable but followed with date and time. I am pretty sure this is where the issue is coming from. 

I do not have issue to CREATE a record in TABLE when a new record is created or updated in airtable. But the issue is this duplicate therefore some records in TABLE. What I failed is updating a record in TABLE.

Your support would be greatly appreciated.

 

 

Hi ​@Pascal 

For us to have more info about the error, post screenshots showing how your Zap steps is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

Thanks. I will zhen I will.get back to my desktop. Thanks. 

Here some screen shots, hopefully it will help.

 

​@Pascal 

Screenshots are from the ZAP VIEW mode of the CONFIGURE tab.

Posting screenshots from the ZAP EDIT mode of the CONFIGURE tab will show the field types.

TIP: Click field labels to see tooltips with more info.

 

For Zap step 3, to update a Zapier Table Record, the Zapier Table step expects the Zapier Table Record ID for the Record ID field, rather than the ID of the Airtable Record.

 

So map the Zapier Table Record ID variable from Zap step 2.

 

​@Pascal 

TIP: You can add another Zap to log the Zapier Table Record ID on each Record in a Field, so it is more visible.

STEPS

  1. Trigger: Zapier Tables - New Record
  2. Action: Zapier Tables - Update Record
    1. Log the Zapier Tables Record ID in a field

 

TIP: On a Zapier Table record, at the left of the record, you can hover/click to view record details, which at the bottom will show the Zapier Table Record ID and Created/Updated metadata.

​@Pascal 

Help links for using Zapier Tables: 

https://help.zapier.com/hc/en-us/categories/13398036609933-Tables

https://zapier.com/apps/zapier-tables/integrations#help

Thank you for your help. I was able to find the problem thanks to your guidance. The issue was that the record ID I was using to update the record in Zapier Table was the Airtable Record ID, while it should have been the Zapier Record ID. Now it works!

 

Terms & ConditionsAccessibility statement