I have a scenario which looks like the image below. As I’m sure you can tell, I’m doing the same thing three times, just with different sources of information.
Is there any way I can DRY (don’t repeat yourself) this up?
The results from the API calls are all going to be identical; they’re just from different projects, which I want to tally together in a single spreadsheet.
Thank you
Hello @Daniel_Hollands and welcome back!
Based on this image, you could try using an Iterator, followed by Everhour, followed by Iterator, Aggregator, Google Sheets bulk add rows.
Something like this:
In your Iterator, Iterate on an array of whatever is variable in your Everhour modules - like project numbers. Your iterator might look something like this:
The iterator aggregator combo would combine a bunch of rows before adding them to Google Sheets, saving your some ops/credits, if you’re already adding multiple rows per leg of the router.
Hope that makes sense and hope it helps!
Ah, yes, I think I understand what you’re suggesting. I’ll give that a try.
Also, solid tip on the Bulk Add Rows. That’s going to save so many credits and so much time!
Thank you.
