About This Course

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with GSuite. Explore how you can use Google Apps Script to create a project management tracking application from scratch.

Course covers the following in a step by step format:

  • Get Coding Google Apps Script quick introduction to accessing your Google Script Environment
  • Updating the menu with custom buttons SpreadsheetApp.getUi
  • Add additional functions and menu items
  • The sidebar UI showSidebar
  • Send data from spreadsheet to client side sidebar window
  • Create html page to send data using google.script.run
  • Create Input Form HTML
  • Use Add saving event pass values to Google Script
  • Add data to spreadsheet
  • Set Values in spreadsheet
  • Create WebApp to view project status chart
  • Get all data from a spreadsheet and send it to the client side
  • Create Client Side Chart google.charts client side gantt chart display data from spreadsheet
  • Test and Finalize project

Source code is included along with over twenty pages bonus PDF guide. Fast, friendly support to help answer any questions you might have and to help clarify content is always available. 

Requirements

  • JavaScript Programming experience

Who this course is for:

  • Web developers
  • Application developers and coders
  • Anyone who wants to learn more about Google Apps Script

Our Promise to You

By the end of this course, you will have learned Google Apps Script for project management.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Google Apps Script – Project Management App Project.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Downloadable Materials 00:00:00
Developer Environment Setup 00:00:00
Add Menu Item To Spreadsheet Class UI 00:00:00
Create HTML Page Menu 00:00:00
More Menu Items Within A Spreadsheet Page 00:00:00
Menu Functions For App 00:00:00
Spreadsheet Data To Client Side 00:00:00
Submit To Spreadsheet From Sidebar Menu 00:00:00
Populate Client Side With Tasks 00:00:00
Google Script Run Values 00:00:00
Form Client Side Inputs 00:00:00
Add Client Side Data To Spreadsheet 00:00:00
Update Sheet Data Cell 00:00:00
Test Data For Debugging Google Script Functions 00:00:00
Get Existing Row Data And Send Into A Json Object To Client Side Script 00:00:00
Update Row Data 00:00:00
Bug Fixes And User Message 00:00:00
Web App Gantt Chart 00:00:00
Output Sheet Content Gantt From Spreadsheet To Web App 00:00:00
Chart Options 00:00:00
Project Management Conclusion 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel