Using formula field to delay notification

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
 I need for a notification to be sent after 60 minutes. I have setup the appropriate formula field, but the issue I am having is that even though the new formula duration field functions properly, the notification is not being fired because a new "save" hasn't occurred to the record (which typically triggers the notification). Is there a way to get around this and somehow base it on a date/time field?  I understand this is not currently a feature for QB, yet I've seen some conversations that appear to have workarounds - just am having issues implementing the same.  Is there anyone out there that could assist?
Photo of Pro Survey Solutions

Posted 1 year ago

  • 0
  • 1
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
The way our developer would probably handle this would be to have a php script running under cron on a Linux server. It would run, say, every 15 minutes and look for any records in your table that have a date-time value in your formula field on or before the current time that hadn't been processed yet. And you'd need another date-time field that the script would update for [Notification Sent]. Then, set up a notification rule that would fire whenever this Notification Sent field had been updated.

I wish we could do cron-like event handling in QB natively, but alas....