In my App I have, among others, separate data types for Orders and OrderDetails.
My issue is that if, in the same order, Customer A orders
5 x Widget A at £5 each
8 x Widget B at £10 each
10 x Widget C @ £12 each
it’s stored like this in OrderDetails
But this limits me because it’s not a good way to display in an invoice and I can’t do anything with the lists in the Qty and Price fields. I’d rather have it displayed like this:
This means that I need to Schedule an API Workflow on a list so that Bubble creates a new OrderDetails record for each Product that has been bought against the OrderRef which will be repeated on each of those records.
I’ve been looking at how do a loop and I think I can work out how to do that but what kind of action do I have to perform to split out my lists like this?
If anyone can help, I’d be so grateful.