Solved: Can a row have two or more different timestamps? - Page 2

Nicolas_Feldman · 09-23-2020 08:13 AM

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!

Marc_Dillon

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

View solution in original post