-79%
Add to Wishlist
Stone River Elearning - Google Apps Script - Project Management App Project

Stone River Elearning – Google Apps Script – Project Management App Project

Original price was: $149.00.Current price is: $32.00.

Instant Download: You will receive a download link via your order email immediately
Should you have any questions, please contact us: [email protected]

Use the 20% Coupon Code: Grateful 

SSL Secure

Category: Tags: , ,

Stone River Elearning - Google Apps Script - Project Management App Project1Stone River Elearning – Google Apps Script – Project Management App Project

Introduction to using Google Apps Script to create a GSuite integrated project management app within Spreadsheets

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

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

Who this course is for:

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

Requirements:

  • JavaScript
  • Programming experience
  • Desire to learn google apps script
  • Prior Google Script experience

Course Curriculum

Introduction to project and Google Apps Script Development
  • Apps Script PM app introduction (4:36)
  • Developer Environment Setup (5:31)
  • Add menu item to spreadsheet Class UI (5:09)
  • Create html page menu (7:50)
  • More Menu Items within a spreadsheet page (2:21)
  • Menu Functions for App run GS functions (6:53)
  • Spreadsheet Data to client side with Google Apps Script (6:25)
  • Submit to Spreadsheet from sidebar menu using Apps Script (6:09)
  • Populate Client side with tasks integrate sheet active content with sidebar (7:03)
  • Google Script Run Values sending from client to backend Google Script (6:03)
  • Form Client Side Inputs create a form for inputs (4:37)
  • Add Client Side data to spreadsheet connected Google Apps Script GSuite (8:58)
  • Update Sheet Data Cell select cell contents update and set values in spreadsheet (3:17)
  • Test Data for debugging Google Script functions (3:25)
  • Get existing Row Data and send into a JSON object to client side script (7:23)
  • Update Row Data with new values set and get range values (9:57)
  • Bug Fixes and User Message and testing updates (4:14)
  • Web App Gantt Chart using Google chart library display Spreadsheet data (5:18)
  • Output Sheet Content Gantt from spreadsheet to web app (12:01)
  • Chart Options make your Google Chart customize display options (4:23)
  • Project Management mini Google Apps Script Application build Conclusion (13:33)

Sale Page: https://stoneriverelearning.com/p/google-apps-script-project-management-app-project
Archive: https://archive.ph/wip/SFgOy

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.
– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from imcourse.biz.
– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.
– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).
Thank You For Shopping With Us!

Reviews

There are no reviews yet.

Be the first to review “Stone River Elearning – Google Apps Script – Project Management App Project”

Related Products

Stone River Elearning - Google Apps Script - Project Management App Project
Stone River Elearning – Google Apps Script – Project Management App Project

Use the 20% Coupon Code: Grateful 

SSL Secure