Skip to main content
Best answer

Zapier creating to many records Looping

  • April 28, 2021
  • 1 reply
  • 78 views

Forum|alt.badge.img

I have a Trigger from a Knack a no code platform and in the Data it sends the row contains Name some other information and then cities . It might have 1 city 3 cities 5 cities its different every time . Each city is always separated by a comma.  So I my next step is to create a row in google sheets which I need to basically create a separate row with all the same data except for each with the different city in the triggered data.  I am using this data for a lookup later in another Zap and doing a lookup in GSheets you cant lookup and find data in a column that as example Tampa if the city row contains for example Tampa, Orlando, Miami. So in my loop City was the loop field name and Address was my area field containing the 3 fields. It seemed to work correctly when testing and dropped 3 separate record into GSheets each with the different city. When I did it live it dropped 9 records so the 3 separate records with he 3 different cities times 3. Below is my loop,

 

Best answer by TimtechBest answer by Timtech

I solved my own problem using JS from a great post. For anybody else here it is 

 

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.

1 reply

Forum|alt.badge.img
  • Author
  • Beginner
  • 15 replies
  • Answer
  • April 28, 2021

I solved my own problem using JS from a great post. For anybody else here it is