How to Combine Multiple Airtable Records into One Google Doc in Make?

How To
, , , , ,
1

I’m working on a Make scenario triggered by a Tally form submission. The form includes individual checkbox selections, I want to generate a single Google Doc that compiles the relevant instruction text for each checkbox selection.

Here’s how it’s set up:

  • I have two Airtable bases:

    1. Instruction Cache: Contains {Trigger Value} and {Instruction Text} for each possible checkbox selection.

    2. Generate Guides: Each Tally submission creates a record here with the list of selected features. includes link to generated docs, of which I’m currently getting multiple per form submission.

  • The scenario:

    1. Starts with a Tally submission.

    2. A “Set Variable” captures selected checkboxes.

    3. An Iterator runs over each selected feature.

    4. An Airtable Search Records module finds the matching {Instruction Text} in the Instruction Cache base.

    5. Set Variable

    6. Array Aggragator

    7. Text Aggregator combines all found instructions with line breaks.

    8. Google Doc is created from the aggregated text.

    9. Airtable create a Record

    10. Airtable Update a Record

Instead of getting one document per submission, I’m getting multiple documents, one for each instruction (checkbox selection).

I need a way to:

  • Collect all matched instruction texts across the iterations,

  • Aggregate them properly,

  • And create one single Google Doc per Tally submission.

Any help on where to place the aggregator or whether I need a code module to collect the instruction texts across bundles would be greatly appreciated.

Thanks!

1 Like
2

Heyy @elysian Welcome to the community!

Can you please share the screenshots of scenario, modules and outputs required to help you on this case? And what is your expected output need!

Best,
@Prem_Patel