Time Stamp for Start of New Entry

Question

Hi All,&nbsp;I am trying to figure out if it is possible to create a time stamp for when a New Form is Started.&nbsp;The Created Date provides me when the form was completed. What I am trying to get is the duration of time it took to fill out the form.&nbsp;The couple things I have tried is not calculating correctly.&nbsp;Formula triggering a change in a field to provide&nbsp; a time stampLetting the person filling out the form trigger it by filling the form out and the trigger dependant on the change in field.&nbsp;Both of these did not end up working as the time stamps continue to only update a few seconds before the submit button.&nbsp;I tested it by submitting an entry 30 min after opening the form.&nbsp;Any help is greatly appreciated!Thanky ou------------------------------Amber Anderson------------------------------

amberanderson · Answer

FANTASTIC! This seems to have done the trick! Thank you so&nbsp; much for your help!

make a new formula date / time field called [Current Date / Time] with a formula ofnow()Uncheck the setting on the [Date /Time form started] so that it is required but not unique and not defaulted to now.make a form ruleWhen [Date / Time form started] is blankchange [Date / time form started' to the value on the field [current date/ time]uncheck to fire all the time
Mark Shnier (YQC),&nbsp;&nbsp;06-29-2020 18:30
------------------------------Amber Anderson------------------------------

markshnier__you · Answer

npmake a new field [Form Start Date / Time]set the default to now.In Form Properties make it Read Only so no one changes it.

Date / Time  Change Type

Required
Must be filled in

Unique

Must be unique

Default value
Now

Sample Data

------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

amberanderson · Answer

Thank you so much Mark -&nbsp;I set this up using the Date/Time Field&nbsp; and set the Must be filled in, Unique and Now.&nbsp;What is happening is the date and time is reflecting the created date identically vs when the form was opened.&nbsp;------------------------------Amber Anderson------------------------------

markshnier__you · Answer

OK, yes, I just did a test and was quite surprised that it changed the value of that field during the saving process. I'm sure it is a feature and not a bug. :)

So np, try Plan B.

make a new formula date / time field called [Current Date / Time] with a formula of
now()

Uncheck the setting on the [Date /Time form started] so that it is required but not unique and not defaulted to now.

make a form rule

When [Date / Time form started] is blank

change [Date / time form started' to the value on the field [current date/ time]

uncheck to fire all the time

If that does not work, I have Plan C, but it does seem to work for me.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Time Stamp for Start of New Entry

Related Content

Extract Date and Comment from prepend log entry field

Pipeline Not Starting

Start Audit Date

Filter Table Entries In Another Table

[Snippet] How we Stop Backdating Entries from user

Date / Time Change Type
Required	Must be filled in
Unique	Must be unique
Default value	Now