Discussions

Expand all | Collapse all

Time stamp

  • 1.  Time stamp

    Posted 03-04-2020 14:17
    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
    ------------------------------


  • 2.  RE: Time stamp

    Posted 03-04-2020 14:22

    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
    ------------------------------