I have set up the email template for orders in an order capture app. It is the same as the “Order Capture” app by appsheet.
They both seem to have the same problem. When an order is entered an email is sent when a row is added to the order table but the child order details haven’t yet saved to the order details table so the details part of the email is blank.
It works fine on “update” to orders table becasue the order details are already in the corresponding table.
Any ideas how to update the order row after everything have been entered so that the email sends with all the info in?