Calculate duration

I have a column called start that receives the value now() and another column called end also receives the value of now() , both are of type DateTime and another called duration that receives the expression [start]-[end] and shows me the duration. But in the end column, it records the same time as the initial value, how do I change that? I want when I finish my record, he will automatically take the end time and store it in the table

You need to add an Event action that is triggered when the form is saved. That action needs to write NOW() to your “End” column.


So you mean I would have to create an action that at the end of my check the end field is reset and receive the value of NOW()?

1 Like

Correct. Though you don’t need to have any initial value in that End column.