Hi everyone. I have a simple scenario that has a starting point of a Google sheet with donations made to our organization and an ending point that creates a Google doc. The text aggregator is gather up all of the individual donations for a given email and then each donation is written to Google doc.
Everything is working as I want it to, but would like to get a count of the bundles for a given operation coming out of the iterator module and then use the count in the Google docs module to do some conditional formatting of the text.
As this screenshot shows, the first operation (highlighted) has two bundles, the second, one bundle and the last, six bundles. Some donors have donated more than once and we want to recognize those that have donated multiple times in the Google doc and each bundle represents a donation e.g. six bundles means six donations were made.
How can I get the count of the number of bundles for each operation and use it in the Google docs module?
I did search the community forum, but did not find any postings about how to count the number of bundles in a given operation.
Thanks for your help
David Garrison
How are you aggregating, and what are you iterating?
To allow others to assist you with your scenario, please provide the following:
Relevant Screenshots
Please share screenshots of your scenario, any error messages, relevant module fields, and relevant filter settings. It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
Scenario Blueprint
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Output Bundles of Modules
Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
A. Upload as Text File
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
B. Insert as Formatted Code Block
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:
-
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
```
content goes here
```
-
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
By providing these details, it will allow others to assist you better.
Hi @David_Garrison, If I remember correctly from your other post, each donation is separated by a line. We can use split() function on the generated aggregated text like this split(text;newline) and then use length() function to count the lines like this length(split(text;newline)). text is from text aggregate and newline is a native Make function.
Mention me if you have more questions.
Hi @David_Garrison,
You could insert an intermediate step where you save the iterated data in a Google Sheet or in Airtable and that should give you the number of bundles (or rows).
Regards,
Pam.
Thanks kudracha. I’ll have to give your suggestion some thought.
However, I noticed that in the iterator output, there is a field called Total number of bundles and it turns out that it matches the number of rows for a given email on the Google sheet (see screenshot). I put a module after the iterator, but I can’t find a way to map from the output to the new module. I can map the fields from the sheet, but can’t find a way to map the Make generated fields e.g. Total number of bundles and Bundle order position.
Do you know if there’s a way to map the Make generated fields?
The other challenge will be that the Total number of bundles is the same for each output e.g. the first output of the first operation has a value of 2 and the second output also has the value of 2 and the same goes for the rest of the operations.
It seems like I’m getting really close, but not sure how wide the chasm is from where I am now to where I want to be…
Thanks for your help
David Garrison
Thanks @siliceous.solutions. Interesting idea and that may also help with another challenge which is totaling up all the donations from the Google sheet for a given email address and then outputting the total beneath list of individual donations for that email address, like this:
11/14/2024: $220.00
11/15/2024: $101.00
Total Donations: $321.00
I tried using a numeric aggregator with sum function, but it was adding up all the donations for all the donors instead of just the donations for a given donor address. So it would show something like this:
11/14/2024: $220.00
11/15/2024: $101.00
Total Donations: $87,362.25
I’m new to Make and one thing I find challenging is how not to lose access from module 1 to module 2 when I add a module in between like a text or numeric aggregator.
What I mean is that if module 1 outputs first name, last name, email and donation amount, I can, of course, map those in module 2. However, if I insert a numeric aggregator module between module 1 and module 2, I lose access to the output from module 1 in (now) module 3 and can only see the output from module 2 (the numeric aggregator).
I’m sure there’s a way to not lose access, but it’s not obvious to me at this point in my Make journey.
Thanks for your help
David Garrison
Hi @David_Garrison,
You’re right in saying that my suggestion should solve the challenge you’re facing of totalling up the donations, and also any issues you may be encountering with the aggregator modules.
We use Airtable a lot (if not for all) for our operations which acts as a database as the source of truth, along with many other amazing features.
Regards,
Pam.
@David_Garrison, Kind of hard to answer when there’s so many variables. Let’s solve problems one by one…
(1) One solution to getting access to whatever’s hiding behind aggregation is to ‘set variable’ and then ‘get variable’. This will consume 2 operations more per document. Very easy to implement. The solution I told you about (aggregator) needs to fiddle with Make formulas, but doesn’t consume additional operations.
In google docs module you have :
hello text
{{text from aggregator}}
bye text
and in text aggregator it’s like this :
11/14/2024: $220.00
11/15/2024: $101.00
Total Donations: $321.00
Before the end of the mail, you can write :
‘You donated length(split({{aggregator text}};newline;))-2 times this year ! we appreciate etc. etc.’
(2)
This problem is due to not choosing ‘Source’ parameter of the aggregator correctly. Need more screenshots to solve this.
(3)* I don’t really see why you have Aggregator, then iterator and then aggregator again. your aggregator and iterator seem like extra steps. it should be directly googlesheet → text aggregator for this case.
