darren
March 9, 2022, 2:52pm
#1
Still trying to get comfortable in Integromat and struggle with what modules to use for this…
I have data that is basically this:
[
{
"location": "A",
"hours": 4,
"wages": 40
},
{
"location": "A",
"hours": 1,
"wages": 10
},
{
"location": "B",
"hours": 2,
"wages": 20
},
{
"location": "B",
"hours": 3,
"wages": 30
}
]
How can I get the sum of hours
and the sum of wages
grouped by location
in integromat so that I can add a row for each location in a Google Sheet?
I think what you probably want is an Iterator module after the Parse JSON module.
Sorry for asking this if it’s an obvious answer but is there a reason you can’t do the sums in Glide or a formula in the target google sheet?
darren
March 9, 2022, 3:44pm
#4
Row count!
We don’t need to know the individual payments, just the sum. If we stored all the rows it could be 100s added every day. If we sum before writing to the sheet, it’s only 7 rows.
darren
March 9, 2022, 5:36pm
#6
Finally got it! And I think I understand it
3 Likes
darren
closed
March 10, 2022, 5:37pm
#7
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.