Google Apps Script Create a Project Management App Project
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
- Preview04:36
- 00:35Bonus PDF Resource Guide for Course Apps Script Guide
- Preview05:31
- 05:09Add menu item to spreadsheet Class UI
- 00:02Source Code
- 07:50Create html page menu
- 00:06Source Code
- 02:21More Menu Items within a spreadsheet page
- Preview06:53
- 06:26Spreadsheet Data to client side with Google Apps Script
- 00:14Source Code
- 06:09Submit to Spreadsheet from sidebar menu using Apps Script
- 00:11Source Code
- 07:03Populate Client side with tasks integrate sheet active content with sidebar
- 00:26Source Code
- 06:03Google Script Run Values sending from client to backend Google Script
- 00:28Source Code
- 04:37Form Client Side Inputs create a form for inputs
- 00:13Source Code
- 08:58Add Client Side data to spreadsheet connected Google Apps Script GSuite
- 00:29Source Code
- 03:17Update Sheet Data Cell select cell contents update and set values in spreadsheet
- 00:33Source Code
- 03:25Test Data for debugging Google Script functions
- 07:23Get existing Row Data and send into a JSON object to client side script
- 00:45Source Code
- 09:57Update Row Data with new values set and get range values
- 01:27Source Code
- 04:14Bug Fixes and User Message and testing updates
- 01:31Source Code
- 05:18Web App Gantt Chart using Google chart library display Spreadsheet data
- 00:07Source Code
- 12:01Output Sheet Content Gantt from spreadsheet to web app
- 00:24Source code
- 04:23Chart Options make your Google Chart customize display options
- 02:06Source Code
- 13:33Project Management mini Google Apps Script Application build Conclusion
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
Instructor
![Laurence Svekis](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 41,752 Reviews
- 706,688 Students
- 369 Courses
I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today
Google Developers Expert - GSuite
Providing Web development courses and digital marketing strategy courses since 2002.
Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.
"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."
"Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge."
Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real.
"My courses are designed to help you achieve your goals, learn and update skills"
Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO.
"Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"