Error with add a new row to another table using values from this row

[PeakPerformance]

Has anyone else experienced this? I have a user-friendly google sheet where customers can input a complex order, this generates a readable sheet for Appsheet to copy from. However, when setting up the action to Copy the order details, it won’t let me enter data into any column that relates to the table key, which in my case, is Order ID. See the error below…

Here is a screenshot of the ORDERS table where you can see that the column is marked Editable. Any ideas of what is going wrong here?

It is important that I don’t use a system generated key like UNIQUEID() because the app also adds line items to the line item table and creates a reference to ORDERS using that Order ID column.

Is this a bug or am I completely misunderstanding how this action should work?

[Steve]

For reasons that aren’t clear to me, the Data: add a new row to another table using values from this row cannot be used to set the key column value of the added row; the key column value must be set by its own initial value expression. Further, the key column’s initial value expression does not have access to any of the values set by the action.

[PeakPerformance]

Thanks for the clarification, that is was I was afraid of. However I think I can work around it.

[Conor_Eurek]

I came here to report the same bug, thank you for this added clarification!