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?