Calculate duration

[doubts]

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

[Aleksi]

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.

[doubts]

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()?

[Aleksi]

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

[Marc_Dillon]

Can a row have two or more different timestamps? Questions

Hello everyone! I was wondering if its possible to have two different timestamps on a row? I am trying to update [Pick up time] and [Drop off time] columns based on a Yes/No [PickUpComplete] and [DropOffComplete] Columns. So everytime the column [PickUpComplete] is set to yes [Pick up time] is updated. Im using this expression: IF([PickUp Completado]=“Yes”,timenow(),“00:00:00”) The problem Im having is that when set to “yes”, all timestamps from the row are being updated with now(), not ju…