I'm creating a zap from my Knack database. My Knack database has a form to enter new dispatched loads for my driver's. Each record has driver pay info. My drivers are Vendors in QuickBooks Online and get paid at the end of the week for all loads done that week.

So I wanted to create a zap that looks for all records that were added in the week for each driver, and then create a single Bill for each driver (Vendor). Each drivers bill would have multiple line items (each line item is a load pay record from Knack.)

So the in QuickBooks I would have 1 bill for Driver A. Line item 1: Load #1234, $100. Line item 2: Load #6789, $500, etc etc. And the final bill total would be the total amount I need to pay him for the loads he did that week.

I'm stuck on making that zap happen. How do I get multiple database records that don't have any connection to each other combine onto a single Bill as multiple line items? Help!! Thanks