Can a row have two or more different timestamps?

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 just [PickUpTime].

Any ideas on what could be wrong here?

Thanks!

timestamp
image
image

App Formulas will re-calculate upon every edit to the record.

I suggest you try moving your expressions to Initial Value field, and also adding in a ResetOnEdit expression.

3 Likes

Thanks @Marc_Dillon that would work for a dynamic field or column. Like “Last updated” or “last view”.

Im trying to generate actual records for different timestamps “timenow()”, at different moments via QuickEdit.
i.e. Pick up time, and Delivery time.

Each time one of the columns is updated it also updates the other one.

3 Likes

Another option which might make more sense would be instead of using quick-edit columns, create Action buttons for checking out and checking in. Each button can be a Grouped action to execute any number of sub-actions, like setting a column to TIMENOW().

5 Likes

Thank you so much @Marc_Dillon, will try both and update what worked best!

This turned out to be much easier to setup.

Another option which might make more sense would be instead of using quick-edit columns, create Action buttons for checking out and checking in. Each button can be a Grouped action to execute any number of sub-actions, like setting a column to TIMENOW().

Thanks for the tips @Marc_Dillon!
You are very kind!

1 Like