Forum Discussion

TabathaGarrett's avatar
TabathaGarrett
Qrew Member
5 years ago

Time stamp

Is there a way to auto time stamp a check box? So I will know the exact date and time a user checks the box?

------------------------------
Tabatha Garrett
------------------------------

1 Reply

  • The most reliable way would be to use an Automation.  Create a field called [Current Date/Time] with a formula of 
    Now()

    Create another field called [Checkbox Date/Time]


    The set up an Automation to trigger when the checkbox field changes and the checkbox ends up being checked to edit the record to copy the [Current Date/Time] into the [Checkbox Date/Time] .

    You can also use a form rule, which is simpler, but if the form was sitting for a long time on the user's screen in edit mode, then the time stamp will be when the record was opened for edit and not when it  was saved.



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