Facing issues with Text Aggregator

How To
1

Hi Team,

image
image1920×1080 250 KB

Please check the attached scenario, I want to share the consolidated list with the Gmail Module, but on Text aggregator runs multiple times, could you please help with this.

Regards
Geetha Reddy

2

Hey Geetha,

you should always aggregate the module producing the extra bundles, in your case thats the iterator, not the Add a Row module.

3

Hi Stoyan,

Please check the attached screenshot, even I tried this but Array Aggegator runs in multiple times.

I want to send a consolidated list tthe o Gmail module.

image
image1920×1080 251 KB

Regards
Geetha Reddy

4

Again, same issue, you are aggregating the wrong module. The tools module is producing the same amount of bundles it is receiving. Change the setting on the aggregator module.

5

PFA.

image
image717×800 53.6 KB

Do u want me to map with iterator.

Regards
Geetha Reddy

6

Change the source module on top to the one generating the extra bundles.

7

Hi Stoyan,

image
image1920×1080 250 KB

image
image1920×1080 313 KB

Please check the screen shot and let me know.

Regards
Geetha Reddy

8

Welcome to the Make community!

Setting the Correct Aggregator Source

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.

867×340 53.2 KB

For more information, please refer to the Make Academy.

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:

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.

9

Hi Samliew,

I tried your suggestion, but still, Array Aggregator runs multiple times and fetches 2 different output bundles
PFA

image
image1599×618 43.2 KB

Regards
Geetha Reddy

10

Its the Watch New Rows module that is returning 2 rows here. Not sure what you are iterating after but you can see it runs twice, so does the tools module and so does the aggregator. Click on the number in the bubble next to the module to see how many input bundles you are getting vs how many output. If they match, then thats not the module you should be aggregating.

1 Like
11

Hi Stoyan,

Have tried your suggestion, PFA.

image
image1290×459 31.2 KB

Gmail Module is fetching the first row of the sheet, could u please help me share a consolidated list with Gmail Module.

Have attached Gmail Mapping and HTML format.

image
image1920×1080 385 KB

HTML Format for Module:

Hi,

Please check the CV feedback pending list below:

<tbody>
S.No Date Of Sourcing Account Skill Source Candidate Name Contact Number Email ID Status
{{20.array[].`0`}} {{20.array[].`1`}} {{20.array[].`2`}} {{20.array[].`3`}} {{20.array[].`4`}} {{20.array[].`5`}} {{20.array[].`6`}} {{20.array[].`7`}} {{20.array[].`13`}}

Regards,
Geetha Reddy

Regards
Geetha Reddy

12

Hey Geetha,

First - Watch New Row module will only return any new rows since it last checked. Do you need a one time run with all the rows in the sheet? You can use Search Rows instead.

Second - you are mapping only the first item of the array. Do you need all of them in a certain structure? You can swap the Aggregator module for a Text Aggregator and buildout your text string there, then map that in the Mail module.

13

Hi Stoyan,

Let me explain my requirement: I maintain a master tracker with a list of candidates. I want to fetch the rows where feedback is pending from the client and send a consolidated email to the client on alternate days or weekly.

In the earlier scenario, the system fetched details for a single candidate and sent an email for each row. However, I want to send a consolidated list of candidates instead, so I need your guidelines here.

Regards,
Geetha Reddy

14

Hi Stoyan,

Thanks for your Support, Im able to share a consolidated list to the Gmail Module.

Regards
Geetha Reddy