Creating new records from list values

[joefarrowsmith]

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.

[Eugene_West]

There is no way to split if you want keep order details in your DB and display like 2nd screenshot.
Instead of Orders use Product.
So when user select “Product” and go to the invoice page or element it’s create “Order details”
Order detail’s DB structure:
Name: Product - Type: Product
Qty - number
Price - number

In Total you just sum prices and display

[joefarrowsmith]

Thank you for replying to my question. I do appreciate it.
Just to clarify then, are you saying that I create the Order Detail record each time a user adds a product to an order? That makes sense if so or have I misunderstood?
Thank you again for your time. It’s really very kind of you.