Hello! I am very new to make.com and attempting to build my first scenario. I’ve done a bunch of reading, asked chatGPT, and tried to work on this for the last 3 days and near my limit of 10k operations (yes I burned through so much ) I’m finally waving the white flag. Here’s what I want it to do:
capture client ID from a Google Sheet (connection works just fine!)
connect to an app’s API and GET client data based the client ID (able to connect and capture the data just fine!)
The data is heavily nested, so I am using an Iterate module to help, ultimately need to capture timesheet entries - the start time (which captures the date, needed for the filter in step 4), and the duration (in seconds). (it…. works, maybe?)
I have a filter to return the timesheets created for this month only. (filtering works fine)
I have a set variable module to convert the seconds to minutes, and also round up to the nearest 15 minute increment. (I am able to create this, and it works)
I’d like to aggregate (sum) up the rounded time values, do one more conversion to hours for easy reading (haven’t gotten this far)
I’d like to email my client so they know how many hours of work has been completed
I think I am close, but there seems to be an issue with trying to aggregate this all together. Based on what I’ve read it may be due to the nesting of collections. here are some screenshots:
Set Variable Function to normalize to minutes instead of seconds and round up 15 minutes. It breaks it out to multiple operations. 1 timesheet per operation
Array Aggregator settings and output. results are not what I’m expecting. Also when I attempted a sum up the rounded values, it maintained multiple operations, 1 timesheet per operation.
Always set the Source module of the aggregator to be the module that produces 1 operation for each input bundle. In your case, it’s the iterator. That way, all operations become only one after the aggregator, with the output being an array.
You need to set the “Source Module” field of the aggregator to where the bundles are coming from. This is usually an iterator module, but can also be a search/list/repeater module, or even the trigger module!
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
@samliew and @damato Thank you! Your info was helpful to learn how the source module actually work. I took that learning to figure out that I needed to use the numeric aggregator module.
No problem, glad I could help with "Heavily Nested collections - Help with iterator and array aggregator"!
I’d recommend going through the Make Academy if you haven’t yet!
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
3. Have a different/follow-up question? Start a new topic.
Creating a new topic for each question makes it easier for others with the same problem to search for answers. You are also more likely to receive help sooner as new topics are displayed first on the forum’s “new” page!
I hope this information assists you. Let me know if there are any further questions or issues.
) I’m finally waving the white flag. Here’s what I want it to do:
Here’s a magic link to a list of your other “unsolved” topics: 