Time Stamp for Start of New Entry
Hi All, I am trying to figure out if it is possible to create a time stamp for when a New Form is Started. The Created Date provides me when the form was completed. What I am trying to get is th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
make a new field [Form Start Date / Time]
set the default to now.
In Form Properties make it Read Only so no one changes it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
make 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thank you so much Mark -
I set this up using the Date/Time Field and set the Must be filled in, Unique and Now.
What is happening is the date and time is reflecting the created date identically vs when the form was opened.
------------------------------
Amber Anderson
------------------------------- MarkShnier__YouOK, 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
------------------------------- FANTASTIC! This seems to have done the trick! Thank you so much for your help!
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
------------------------------
Amber Anderson
------------------------------
