Google Apps Script Create a Project Management App Project

Build a Google Apps Script project management app that reads a spreadsheet, outputs a web app with a visual Gantt chart, and supports updating and adding tasks with dependencies.

Set up the Google Apps Script developer environment to build a bound project management app using the online editor, Drive integrations, and collaboration features.

Add an advanced menu to your Google Sheets UI with Apps Script, wiring a tester function to a test item, using onOpen, getUI, and createMenu, and view logs for debugging.

Create a popup sidebar in a google apps script project and render an html template from file. Display a test message and pass data between script and client side.

Extend the spreadsheet menu with Google Apps Script by adding new task, separators, and submenus, plus dialogs, and preview changes with on open.

Add interactivity to a google apps script project by creating a new task and a get tasks function that fetches spreadsheet data, then pass it to the client side.

Fetch spreadsheet data with Google Apps Script by selecting the active spreadsheet and a named sheet, then return range values to the client side for a sidebar menu.

Update the spreadsheet headings and build a client-side Apps Script form to submit new tasks with id, name, dates, duration, percentage complete, and dependencies.

Populate the client side with tasks from the spreadsheet using a page object and query selectors to feed a task dropdown, date fields, and dynamic dependencies in the sidebar.

Submit triggers a listener that collects form values into an object and sends it to google.script.run backend, with success and error callbacks to handle responses.

Build a client-side form by iterating through all input, textarea, and select values to form an object, then submit to the google script using a saver function and handle success.

Learn to submit sidebar task data into the project sheet, calculate duration from start and end dates, validate inputs, and append a row with id, name, date, duration, and percentage.

Learn to update sheet data using Google Apps Script: retrieve range with getRange, build a multi-dimensional array, and use setValues to update I.D. and role fields in six columns.

Develop test data to debug Google script functions, log outputs, and validate data object with fields name, start date, end date, percentage complete, and dependencies using the debugger and breakpoints.

Select the active cell's row data, assemble a json object with id and role, and send it to the client side script to update or create a task.

Update row data with new values on the client side, handle blank ids for new tasks, and populate dates and dependencies to support create and update flows.

Fix bugs in a Google Apps Script project management app by correctly signaling create versus update, displaying user messages, validating data IDs, and resetting the form for new entries.

Build a web app with Google Apps Script using doGet to render HTML, pass spreadsheet data to the client, and display a Gantt chart with the Google Chart library.

Create a gantt chart from spreadsheet data using the Google charts loader in Apps Script, converting dates to milliseconds and mapping seven columns to draw and customize the chart.

Explore how to customize a Google Gantt chart with options like height, colors, and critical path, and learn to structure data, update tasks, and set dependencies.

Build a fully functional project management app with Google Apps Script, tracking tasks, dates, duration, and progress in a shareable web app and chart.