I installed the Group Calendar sample application. I've been trying to find a way to send an email alert to the contact person (email) identified in the calendar event when the event becomes due. Meaning, a task (for example) has been entered in the calendar and is due sometime next week. That is entered in the group calendar with an owner. When that event/task is due, the calendar app will send an email alert to the owner about that task, on the day the task is due.
Anyone know the SQL code (s) and step by step instructions on adding this feature in the group calendar app? It should be triggered by the due date and time in the calendar. Any video or links to how to would be greatly appreciated.