About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Updating a column in Excel doesn't add the info to the right Record in Airtable

  • 12 December 2022
  • 6 replies
  • 48 views
P
Userlevel 1
Badge

Hello everyone! 

I’ve an Excel sheet where a certain column will be updated once in a while. Let’s say that the Excel sheet contains 20 unique rows and the column can be updated for each row separately. 

I want this to be updated on the Records in Airtable, but as of now the updated information is only visible on 1 Record, so it’s like each time the Zap fires it updates the same Record in Airtable. 

Here are pictures of the Zap: 

So here is the Trigger Column ‘Skjul?’

 

I let the Zap find the Record in Airtable based on the Name of the row in Excel 

 
Here we can see that the ‘Fejl’ field in Airtable will be updated based on the Column in Excel. However the Record ID is wrong, and that’s where I think the error occurs. 

How do I fix this so that Zapier updates the right Record in Airtable?

 

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

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @plyske 

Good question.

You should use a dynamically mapped variable for the Record ID from the previous step instead of a static value.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P
Userlevel 1
Badge

Hey, @Troy Tessalone 

Thanks for getting back! 

 

So just to be sure, I should use one of these variables instead: 

 

Or would it be better to have the ‘Update Record in Airtable’ look for a variable in Excel? 

 

Troy Tessalone
Userlevel 7
Badge +14

@plyske 

In Zap Step 2, you are using Airtable Find Record.

In Zap Step 3, you are using Airtable Update Record.

It’s likely that you want to use the returned Record ID from Step 2 to indicate which record to Update in Step 3.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P
Userlevel 1
Badge

But isn’t that what I’ve been doing the whole time? 

 

If you look at the pictures, that’s the Record ID showing in Step 3 of the Zap. So what’s the difference?

Troy Tessalone
Userlevel 7
Badge +14

@plyske 

Taking your screenshot example...

Record has a static value.

Feji has a dynamic variable mapped.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
Userlevel 7
Badge +9

@plyske

In Zap Step 2, you are using Airtable Find Record.

In Zap Step 3, you are using Airtable Update Record.

It’s likely that you want to use the returned Record ID from Step 2 to indicate which record to Update in Step 3.

 

Hey there, @plyske! I wanted to swing by and see how you were getting along with this? 🙂

To piggy back off what Troy mentioned - the static variable essentially means every time this zap runs it will look for that exact record.

Whereas if you map the dynamic variable from the previous step as shown in the screenshot he shared, it will change accordingly based on  the mapped field.

Keep us posted! 🤗

Terms & Conditions