-79%

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

Name: Stone River Elearning - Google Apps Script - Project Management App Project
Availability: InStock

$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]

Category: IT & Technology Tags: Google Apps Script - Project Management App Project, Stone River eLearning, Stone River Elearning - Google Apps Script - Project Management App Project

Description
Reviews (0)

Stone 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.net.

– 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!