I have a sample GS here.
I have a GS with multiple orders and each order has a different variety of items. An order might have 1 item or an order might have 200 items (rows).
I would like to figure out a way to print out each order on its own page and I'm wondering if there's a way to do this via formulas.
One example might be, I have 3 orders, each with 5-10 items so each order fits neatly on a page. I'd like to hit print once and have 3 pages print out, one for each order.
A more advanced example might be, I have 5 orders. 3 orders have few items so each order fits neatly on a page. But the other orders might have enough items to be multi-page orders. Again, I'd like to hit print once and have at least 5 pages print out.
Is there a way to do something like this? I started trying to do a query to count the number of lines each order has, and maybe do something with the Sequence function, but it quickly became out of my depths.
