I have 2 SQL tables that work toghether as a bill. One has name of a person, date, and ItemID that links to other table, where it can be seen which items does he want to have or buy.
Tables look like this:
I want to insert the last added row in table1, but also all the items that belong to that row.
For example the complete row for the Xero bill should look something like this, for last row in table1:
All in one row and in arrays, so it can be imported to Xero bill.
Can this be done somehow through Zapier? I know it has a Format option, where you can get line items from array. But not sure how to do it from 2 tables like this.
Best answer by PaoloView original