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 |