Skip to main content
Question

Get Date/time

  • December 19, 2022
  • 0 replies
  • 147 views
Helloooo quickbase community!

I have a question, i need to create a field that saves the exact date and time when another chechkbox field is equal to true, I don't need a log I need to know some formula to do this.


Thanks again, you are very helpful.


Regards, 

Herberth Solano.

------------------------------
Herberth Solano
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    If you are editing on a form, then you can use a Dynamic Form Rule.  First make a Date/ Time field called like [Date / Time checkbox was checked].

    Then make a form rule,
    When Multiple conditions are true
    ALL of
    [Date / Time checkbox was checked] is blank (just leave blank)
    Checkbox field is checked 

    Action
    Change the value of [Date / Time checkbox was checked] to the current date/time.

    If it's possible that your users will be checking the checkbox in Grid Edit, hen you will need to set up a Pipeline to do that.  Post back if you need help with that.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement