How to generate a document showing a complex data
Hi, I am trying to automate generation of a delivery document. There is an order with an order id, each order can have multiple line items. Each line item can be fulfilled by one or more batches. So this is shown on a document as a table containing tables.
The data is not modelled as a single spreadsheet row, as you can imagine. The data is modelling as several (linked) worksheets in a spreadsheet, although I am also trying out Airtable.
Please can you let me know how best to do this!