Status time stamp and duration calculation

[Ala_Hejazi]

Hello everyone,
In my database I have status (of ENUM type). I update it manually as processing goes on. My question is how can I add an automatic time stamp for each status to calculate the duration of that step and at the end to calculate the accumulated duration for all steps.
many thanks

[Aleksi]

Add as many ChangeTimestamp fields as you have status values. Then you can read each durations separately. Please check this article…

help.appsheet.com

Tracking Changes Using "Change" Column Types

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

[Ala_Hejazi]

Thank you so much Aleksi. Very helpful

[Aleksi]

You’re welcome