Does NOW() capture the timestamp the record was started or the timestamp when Save is pressed?

[Daisy_Ramirez]

We have users that may stay on an entry form for sometime and looking for clarity on the time being captured in the database.

Thanks

[1minManager]

Its the time on their phone

[Daisy_Ramirez]

Thanks so much but the device time when they start the record or when they press save?

[Tommy62]

Bei mir wenn die Aufnahme gestartet wird.

[Suvrutt_Gurjar]

I believe the time stamp is captured when the form is opened by the user- with NOW() being in initial value or being in app formula of the timestamp field.

You can easily test it with a test field.

Also as @1minManager guided, it will be device time of the user.

[Daisy_Ramirez]

Thanks so much!

[MultiTech]

The timestamp captures when the form is opened.

If you want to capture the timestamp of when the form was saved... a few ways you could do this:

• Use an action in the form save event to write a timestamp
• Set your form to "auto save", put an enum as the last field in the form (where it only has one value "Save"), and tie a ChangeTimestamp column to watch that enum.  
     - The idea being: they hit your enum  to save the form (instead of the system save button) , which you can then use to do other things. 

-------------------------------------------------------------------------------------------------------------

One of the columns in the creation metadata section of the Standard Starting Template captures the last edit made in the form; this way I can get:

• When the form was started
• When the form was saved
• And how long it took the user to enter the data into the form.  (This is a KPI that business type people will want to see; it shows the "efficiency" of the system.)

------------------------------------------------------------------------------------------------------------

To capture the timestamp of the last edit made inside the form:

• Initial Value = NOW()
• Reset on edit = context("ViewType") = "Form"

[Daisy_Ramirez]

Nice! Thanks MultiTech