Custom menu named Activate / Deactivate notifications will be added on the menu bar with 3 actions :

Authorize email
By clicking on authorize email, you allow Google to send you emails

Reminder function - send a reminder email to task owner on below conditions
First reminder to task owner 1 week before the due date
Reminder to task owner before 2 days until the due date
1 day after the due date, will send reminder to project manager
Task completion notification - to project manager on below conditions
If task completion = 100%, send notification to project manager.
If notification sent once , will not be sent to the project manager again.
By activating this notification, email notifications will be sent to the task owner and project manager following these conditions :
With this function, there will be no notification emails
Column I has been Protected because it has information on the Mails that is been sent to the manager. Since the request had criteria to send mail to manager on task completing only once, we had to store the data in some place, and yet not to be tampered by the users. As a solution for the above issue, we have given permission only for the owners to make changes to column I. We Hidden this column, so that user will not have the knowledge of this column existence. |