LinkedIn
Twitter
This is awesome. Thank you @GreenFlux
#Sync
As I see, this is working only when Delayed sync is off. So after each ADD / EDIT, there will be a Sync.
This is necessary, because you’re working with a Workflow.
In fact Delayed sync is what I would prefer. Because User go crazy when there is a sync after every ADD / EDIT. But there is a workaround:
Enable Delayed sync & Automatic updates, and put a forced sync only where it is needed.
So in your case:
Change the Action “OrderTrigger CreateLineItems” to a grouped Action with:
“OrderTrigger CreateLineItems” + “Sync”.
The App Link for “Sync” would be: LINKTOROW([Key], "Order_Detail")&"&at="&(NOW()+1)
With this there will be a Sync only after Adding / Editing an Order.
In my sample this Sync is not needed.
But the advantage of your App is, that you can add as many Children as you like. You don’t have to care about “how many Actions do I have to create?” → Very good solution!
#Quantity
You can add Action “Plus” and “Minus” to the Inline View. Even the “Delete” Action. You can set the column Line Item[Key] to Show?=FALSE. Then attach those Actions to column [Key].
#Master Line Items
To get this done simply change the Order[Products] EnumList to Base type “Ref” and the Referenced table name to “Product”.
With this you will be able to add new Products via the EnumList.
Then change the Action “OrdersCreateLineItems” not to Reference on Table “Line Items” but on Table “Product”. And change the Action “CopyMasterLineItem” not to be for Table “Line Items” but for Table “Product”.
With this, you don’t need the “Master-Products” in you Table “Line Items”.
The Expression for [Order] would be:
ANY(FILTER("Order",CONTAINS([Trigger],"CreateLineItems")))
Hi @Bahbus Yes, this is the part that forces a snyc.
Please don’t ask me why 
I learned it once here in the Community.
You are right, but it says
CONCATENATE("MyApp-123#at=", ENCODEURL(NOW()))
without the +1 at the end.
In my Apps it’s only working when I add the +1 at the end. 
Many thanks @GreenFlux the solution works well without the need to mimic ‘loops’. Does it also update the order-items if the order is amended and fewer products are chosen? I.e. so the Line item table would need to have Products removed, which were are no longer part of the order.
I have tried some examples using the sample app and from I can tell it doesn’t appear to remove ‘old’ unwanted products.
Thoughts?
@GreenFlux @Fabian thanks for this work! 
Just one question, @Fabian : what is triggering the “OrderTrigger CreateLineItems + Sync” action?
It is not the workflow “OrderAddLineItems”. Thanks again!
Yup! This is the only problem with this set up. In my case, I just turned on the background sync 
Hi @GreenFlux,
Thanks for your response. Which is the action that populates the Customer column in the Order table with the correct ID? For some reason it stopped populating in my table and I’m trying to fix it. From the front end this means that when a user selects items from the EnumList they are not saved to the “customer” they correspond to. Thanks again
The Customer is directly filled in by the user. There is no action involved in setting the Customer.
I just checked the sample app and it is working normally. Perhaps you’ve changed something with the Order[Customer] Ref-column, or the Customer table.
Try comparing your current settings with the sample to see what changed.
You can use the SELECT ALL button at the bottom of the EnumList dropdown. This will work without needing to edit the app any further.
Or you could add a New Action to:
Perform an action on a set of rows, and select an action that will:
–Add a row to another table using values from this row (from Products to LineItems)
Set the filter to select all the products you want to add. If you want all products, then enter Product[Key].
