Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Apps Script Create a Project Management App Project
Rating: 4.4 out of 5(26 ratings)
2,825 students

Google Apps Script Create a Project Management App Project

Introduction to using Google Apps Script to create a GSuite integrated project management app within Spreadsheets
Created byLaurence Svekis
Last updated 11/2024
English

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

2 sections • 41 lectures • 2h 31m total length

  • Apps Script PM app introduction.4:36
  • Bonus PDF Resource Guide for Course Apps Script Guide0:35
  • Developer Environment Setup5:31

    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 menu item to spreadsheet Class UI5:09

    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.

  • Source Code0:02
  • Create html page menu7:50
  • Source Code0:06
  • More Menu Items within a spreadsheet page2:21
  • Menu Functions for App run GS functions6:53
  • Spreadsheet Data to client side with Google Apps Script6:26
  • Source Code0:14
  • Submit to Spreadsheet from sidebar menu using Apps Script6:09
  • Source Code0:11
  • Populate Client side with tasks integrate sheet active content with sidebar7:03
  • Source Code0:26
  • Google Script Run Values sending from client to backend Google Script6:03
  • Source Code0:28
  • Form Client Side Inputs create a form for inputs4:37
  • Source Code0:13
  • Add Client Side data to spreadsheet connected Google Apps Script GSuite8:58
  • Source Code0:29
  • Update Sheet Data Cell select cell contents update and set values in spreadsheet3:17

    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.

  • Source Code0:33
  • Test Data for debugging Google Script functions3:25
  • Get existing Row Data and send into a JSON object to client side script7:23
  • Source Code0:45
  • Update Row Data with new values set and get range values9:57
  • Source Code1:27
  • Bug Fixes and User Message and testing updates4:14
  • Source Code1:31
  • Web App Gantt Chart using Google chart library display Spreadsheet data5:18
  • Source Code0:07
  • Output Sheet Content Gantt from spreadsheet to web app12:01

    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.

  • Source code0:24
  • Chart Options make your Google Chart customize display options4:23
  • Source Code2:06
  • Project Management mini Google Apps Script Application build Conclusion13:33

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

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

Report abuse