What is your goal?
Use the Search Rows Google Sheets module to generate some insights
What is the problem & what have you tried?
I used the GS Search rows module to find some data and then aggregate it using an Array Aggregator. The thing is that I wanted to pass that array into a Tools Set multiple variables module in order to calculate data inside instead of using a router + numeric aggregators + set variables.
It seems that the Set Multiple Variables module is only getting the first element.
Screenshots (scenario flow, module settings, errors)
Hey Carlos,
Why not with the numeric aggregator though? It gives you the sum directly.
Anyways, what you have currently mapped in the sum function is the first item from the array, so it will not work. You will need the map function first to create a primitive array with only the totals and have that inside the sum function to calculate it.
Although a numeric aggregator works, i wanted to make it more operation-effective (i run on the free plan for now) as I not only need the sum but also average and count. That would make me use 3 aggregators, right?
I finally got to make what I was planning (I enclose pictures of both aggregator and set multiple variable module so anyone can give me tips on this)
tysm!
1 Like
the thing i just don’t get is the reason why i had to use the indices from the array aggregator input
instead of the output values for the set variables module to work
Yeah the formula requires that you use the raw name of the variables, where the other screenshot you have shows the labels of the variables.
It just seemed a bit off for me haha thank you for the clarification!
