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

Best answer

Looping issue with airtable value

  • 16 September 2021
  • 9 replies
  • 236 views
chrisfinck
Userlevel 2
Badge +1

I have a zap that loops through a single ID and will then modify multiple airtable records linked to that single ID. The Loop that I created will loop through the multiple IDs attached to this single ID.

When I run the zap, it will only change the first two in the preview and not the last one (aka the one shown at the top and bottom of the screenshot | 3wpoFm…). Instead it double counts loop 1 (pzeoW….) in two separate zaps. What am I doing wrong here?

 

 

icon

Best answer by Troy Tessalone 17 September 2021, 22:28

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.

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @chrisfinck 

Please post screenshots of how your Zap steps are configured.

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

Hi @chrisfinck 

Please post screenshots of how your Zap steps are configured.

 

and you can see it creates in a case of 4 records to be updated, looping 4 times which is successful. 

This is where it looped 4 times to update 4 records
Example success updating the record status

But when we check airtable, sometimes none of them are updated or only one of them out of the full set will update.

Troy Tessalone
Userlevel 7
Badge +14

@chrisfinck 

What about Step 8?

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

@chrisfinck

What about Step 8?

Step 8 Finds each record. And is also a success in each loop iteration.

 

Troy Tessalone
Userlevel 7
Badge +14

@chrisfinck

Step 8 will find the same record each time the way it is currently configured.

If you want to find different records each time, then you’ll need to pass that data point into the Looping step, then map to the Find Record step.

Seems like you need to map the output from the Looping step to this Search Value.

 

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

@chrisfinck

Step 8 will find the same record each time the way it is currently configured.

If you want to find different records each time, then you’ll need to pass that data point into the Looping step, then map to the Find Record step.

Seems like you need to map the output from the Looping step to this Search Value.

 

The loop is passing in this case 4 unique IDs through for step 9. Step 8 is to make sure out of those 4 they are all within a certain view as we don’t want to change status of ones not in the view even if they have the ID attached. See below

 

Troy Tessalone
Userlevel 7
Badge +14

@chrisfinck 

In your previous screenshots, I don’t see where the output from the Looping app is mapped to Step 8 or Step 9.

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

@chrisfinck 

Seems like the Zap steps should be structured like this…

  • Step 7 - Action: Looping
  • Step 8 - Action: Airtable - Find Record (map the output from Step 7 for the Search Value)
  • Step 9 - Action: Airtable - Update Record (map the Record ID from Step 8)
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
chrisfinck
Userlevel 2
Badge +1

@chrisfinck

Seems like the Zap steps should be structured like this…

  • Step 7 - Action: Looping
  • Step 8 - Action: Airtable - Find Record (map the output from Step 7 for the Search Value)
  • Step 9 - Action: Airtable - Update Record (map the Record ID from Step 8)

I see what you are saying. Ok I have updated, had to get a specific task in order to fill Step 7/8. Will keep you updated tonight when the test one comes through. Thank you as always seriously you are a great asset to the community

Terms & Conditions