Hi i need help im very stuck and the AI isnt helping much and making it more difficult to understand
so what im trying to do is kinda simple in my head, bring Google SpreadSheet 1 (Form Responses Sheet) to SpreadSheet 2 CRM with a router and 2 filters so to remove double entry and adding UID
The entry point is at point but the problem i have is when it gets to Spreadsheet 2
as you can see it only shows the first bundle, yet the sample entry has 3 bundles but it never shows the first
this is the build im doing im not sure if its lacking something, but it only enters 1 bundle never the rest
Hey @James_Milner,
What I’d do in cases like this (if I’m correctly understanding the problem), is read in all of Spreadsheet 2 first, follow that by an Array Aggregator.
Then, start iterating rows from spreadsheet 1. In each iteration, you can use map() function on the array created initially to look up the value from spreadsheet 2 to see if it exists. If so, you’ll have your row number and can update that row.
If it doesn’t exist, you’ll have to add a row to spreadsheet 2.
This doesn’t handle cases where spreadsheet 1 has duplicates, that’d be a slightly different story.
Hope that makes sense and hope it helps!
2 Likes
Thank you for the reply @Donald_Mitchell,
Ive actually been waiting a reply since i posted it ill try your solution to the problem i dont have this problem with typeform app but its good to be ready just in case someone wants to use google
Thank you for Replying!
After dabbling about it for an hour i would like to say the solution with the spreadsheet 1 to spread sheet 2 with filters worked.
Thank you again for the reply
2 Likes
