Best answer

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

  • 25 August 2020
  • 3 replies
  • 103 views

Userlevel 1
Badge

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.

icon

Best answer by saintbrian 29 August 2020, 20:30

View original

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

Userlevel 7
Badge +14

In your Zap…

Action: Airtable - Find Record

Action: Airtable - Update Record

 

Userlevel 1
Badge

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!

Userlevel 7
Badge +11

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