Can anyone nudge me in the right direction with creating new records via a back end workflow?
I have an Orders (tblOrders) data type linked to an OrderDetails (tblOrderDetails) data type.
Orders logs the store something is bought from and when plus customer who bought it and where it’s being shipped to. Each order has a field for UniqueOrderRef
OrderDetails shows details for each order such as what Products that order contains, quantities and prices etc. The Products, Quantities and Prices are recorded as a list in one field for each type. So it looks like this…
My issue that I need to display that data in a more user friendly way, more like this…
Following guidance on this very helpful forum earlier in the week, I created a new table (tblOrderDetailsDrillDown) to break down each Order Details record into separate products. To populate it, I’ve delved into back end workflows to Schedule an API Workflow on a List and I’ve had some success with this getting it to create a New Thing for each item in the list but I simply cannot get it to bring the Quantities into the new table…
If it helps, this is the design of my order screen…
I have two repeating groups that each displays a different type of product. A user then manually enters Qty and totals are calculated. They then hit Confirm and Pay and that is where the magic happens and workflows are triggered including a BackEnd Workflow that it is meant to create a new “DrillDownOrderDetailsRecord”…although it doesn’t quite…because I can’t get the Quantities to transfer. I think this is because they are stored in a Custom State attached to each repeating group and the CS is defined as a list of numbers. This seems to be kicking up issues.
Can anyone tell me how they would go about achieving this?
If you’ve read this far, thank you…I’d so appreciate any help…