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

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โ€ฆ
2X_7_7574ed6c16ebad5db85b83910103b15bce8f63ff.png

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?

2X_8_82845b9ba98c884b1a096513f3c80ea7cff833c5.png

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?

0 3 423
3 REPLIES 3
Top Labels in this Space