Skip to main content
Best answer

Looping issue with airtable value

  • September 16, 2021
  • 9 replies
  • 281 views

chrisfinck
Forum|alt.badge.img+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?

 

 

Best answer by Troy Tessalone

@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)
View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30830 replies
  • September 17, 2021

Hi @chrisfinck 

Please post screenshots of how your Zap steps are configured.


chrisfinck
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 32 replies
  • September 17, 2021
Troy Tessalone wrote:

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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30830 replies
  • September 17, 2021

@chrisfinck 

What about Step 8?


chrisfinck
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 32 replies
  • September 17, 2021
Troy Tessalone wrote:

@chrisfinck

What about Step 8?

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

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30830 replies
  • September 17, 2021

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

 


chrisfinck
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 32 replies
  • September 17, 2021
Troy Tessalone wrote:

@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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30830 replies
  • September 17, 2021

@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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30830 replies
  • Answer
  • September 17, 2021

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

chrisfinck
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 32 replies
  • September 17, 2021
Troy Tessalone wrote:

@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