Google Apps Script Create a Project Management App Project

Focused View

Laurence Svekis

2:21:22

37 View

1. Introduction to project and Google Apps Script Development

1. Apps Script PM app introduction..mp4

04:36

2.1 Project Management App Google Scripts 1.pdf

2. Bonus PDF Resource Guide for Course Apps Script Guide.html

3. Developer Environment Setup.mp4

05:31

4. Add menu item to spreadsheet Class UI.mp4

05:09

5. Source Code.html

6. Create html page menu.mp4

07:50

7. Source Code.html

8. More Menu Items within a spreadsheet page.mp4

02:21

9. Menu Functions for App run GS functions.mp4

06:53

10. Spreadsheet Data to client side with Google Apps Script.mp4

06:26

11. Source Code.html

12. Submit to Spreadsheet from sidebar menu using Apps Script.mp4

06:09

13. Source Code.html

14. Populate Client side with tasks integrate sheet active content with sidebar.mp4

07:03

15. Source Code.html

16. Google Script Run Values sending from client to backend Google Script.mp4

06:03

17. Source Code.html

18. Form Client Side Inputs create a form for inputs.mp4

04:37

19. Source Code.html

20. Add Client Side data to spreadsheet connected Google Apps Script GSuite.mp4

08:58

21. Source Code.html

22. Update Sheet Data Cell select cell contents update and set values in spreadsheet.mp4

03:17

23. Source Code.html

24. Test Data for debugging Google Script functions.mp4

03:25

25. Get existing Row Data and send into a JSON object to client side script.mp4

07:23

26. Source Code.html

27. Update Row Data with new values set and get range values.mp4

09:57

28. Source Code.html

29. Bug Fixes and User Message and testing updates.mp4

04:14

30. Source Code.html

31. Web App Gantt Chart using Google chart library display Spreadsheet data.mp4

05:18

32. Source Code.html

33. Output Sheet Content Gantt from spreadsheet to web app.mp4

12:01

34. Source code.html

35. Chart Options make your Google Chart customize display options.mp4

04:23

36. Source Code.html

37. Project Management mini Google Apps Script Application build Conclusion.mp4

13:33

2. Google Apps Script Coding Examples

1. How to add menu items to Spreadsheet UI menu.mp4

06:15

2. Source Code adding menu items to Sheet UI.html

3.1 Google AppsScript Code Examples.pdf

3. Google Apps Script Resource and code example Guide.html

Description

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

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

Who is this for?

Web developers

Application developers and coders

Anyone who wants to learn more about Google Apps Script

What You Need to Know?

JavaScript

Programming expereince

Desire to learn google apps script

Prior Google Script experience

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Project Management

Laurence Svekis

Instructor's Courses

I'm here to help you learn, achieve your dreams, come join me on this amazing adventure todayGoogle 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!"

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.