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 

    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