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!
Solved! Go to Solution.
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().
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.
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.
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().
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!
User | Count |
---|---|
49 | |
18 | |
13 | |
12 | |
7 |