I’m using Airtable as a CRM and to build orders with line items. I’m trying to create a flow to generate a worksheet/order form to submit.
When I run this scenario it’s creating two different worksheets rather than adding 2 rows to the same worksheet.
Step 1 - gets the line items in separate bundles
Step 2 - gets my order data
Steps 3-5 building the worksheet and then adding rows.
Welcome to the Make community!
Your repeater is NOT creating the spreadsheet twice.
The Two bundles coming from the search module is running the Create Spreadsheet once each.
Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, 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 has applies to many use-cases.
You can either move your Sheets module to the second position, OR use an aggregator module after the Search module.
