Please enable JavaScript.

Coggle requires JavaScript to display documents.

Task Management System - Coggle Diagram

- - - - Instruction
        
        To Follow the steps to setup the tool
        
        No Formulas
      - Tool SetUp Checklist
        
        Check whether steps are performed in order
        
        No Formulas
      - Dashboard
        
        Contain Employee, Employee Sheet, Employee Tasks Update links and Task Delegation Form
        
        Employees Populated by Appscript and formulas for hyperlink to their sheets and form and also task delecation form hyperlink
      - Delegated Tasks
        
        All Delegated tasks to all users in decending order of date
        
        formula =SORT(Tasks!A:M,2,false)
      - Bulk Tasks
        
        Bulk task delegation too which works with appscript trigger
        
        No Formula, formula in Appscript
      - Tasks
        
        The tasks are populated through form and has conditional formatting with Task ID added using script
        
        No Formula, formula in Appscript
      - Setting
        
        Setting Page to add New Users, KRA Frequency, Task Counter, Folder Id, PDF Counter, Trigger Status, Trigger Creater, Trigger CreatorGmail, Delete User, Update User Form, Send WhatsApp, Send email, Skip Saturday, Skip Sunday, Skip Holiday and Holiday List
        
        No Formula, formula in Appscript
      - Reminders
        
        Mail Triggers For
        Weekly Dand Time, Daily Time WhatsApp Api, KRa Asign Time and Email and WhatsApp templates
        
        No Formula, formula in Appscript
      - KRAs
        
        Repeatable Daily Weekly and Monthly Task
        
        No Formula, formula in Appscript
    - - Users Sheet
        
        Current Users all current pending tasks in this sheet
        
        formula =IFNA(FILTER(Tasks!A:M,Tasks!D:D="Madhukar",Tasks!G:G<>"Completed",Tasks!G:G<>"Delayed",Tasks!G:G<>"Removed"),"")
      - Users Update Sheet
        
        Data from Users Task Update Form
        
        No formula
    - - Instruction
        
        No Appscript
      - Tool SetUp Checklist
        
        No Appscript
      - Dashboard
        
        Populated by appscript, Employee name written, Sheet Created for Employee, a Form attached to sheet created, Employee workbook created and thier links updated in different cells in this sheet
      - Delegated Tasks
        
        No Appscript
      - Bulk Tasks
        
        Appscript to create bulk tasks and paste it in respective users sheet
      - Tasks
        
        No Appscript in sheet but connected Form runs appscript on submit to create new task with task number
      - Setting
        
        Use creation appsript that creates user, their form, sheet worksheet, create details in dashboard by filling links
        
        Use Template ID in appscript
        
        Folder ID to use where files will be located
        
        Task counter to use in counting of tasks in appscript
        
        pdf counter to use in counting of pdf in appascript
        
        Update User Form Appscript
        
        Trigger status checker, with trigger creator name and gmail id
        
        trigger to if to send whatsApp
        
        trigger to check if to send email
        
        Check to skip notifying users on Saturday, Sunday or listed holidays
        
        Use deletion appsript that deletes user, their form, sheet worksheet, deletes details in dashboard by erasing links
      - Reminders
        
        Mail weekly triggers with date and time
        
        Communication Daily triggers with date and time
        
        WhatsApp Appi Key to WhatsApp messaging
        
        Messages template to use in email and whatsapp messages
      - KRAs
        
        Create daily weekly and monthly KRA's using appscript
      - Dynamic Sheets
        
        User Sheet
        
        No APpscript
        
        User Update Sheet
        
        On form submit appscript to update task status etc
      - Functions :
        
        onOpen()
        
        createTriggerz()
        
        createNamedSheetsz()
        
        bulkTasksz()
        
        onFormSubmit(e)
        
        taskChecker()
        
        kraTask()
        
        MonthlykraTask()
        
        dailyTaskRemainder()
        
        weeklyUpcomingTasks()
        
        removeUserr()
        
        deleteTrigger()
        
        selectedFormUpdater()
      - Triggers
        
        Head Timebased dailyTaskRemainder
        
        Head Timebased weeklyUpcomingTasks
        
        Head Timebased MonthlykraTask
        
        Head Timebased kraTask
        
        Head Timebased taskChecker
        
        Head From spreadsheet On form submit onFormSubmit
- - - - Create Sheet1
      - Create Sheet 2
      - Create Dashboard
        
        Create details and links for all users