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 : 





Activate On Edit Trigger

On edit trigger applies only to cases where the task is being completed. It sends a reminder to project manager.

With this Function on Edit trigger will be created and meanwhile if there is any existing trigger it will be   deleted, only one trigger will be created to perform the following tasks

To find the triggers please follow the steps Provided in “To find the The triggers created for the project follow the below steps” outline .


Deactivate OnEdit Trigger

With this Function onEdit trigger will be deleted, Email  Notification check would not happen on Updating DueDate or Task Completion Status.

To find the triggers please follow the steps Provided in “To find the The triggers created for the project follow the below steps” outline .


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.