Hi Team,
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
Hi Team,
Regards
Geetha Reddy
Hey Geetha,
you should always aggregate the module producing the extra bundles, in your case thats the iterator, not the Add a Row module.
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.
Regards
Geetha Reddy
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.
Change the source module on top to the one generating the extra bundles.
Welcome to the Make community!
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.
For more information, please refer to the Make Academy.
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:
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,
I tried your suggestion, but still, Array Aggregator runs multiple times and fetches 2 different output bundles
PFA
Regards
Geetha Reddy
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.
Hi Stoyan,
Have tried your suggestion, PFA.
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.
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
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.
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
Hi Stoyan,
Thanks for your Support, Im able to share a consolidated list to the Gmail Module.
Regards
Geetha Reddy