A formula checkbox to let me know if a record has NOT been edited for over 1 hour and then reset when it has been updated.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Basically we have a ticketing system that we need to have a way to let us know when a ticket has not been edited after 1 hour. After the 1 hour mark and if the record has not been updated, I will set an email alert to shoot us an email. IF the record has been updated within the hour then reset the time.

Thanks in advance!
Photo of Rodman91


  • 132 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points

If(([Date Modified]+Hours(1))<Now(),"True","False")

Thats references the standard date modified field in a quickbase table, if you have renamed the field then please update the field name in the formula.

This shows where records have gone over 1 hour based on the time now, when you update the record and save it the date modified field automatically updates (so will reset it).

Note if your looking at a report for a while you will need to refresh it for the calculation to rerun and pull the new time (which will then trigger the checkbox if its gone over).
Jack is correct in implying that QuickBase cannot natively send a email mid day on an automated basis. But if it's useful, I do have some code which I could post which you can put in a dashboard page to have it refresh in a timer.  You can then say wall mount a screen and have it refresh on a timer, like every 5 minutes.