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.

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?

 

Hi @plyske 

Good question.

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

 

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? 

 

@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.

 

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?

@plyske 

Taking your screenshot example...

Record has a static value.

Feji has a dynamic variable mapped.

 

@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