Hi all! Im trying something seemingly impossible. What i want to create seems very simple:
- a filter that only continues to the next module when the previous module has finished.
For example, i have a google sheet module that adds around 50 rows each run. After those rows are added i want to send out an email.
In my current flow the email gets send everytime a row gets added. So 50 rows means 50 emails. What i want is that the 50 rows in the google sheet module first fill up before sending just 1 email when its ready.
I tried to do this with a filter, but it does not work.
Ive tried 100 different ways and watched a 100 different videos but i cant seem to figure it out.
Hope there is a way to do this, it seems so simple.
Thank you!
If there is a way without filter that would also be ok for me. i just though a filter is the best way
Welcome to the Make community!
All you need is an aggregator with the Source Module set to the Iterator.
Combining Bundles Using Aggregators
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:
Mapping a Specific Structure 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” field in 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.
Example
Here is an example of how your scenario could look:
This is just an example. Your final solution may or may not look like this depending on your requirements.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hi Samliew,
Thank you for your help. So now i think i know how to do it, also with some research on the articles you linked. While it fills out the excel file all at once and also sending out one email, a new problem occurs;
The source module it gets the info from gives the info in 5 bundles with each 2 collections (organic results in the screenshot)
Both of these collections have info that i need to convert into the excel sheet. But what happens now is that the array aggregator only takes the url and title of the first collection it seems like, this is the only thing i can select:
Hope you have some insights on this as well! thank you again!
No problem, glad I could help!
“Looping” Through Array Items
When you see an ARRAY, think ITERATOR module. You need another Iterator for the organic results array.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
