$25.00 $149.00 Sale
Stone River Elearning – Google Apps Script – Project Management App Project
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
Shipping method
– After making a purchase, you will see a View your order link to the Downloads page. Here you can download all the files related to your order.
– In case the link is broken for any reason, please contact us and we will resend a new download link.
– If you can’t find the download link, please don’t worry about it. This course is usually available and shipped within one day
– The course you purchased will have lifetime access
– Our support staff is the best by far! Please contact us at email: [email protected] and we will be happy to help!
