Pulling data from each element in an array

How To
1

Hi,

We’re working on an Airtable invoicing system. Each invoice is a record in the Invoices table, and each Invoice is made up of Activities (which live in their own table). The invoice links to a group of activities, each having a date, amount, etc.

The goal is to get all the data over to a document generator (Doucmentero in this case).

No problems getting the activities over to the document–it’s getting the information about those activities that’s getting us stuck.

We have a webhook bring the invoice into Make and then we get stuck. Do we iterate through each activity on the invoice and then through each activity? Multiple interator/aggregator setups?

TIA!

2

Hello! Welcome to the Make Community!!

Can you please give more details about what you want to achieve? Your webhook receives information about a new invoice and activities, and you want to insert all in Airtable? Or you want to extract all Invoices and their activities from Airtable and push them in a document for Documentero?

Or anything else?

I would love to help you, but I need more info to understand better :slightly_smiling_face:

Benjamin