Help using Group Calendar sample application - need email alerts when event is due

Newbie_820-Oracle

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.

Newbie_820-Oracle

I'm looking here also - https://docs.oracle.com/database/apex-5.1/HTMDB/sending-email-from-an-application.htm#HTMDB29887

Newbie_820-Oracle

And here: https://docs.oracle.com/database/121/AEAPI/apex_mail.htm#AEAPI341

Just not sure how to trigger it from a calendar's due date.

Jeroen Graafmans

I'm using Automations to 'trigger' emails. Works great!

Automate your business process in Oracle APEX 20.2 | Oracle Application Express Blog

Regards,

Jeroen