We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’
Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app.
Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [Order Id], Product = “Bananas”, Quantity = 5. Note that [Order Id] here is the value of the column OrderId in the Order row on which the action is being performed.
Use this action in the UI, or compose it with another action, or use it in a workflow rule when a new Order is created, etc.
Any columns not defined will get their initial values or app formulas. If a required column is not specified and does not have an initial value, you will be shown an error in the editor.