Getting datetime stamp for change for original status, and change in status

[edmund_chan]

Taking the Order Capture sample app as an example, I need to capture l

1. The datetime stamp when a new order is created (that will by default be an “open” status order”)
2. The datetime stamp when the same order is changed to “complete” status.

For 1. I can do it via with a column with the formula now(), but how do I get the datetime stamp when the status is changed, without overriding the original datetime stamp when the order was at “open” status?

Looking forward to any help I can get from this community

[Marc_Dillon]

You can try a “ChangeTimestamp” type column, and in the column details you can tell it which columns to watch for change.

Or you could utilize a Reset On Edit expression.

help.appsheet.com

Tracking Changes Using "Change" Column Types

How to keep track of when and where data is changed in your app.

[edmund_chan]

It works. Thank you so much Need to remind myself that we need not use double quotes to specify the values.