Date stamp formula for checkbox

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
Hello.

I have a quick question regarding date stamps.

I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these boxes.

We have a few older records to see when they were imported and exported. When they built this application, they did not anticipate the importance of these check-boxes.

Is this at all possible? 

Thank you very much for all of your help!
Photo of Neve

Neve

  • 260 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
if the data entry is being dome via the form and never by grid edit, then you can create two fields to hold the date the checkboxes were checked.

Use a form rule such as

CONDITIONS:
when multiple conditions are true.
checkbox 1 is checked
date checkbox 1 checked is blank.

ACTION

change date checkbox 1 checked to the current date.

Be sure to uncheck the box at the bottom of the form rule so it fires all the time.

You will need to have two Form rules, one for each checkbox.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Another option if you aren't going to be editing individual records on the form, is to make a formula-url field that performs an API_EditRecord function to check the box, timestamp, and even add who clicked it (if desired).

These buttons can be used in reports, or on the form.
Photo of Robert Kreibich

Robert Kreibich

  • 162 Points 100 badge 2x thumb
 Simple and very useful.  Do you have an example on this?