Hi, I'm struggling to create an invoice on Quickbooks from Airtable through Integromat. On Airtable I have 3 tables: Projects, Rooms and Items. A project has multiple rooms, and each room has multiple items(that is how they are linked as well). Now I want to create an invoice for all the items in a particular project(which I'm struggling with because Projects and Items are not directly linked).
Source: copied from https://www.facebook.com/groups/integromat/permalink/3973671082743495/
Hi, I'm struggling to create an invoice on Quickbooks from Airtable through Integromat. On Airtable I have 3 tables: Projects, Rooms and Items. A project has multiple rooms, and each room has multiple items(that is how they are linked as well). Now I want to create an invoice for all the items in a particular project(which I'm struggling with because Projects and Items are not directly linked).
Any suggestions on how I can achieve this?