We are trying to sync QuickBooks order header and details into two different tables but in one Zap. We would like to write the order’s header record to order_headers and then create the order line rows (1 or more) in a separate table (order_lines).
Is there a way to do both in the same Zap? Our existing Zap has a New Row action followed by a second. The first creates the header record in the intended table correctly but we haven’t yet figured out how to then write all of the associated lines to the second table.
Whether we do it in a single Zap or two different Zaps, we would need to way for the second action (for the lines table) to use the order number from the first to only retrieve the associated line records for each order.
Any thoughts on the best way to do this?