Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

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.

Comments

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.

I'm using Automations to 'trigger' emails. Works great!
Automate your business process in Oracle APEX 20.2 | Oracle Application Express Blog
Regards,
Jeroen

1 - 3

Post Details

Added on Mar 12 2021
3 comments
225 views