This course is designed for those interested to learn the basics of Google Apps Script, explore its uses for developing a project management and business app from scratch with GSuite integration.
Read more.Instructor
I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today. Providing Web development courses and digital marketing
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Web developers
- Application developers and coders
- Anyone who wants to learn more about Google Apps Script
What you’ll learn:Â
- 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
Requirements:Â
- JavaScript Programming experience
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.
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.
Our Promise to You
By the end of this course, you will have learned Google Apps Script for project management.
10 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 |