You could easily process the 10 documents and write to Airtable, and then after that generate the invoices all within the same scenario.
One way to do that is to make use of Aggregators.
Combining Bundles Using Aggregators
Every result/item from some module types (like Trigger / Iterator / List / Search / Match modules) can potentially and likely output more than one bundle. These multiple bundles will individually run subsequent modules once per bundle, which is not optimal in most cases:
- one operation per bundle per module, which could lead to…
- use of multiple credits per bundle per module (some modules use more than one credit)
View example screenshots
Aggregator Example
The “Search Rows” module runs one time, returning 999 results (999 bundles).
Without Aggregator: the tools module run 999 times (999 operations)
(and if there are more modules, they run 999 times each)With Aggregator: the tools module only runs 1 time (1 operation)
 |
Warning: |  |
|---|---|---|
| This can easily use your entire quota of credits if you are not careful or fail to understand this concept. |
To “combine” multiple bundles into a single variable, so that you can process all of the items in a single operation, you’ll need to use an aggregator. Aggregators is a type of module that accumulates bundles and outputs one bundle (unless you are using “Group By”). An example of a commonly-used aggregator module is the Array aggregator module.
You can find out more about some other aggregator modules here:
- Array aggregator
- Numeric, Table, Text aggregators
- JSON aggregator
- CSV aggregator
- Archive (.zip) aggregator
- other app-specific aggregators
Question: Which is the best aggregator do you think you’ll need for your use-case?
Example
Here is an example of how your scenario could look like:
This is just an example. Your solution may or may not look like this depending on requirements and actual data.
I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then.
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 —
Learn Make
- Help Centre | Tutorials – Make’s “manual” - search for help here first
- Make Academy – Basics 101: Learn Make properly to get your money’s worth
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
How-Tos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Aggregate an array for mapping complex fields
- Getting started with OpenAI - How to setup and use OpenAI in Make
- Text Parser module - Use pattern matching to extract the text you want
- Webhooks – Make Academy - tutorial on how to use Webhooks
Useful to Know
How to schedule scenario for first Monday next month (recurring)- How to schedule scenario for the last day next month (recurring)
- How to Extract URL Query Parameters Into Variables
- Overview of Different Web Scraping Techniques in Make
- [Free] Use Groq AI to filter spam emails and form submissions!
Automate Follow-Up of Email Leads a Week After- How to group bundles in X amount of bundles (Chunking Arrays)
My Custom App — Absolutely Free!
Save development time and operation credits with these utility modules: Chunk Text; Chunk Array; Chunk Words; Multiple Find & Replace; Collection to Array/String List; Execute JavaScript; Estimate Tokens; Calculate Difference Between Two Dates; Get Next Business Day (with holidays); List Upcoming Dates of Day of Week; and more!
— @samliew