Hey there yall,
So I am utilizing Google’s “Get Free/Busy Information” module in make vs. using Cal.com API calls for my calendar’s check availability scenario.
Having trouble with aggregating the data the google calendar free busy module is giving me though.
Module so far:
-
Developed an iterator module right after the google cal module (seen in screenshots below) to “iterate” the busy time ranges.
-
I then have a set variable module that is formatting these busy time frames into a one line text of a busy time frame from my calendar. (of course into the format I want), also seen in screenie below
Problem Currently:
- The set variable module is conducting three different operations, with three different results. (1 bundle with a separate formatted busy time frame for that day, in each bundle)
What I need:
- I need to make it so no matter how many busy time frames are produced, 0-10 or however busy time frames I have that day (if any), are formatted how I like them to be and then developed into a singular mappable list for future modules.
So for my example below I need to have a mappable module result that contains the busy data:
“August 12th 9:30 AM - 11:30 AM, 12:00 PM - 2:45 PM, 3:30 PM - 4:30 PM”
Steps I have taken:
- Set up an array aggregator (still gave me three different results instead of one mappable array/bundle.)
- Set up a text aggregator (still gave me three different results instead of one mappable array/bundle.)
**Do feel free to completely wipe out any modules I currently have set up after the google free busy module and run me through a new set to incorporate so I can achieve my result here. I am 100% doing something wrong and this has to be such a simple solution lol.
Maybe my brain is just WONKED on this Friday evening
Welcome to the Make community!
Looks like you need a Text Aggregator.
I would suggest completing the Make Academy before jumping into building a complete scenario. Iterators and Aggregators are covered in there.
Aggregators
Every result (item/record) from 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.
There are other types of aggregator modules, click the below links to find out more:
Array Aggregator – mapping multiple bundles into a complex field
The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.
This is done using the “Target structure type” of an Array Aggregator module.
Here is an example:
As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into.
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 —
Getting Started
Help Centre Basics
Articles & Videos
Partner & Custom Apps
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
3 Likes
Thanks Sam!
Id say im at the intermediate level of Make.com right about now so excuse my incompetence.
Your explanation helped me really understand aggregators just that much more so I can figure it out.
If anyone ever comes across this, simply I just had to have the iterator module as the source. Then choose the formatted time result in my aggregated field selection.
Thanks Sam!
1 Like