Reminder to be sent within minutes
I would like to be able to send an email reminder within fifteen minutes of a due date. For example, if a user sets the due date for a task to be today at noon and the task is not yet complete I'd lik...
Forum Discussion
There is no mechanism within QuickBase itself that will periodically poll your tables and send an email as a due date/time approaches. Normally this type of functionality is implement using an external server where it can be "set and forget" using a service named a cron job. On the other hand an external service is probably going to cost you something and may add another point of failure to your overall workflow.
If you are willing to leave a browser tab open throughout the business day you can accomplish this with either (1) a script running on an interval in the open tab or (2) through a Chrome extension Crontabs:
Crontabs
Easy time management and tab scheduling for Chrome
http://www.crontabs.org/
Crontabs Chrome Extension
https://chrome.google.com/webstore/detail/crontabs/abhmbcedbojnghofcfmnageegmkmpkac?hl=en
In either of these two options, the basic idea is for a page to query on a 15 minute interval using the API for those records which are within 15 minutes of their target time. Then the script edits those records changing a date/time field to the current time. A notification can then trigger informing the user that the target time is approaching. You will need to craft the notification so that it emphasizes that the target time is approaching rather than that the date/time field has change.
if you need assistance setting this up feel free to contact me me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt/
If you are willing to leave a browser tab open throughout the business day you can accomplish this with either (1) a script running on an interval in the open tab or (2) through a Chrome extension Crontabs:
Crontabs
Easy time management and tab scheduling for Chrome
http://www.crontabs.org/
Crontabs Chrome Extension
https://chrome.google.com/webstore/detail/crontabs/abhmbcedbojnghofcfmnageegmkmpkac?hl=en
In either of these two options, the basic idea is for a page to query on a 15 minute interval using the API for those records which are within 15 minutes of their target time. Then the script edits those records changing a date/time field to the current time. A notification can then trigger informing the user that the target time is approaching. You will need to craft the notification so that it emphasizes that the target time is approaching rather than that the date/time field has change.
if you need assistance setting this up feel free to contact me me off-world using the information in my profile:
https://getsatisfaction.com/people/dandiebolt/