Google Apps Script CalendarApp and SpreadsheetApp Project
Google Apps Script CalendarApp and SpreadsheetApp Project, available at $44.99, has an average rating of 4.25, with 32 lectures, based on 54 reviews, and has 6159 subscribers.
You will learn about Appply Google Apps Script to create projects Build SpreadsheetApp and CalendarApp applciations Explore using JavaScript for client side interaction with Google Script Develop and deploy web app with Google Script Add interactive functions into Google Spreadsheet This course is ideal for individuals who are JavaScript developers or Google Apps Script Coders or Anyone who wants to learn Google Script or Web developers or Application creators or Business process improvement developers It is particularly useful for JavaScript developers or Google Apps Script Coders or Anyone who wants to learn Google Script or Web developers or Application creators or Business process improvement developers.
Enroll now: Google Apps Script CalendarApp and SpreadsheetApp Project
Summary
Title: Google Apps Script CalendarApp and SpreadsheetApp Project
Price: $44.99
Average Rating: 4.25
Number of Lectures: 32
Number of Published Lectures: 32
Number of Curriculum Items: 32
Number of Published Curriculum Objects: 32
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Appply Google Apps Script to create projects
- Build SpreadsheetApp and CalendarApp applciations
- Explore using JavaScript for client side interaction with Google Script
- Develop and deploy web app with Google Script
- Add interactive functions into Google Spreadsheet
Who Should Attend
- JavaScript developers
- Google Apps Script Coders
- Anyone who wants to learn Google Script
- Web developers
- Application creators
- Business process improvement developers
Target Audiences
- JavaScript developers
- Google Apps Script Coders
- Anyone who wants to learn Google Script
- Web developers
- Application creators
- Business process improvement developers
Explore how you can use Google Apps Script to develop interactive applications that can be used to improve business workflow and extend the functionality of the google suite of products. This course covers building a project which adds the ability within a Google Spreadsheet to search the users Google Calendar and track results within the spreadsheet. In Addition create an option to add items into the users calendar from the spreadsheet menu as well as from a web app url form.
JavaScript is a prerequisite to Google Script as its based on JavaScript coding. Many of the methods and code from JavaScript can be used to write Google Script. If you know JavaScript you know Google Script!!!!
Google provides classes and methods that can be applied within the code to connect various Google products together to create some REALLY REALLYamazing functionality that can save time. Power up your web development using the POWER of GOOGLE
So many amazing things can be done – if you have never used Google Script then prepare to be AMAZED – best of all its easy and you can do SOOOO MUCH with just a few lines of code.
Course Contents –
-
CalendarApp – selecting events
-
CalendarApp – creating events into your calendar
-
SpreadsheetApp – updating UI adding buttons
-
SpreadsheetApp – running functions from UI tool menu
-
SpreadsheetApp – Creating new sheet
-
SpreadsheetApp – Adding rows and content to spreadsheet
-
HTMLService -Use of html templates files for project output and popup windows
-
SpreadsheetApp – UI dialog window, toast, sidebar
-
Web App with URL to connect to Google Script methods
-
Sending data from client side to server side – return and response handling
-
JavaScript for checking if values exist in a string
-
JavaScript HTML and CSS for template used as dialog
-
Sending form data to Google Script to handle
Please note that this is a project based course covering step by step how to build and construct the project – source code is also included so you can try the code yourself.
Step by step learning with all steps included.
Beginner JavaScript knowledge is required. Also HTML and CSS knowledge is essential.
Along with friendly support in the Q&A to help you learn and answer any questions you may have.
Try it now you have nothing to lose, comes with a 30 day money back guarantee.
Create your own Google Script see what amazing things you can build with it.
Course Curriculum
Chapter 1: Introduction to using Google Apps Script and the project that will be built
Lecture 1: Introduction to Google Calendar Script Project
Lecture 2: Introduction and setup of Google Script
Chapter 2: Interactive Calendar search and event creating application – spreadsheet tracker
Lecture 1: CalendarApp Setup – Google Apps Script Course
Lecture 2: Google Script Source Code
Lecture 3: Add a sideBar and Dialog window – Google Apps Script Course
Lecture 4: Source Code Google Script
Lecture 5: HTML service Method setup template for dialog
Lecture 6: Code.gs Google Script Source
Lecture 7: CalendarApp Methods – Google Apps Script
Lecture 8: Source Code Google Script
Lecture 9: New Event Form HTML – using html templates
Lecture 10: Source Code HTML
Lecture 11: JavaScript Form Submit Data
Lecture 12: Google Script Run client side to server side
Lecture 13: Source Code Google Script
Lecture 14: Create Calendar Event from Form
Lecture 15: Source Code Google Script
Lecture 16: Spreadsheet Tweaks for happy users – Google Apps Script
Lecture 17: Source Code Google Script
Lecture 18: Create Event Checker – adding calendar events
Lecture 19: Client Side to Server Side data
Lecture 20: Source Code Google Script
Lecture 21: Sheet Maker SpreadsheetApp working with Sheets
Lecture 22: Source Code Google Script
Lecture 23: Get Event Data for Sheet ready data to use and apply
Lecture 24: Source Code Google Script
Lecture 25: Search Title Update and add events to Spreadsheet
Lecture 26: Source Code Google Script
Lecture 27: Creating your WebApp Option to add a URL
Lecture 28: Google App Code Review – Project Overview
Lecture 29: Source Code Google Script
Chapter 3: Resources and bonus content
Lecture 1: Google Apps Script Resource and code example Guide
Instructors
-
Laurence Svekis
Instructor, GDE, Application Developer
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 3 votes
- 3 stars: 9 votes
- 4 stars: 19 votes
- 5 stars: 23 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024