Timed (hours not dates) notification based on tracker items
Hello,
I've been moving since a few days trying to find a solution for daily alerts based on trackers.
Example;
In a tracker, I have a task, a trackeritems with username, date, task description and a checkbox (completed).
This task is recreated everyday using a listExecute and scheduler item (automatic) that duplicate the item every day after midnight defaulting the date field to same (new) day.
This is working fine.
Now I want to add a mechanism that will send a notification to the user attached to the task if an hour has passed since this task should have been completed. (still using listExecute)
This intend I have a reference time for the task to be done and a limit time that if passed, the notification should be sent. As those should be fixed I can't use the existing date field (time is modified on duplication).
So my best guess is that I should create 2 "date and time" fields (Tiki doesn't have just time), use mathematical fields to curate the dates and have something like "tasktime" (8:00) and "tasktimelimit" (9:00).
Setup in a listExecute ran every hours with a filter to check if tasktimelimit > (tasktime + 1hour) (this last chunk I'm still unsure).
Does smart have other ideas ?
(Duration field ?)