Discussions

Expand all | Collapse all

Time Stamp for Start of New Entry

  • 1.  Time Stamp for Start of New Entry

    Posted 14 days ago
    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 the duration of time it took to fill out the form. 

    The couple things I have tried is not calculating correctly. 
    Formula triggering a change in a field to provide  a time stamp
    Letting the person filling out the form trigger it by filling the form out and the trigger dependant on the change in field. 
    Both of these did not end up working as the time stamps continue to only update a few seconds before the submit button. 
    I tested it by submitting an entry 30 min after opening the form. 

    Any help is greatly appreciated!

    Thanky ou

    ------------------------------
    Amber Anderson
    ------------------------------


  • 2.  RE: Time Stamp for Start of New Entry

    Posted 14 days ago
    np
    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
    ------------------------------



  • 3.  RE: Time Stamp for Start of New Entry

    Posted 14 days ago
    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
    ------------------------------



  • 4.  RE: Time Stamp for Start of New Entry

    Posted 14 days ago
    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
    ------------------------------



  • 5.  RE: Time Stamp for Start of New Entry

    Posted 13 days ago
    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
    Mark Shnier (YQC),  06-29-2020 18:30


    ------------------------------
    Amber Anderson
    ------------------------------