Task Delegation
Client
Balacomm
Industry
Media Production
Category
Office Work Automation
Google Apps Script Web App
Task Delegation script enables admin or manager to assign tasks to employees, In fact anyone can assign any task to anyone. once the task is assigned through google form, Employees will get a notification stating that they have got a task assigned with the target date.
Then the employees will submit their answers with the Google form which they received with the notification email. If the task is clear to them, They will submit the actions required for the task and then the task will be added to the google sheet to both master(Managing Director sheet) and employee sheet.
​
![Screenshot from 2022-10-27 13-40-14.png](https://static.wixstatic.com/media/8ef864_72c4679a1720498ab7b3de0eefbe7e4f~mv2.png/v1/fill/w_461,h_372,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Screenshot%20from%202022-10-27%2013-40-14.png)
![Screenshot from 2022-10-27 13-39-21.png](https://static.wixstatic.com/media/8ef864_c0c97c73bd854e5dbb9d55184fdd8680~mv2.png/v1/fill/w_434,h_343,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Screenshot%20from%202022-10-27%2013-39-21.png)
The script always scan the spreadsheet every morning and evening to check which task is completed and which task is delayed. Then the employees get a notification with a list of pending tasks for the current day in the morning and a report of the current day in the evening.
​
If the target date is over then the employees will receive a notification email to submit a new target date.
![Screenshot from 2022-10-27 13-40-57.png](https://static.wixstatic.com/media/8ef864_888f76213c4f4b72b62823050e437f8e~mv2.png/v1/fill/w_623,h_271,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Screenshot%20from%202022-10-27%2013-40-57.png)