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

Activate notifications :
By activating this notification, email notifications will be sent to the task owner and project manager in the following conditions :
The daily function trigger ( everyday 9 AM ) will send automated emails
Reminder function - send reminder email to task owner
First reminder to task owner 1 week before the due date if the task completion < 100 %
Reminder to task owner before 2 days until the due date if the task completion < 100%
1 day after the due date, will send reminder to project Manager
Task Completion Notification - to Project Manager
If task Completion = 100%, send notification to Project Manager.
If the users changed the Due Date or Task Complete, the Task Complete Notification and Reminder will send and status will be reset.
If the users update the Task Complete column, the Notification check will be performed again.
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. |