Splitting Airtable Records into Line Items for a New Invoice on FreeAgent

So, my goal is to create a new invoice on FreeAgent (accountancy software) when record enters a view in Airtable.
I have managed all the single item fields like Client, Project, Value etc but it’s the line items I’m struggling with. If there is more than one line item, I am struggling to split the record out and extract the values of the item and amount. I also don’t know how many items there might be. I get confused a bit with Make’s iterator, but I feel like it’s something like that!
The line item is expecting at least two values - item name and price.
thanks in advance!

Welcome to the Make community!

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? 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.

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. And most importantly, Input/Output bundles

Please provide the input and 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”.

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.

Following these steps will allow others to assist you here. Thanks!

Join the Make Fans Discord server to chat with other makers!

1 Like