I need to update a time field with the time an activity stops with the actual โnowโ time.
Either automatically when I save the record, or manually just before saving the record.
Any recommendations?
Solved! Go to Solution.
In the action configuration, you can set a condition for when it will take effect. Set that condition to the expression, ISBLANK([Stop time])
.
EASY!
Automatic upon Save would be slick, and Iโm pretty sure itโs doable but I would set up a โStopโ button for this. Youโll need two columns [Stop Now] and [End Time].
[Stop Now] will be a one option Data Validation column in your Spreadsheet, to make it a Button in your App, you must check โReject other valuesโ when setting up Data Validation in your Sheet.
Upon Regeneration of that Table in your App, this column will/should be set as an Enum column.
If this column isnโt automatically set to display as a Button, go in and change that so itโs a Button.
Set your [End Time] column as a Change Timestamp and add โEnd Timeโ (no quotes) as the trigger column.
Now, when you click the โStopโ button, it will add current Date/Time to [End Time]. You could set up both options and then track how much time they wasted between manually clicking Stop button and actually Saving the recordโฆHAHA, thatโs the long-time Service business owner coming out of me!
@Rick_Haden Another option, assuming you already have a column to record the time, create an action that updates that field and set the action to โDo Not Display.โ
In the UX editor, set the โEvent Actionsโ , Form Saved to trigger that action. This will update the time when the form is saved.
@Rick_Haden Did you make this work?
@Michaelโs suggestion is the right one.
In the action configuration, you can set a condition for when it will take effect. Set that condition to the expression, ISBLANK([Stop time])
.
Beautiful - that worked @Steve . Itโs super helpful to be able to get tips/answers like this, as it sets me on a path of knowing better where to look for answers. So big thanks!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |