Skip to main content
Best answer

update a record in airtable based on a corresponding value in another table

  • August 25, 2020
  • 3 replies
  • 129 views

Forum|alt.badge.img

I have two tables in Airtable that have 4 matching fields.  The identity field is email address.  Based on the values in table 2, I would like to update Table 1 where the email field matches.

 

I’m able to connect to both tables, and I can see records in both … but I’m not sure how to create the Zap.

 

Any guidance would be appreciated … I’m still reading docs in Zapier, so if I find the solution myself I’ll post it.  Thanks.

Best answer by saintbrian

Thank you for your response!

 

Ultimately I was able to speak with a Customer Support person who helped me understand what I was missing.  Just thought I’d come back here to post about in case someone else had trouble connecting the dots in the future.

In my Find stage, I was searching for Email, but in the Update stage, I needed to select the RecordID.  Once I understood that and made the change, my Zap worked perfectly!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 25, 2020

In your Zap…

Action: Airtable - Find Record

Action: Airtable - Update Record

 


Forum|alt.badge.img
  • Author
  • Beginner
  • Answer
  • August 29, 2020

Thank you for your response!

 

Ultimately I was able to speak with a Customer Support person who helped me understand what I was missing.  Just thought I’d come back here to post about in case someone else had trouble connecting the dots in the future.

In my Find stage, I was searching for Email, but in the Update stage, I needed to select the RecordID.  Once I understood that and made the change, my Zap worked perfectly!


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • September 4, 2020

Thanks for the update @saintbrian :) And happy to hear that you got things working!