Skip to main content

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,

 

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