Google Apps Script - Project Management App Project
4.8 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,680 students enrolled

Google Apps Script - Project Management App Project

Introduction to using Google Apps Script to create a GSuite integrated project management app within Spreadsheets
4.8 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,680 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
21 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 17 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create a simple project management application tool
  • Build a useful business application using Google Script
  • Practice creating applications with Google Script
Course content
Expand all 38 lectures 02:26:02
+ Introduction to project and Google Apps Script Development
37 lectures 02:24:50
Bonus PDF Resource Guide for Course Apps Script Guide
00:35
Add menu item to spreadsheet Class UI
05:09
Source Code
00:02
Create html page menu
07:50
Source Code
00:06
More Menu Items within a spreadsheet page
02:21
Spreadsheet Data to client side with Google Apps Script
06:26
Source Code
00:14
Submit to Spreadsheet from sidebar menu using Apps Script
06:09
Source Code
00:11
Populate Client side with tasks integrate sheet active content with sidebar
07:03
Source Code
00:26
Google Script Run Values sending from client to backend Google Script
06:03
Source Code
00:28
Form Client Side Inputs create a form for inputs
04:37
Source Code
00:13
Add Client Side data to spreadsheet connected Google Apps Script GSuite
08:58
Source Code
00:29
Update Sheet Data Cell select cell contents update and set values in spreadsheet
03:17
Source Code
00:33
Test Data for debugging Google Script functions
03:25
Get existing Row Data and send into a JSON object to client side script
07:23
Source Code
00:45
Update Row Data with new values set and get range values
09:57
Source Code
01:27
Bug Fixes and User Message and testing updates
04:14
Source Code
01:31
Web App Gantt Chart using Google chart library display Spreadsheet data
05:18
Source Code
00:07
Output Sheet Content Gantt from spreadsheet to web app
12:01
Source code
00:24
Chart Options make your Google Chart customize display options
04:23
Source Code
02:06
Project Management mini Google Apps Script Application build Conclusion
13:33
Requirements
  • JavaScript
  • Programming expereince
  • Desire to learn google apps script
  • Prior Google Script experience
Description

Explore how you can use Google Apps Script to create a project management tracking application from scratch.

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite

DO NOT TAKE THIS COURSE IF YOU HAVE NO JAVASCRIPT EXPERIENCE  - JAVASCRIPT IS AN ABSOLUTE PREREQUISITE!!!

Course covers the following in a step by step format, source code is included along with a bonus 20+ page PDF guide.

  • 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 spreadsheet send to client side.

  • Create Client Side Chart google.charts client side gantt chart display data from spreadsheet

  • Test and Finalize project

Source Code is included

Fast Friendly support to help answer any questions you might have and to help clarify content is always available in the Q&A section.

Taught by an instructor with over 20 years real world experience ready to help you learn more.  Step by step training resources and source code is also included to get you started quickly.

Who this course is for:
  • Web developers
  • Application developers and coders
  • Anyone who wants to learn more about Google Apps Script