Task Tracking Application with Google Apps Script GSuite

Learn to set up Google Apps Script by logging into Drive, creating a test tracking application sheet, and preparing a web app with restricted email access.

Set up a Google Apps Script web app with two templates for viewing and editing tasks, enforce login by checking the active user's email, and render JSON outputs via ContentService.

Set up tasks and subtasks in a Google Apps Script spreadsheet, with id, created, details, completed, and creator, and pass data to a web front end via JSON.

List tasks and subtasks from the tasks sheet in a Google Apps Script web app, returning a client side data object. Skip completed rows and include id, created, and due.

Select subtasks from the main task list and send them to the client side, build a sub tasks list, and compute a completion percentage for front end display.

Connect google script data to the client side using bootstrap and moment js to render spreadsheet tasks on a web page, looping through data and displaying tasks and sub tasks.

Create and display sub tasks for each main task by looping through tasks and subtasks, building a Bootstrap styled list with due dates, assigned to, and completion using Moment.js.

Develop a client-side sheet editor in a Google Apps Script web app, enabling multiple templates, direct sheet updates, and page navigation based on URL parameters for editing.

Build a client-side editor for a task tracking app, bootstrap styling, a task adder and subtasks, and wire saving to a spreadsheet via JavaScript with alerts and editable existing tasks.

Send front-end task data to Google Script backend to add tasks, using JavaScript to gather inputs, validate, and trigger Google Script run with a success handler.

Learn to send client-side data to Google Apps Script, create server-side tasks, and append them to the tasks sheet with id, date, assigned, details, completed, creator, and user email.

Edit subtasks on the client side by turning fields into editable inputs, handling task ids and due dates, and saving updates via a backend update task function.

Learn how to update tasks in the Google Apps Script task tracker by finding the correct row by id, preparing update data, and writing changes back to the tasks sheet.

Update subtasks by id in the sub task function, wiring details, due date, assignee, and completion, and send updates to Google script, mirroring the update task flow.

Update a sub task in the spreadsheet by syncing data to the server and updating four columns (due date, assign, details, complete) based on the sub task ID.

Dynamically add subtasks to tasks in a Google Apps Script task tracker using an Add Sub Task Adder to append inputs under the main task and set due dates.

Add sub tasks by appending values to the main task I.D., update the data object with sub task details and dates, and distinguish tasks from sub tasks with styling.

Implement access control in the task tracking app by validating the active user's email against the access sheet and gating edits to authorized users within Google Apps Script GSuite.