I’m trying to make a calendar availability checker on Make, and I’m using Google Calendar. I can get the busy Start and End times of each event. I then used an iterator to create a bundle for each event (in this case, 2 bundles), then I used an IF function inside the Tools module to determine if the date and time I want is available, based on the busy dates and times. The output I get then comes as two operations (as you can see, Operation 1 is Yes and Operation 2 is No). The problem is if one of the availability is a No, the whole thing should output as a No, since this means that the date and time I want is not available. So, how can I merge the 2 operations to get an array of the availability, e.g. 1. Yes, 2. No? I’ve tried using an aggregator after the iterator, but then the IF function applies only to the first item in the array (the first busy event only).
For context, the date and time that I want to check for availability was set from September 30, 2025 12:30 PM to September 30, 2025 1:30 PM.
You can use filters before aggregator module to pass only yes or no or whatever based on your need. and choose source module from which you need to combine the data. as you move towards trigger module, more aggregation will be there.
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:
Thanks for the fast reply, but I didn’t understand your solution to my problem. I understood the filter part and I tried it, and yes, it does output the one I want only and removes the problem of having two operations to only one (in this example). However, the output will be used further in my automation, let me explain. If the “Availability” is Yes, then I only have to return “The slot is free!” to a Webhook response module; if it is No, then I have to return “The slot is not free” to that same Webhook. So if I use the filter and allow only Yes to pass, the flow will be cut off when it is a No, right? And if I try using a router and I have the situation where I have both Yes and No outputs, both routes of the router are validated, which does not solve the problem. Now that I think you understand what I want to do a bit more, could you please explain a bit more about your solution. Where should I use an aggregator, based on the screenshots I have provided, and what do you mean by “as you move towards trigger module, more aggregation will be there.”?
If you just want to send a response to webhook, you can use text aggregator. Cause you can use if function better in text aggregator than array aggregator. And to get want you want you can always filter out before aggregator part. So whatever you get in text aggregator you can send it to webhook response or API call.
Yes please help me with the IF function, cause I still dont know how to get a single output (either Yes or No, not both) from the IF function after the iterator. It would help a lot if you could explain it by annotating the screenshots I have provided, along with text explanation.
