Google Apps Script for Beginners- Amazing Things with Code
CM
eTrain
Summary
- Exam(s) / assessment(s) is included in price
- Tutor is available to students
Overview
Get started with Google Apps Script - Perfect course for beginners who want to explore what they can do with Google Apps Script
Apps Script is based on JavaScript 1.6, (1.7 and 1.8). Many basic JavaScript features in addition to the built-in and advanced Google services. Apps Script code runs on Google's servers. Knowledge of JavaScript is a prerequisite to Google Apps Script which will allow you to jump right in and begin coding. - Just like JavaScript with some extra methods.
The course covers the following topics and is designed a quick beginners guide to using and creating Google Apps Script applications.
- How and where to begin coding
- How Google Apps Script works
- Google Marcos - really apps script code
- Editing and updating script code
- Getting familiar with the Script editor
- Standalone and Bound scripts
- Document Service
- JavaScript in Google Apps Script
- JavaScript Variables, Arrays, Objects, Loops, Conditions, Functions....
- Coding JavaScript within Apps Script
- Explore the online editor File Tab
- Creating new files
- Apps Script triggers
- View tab and debugging
- Run tab and debugging
- Create a web app publish tab
- Using html file for client side web app
- Web apps made dynamic
- Dialogs and UI options
- Document as PDF
- Spreadsheet service
- Sheet data and UI
- Copy and select content in range and objects
- Spreadsheet and calendar
Who this course is for:
- Web developers
- Application developers
- Anyone who wants to learn more about Google Apps Script
- Anyone who wants to automate Google Suite
- JavaScript coders
Requirements:
- JavaScript, HTML and CSS
- Prior programming knowledge
- Solid understanding of JavaScript
Description
Course Curriculum
Introduction to Google Apps Script writing Code and Functionality
Introduction to Google Apps Script Course (4:42)
Google Apps Script (3:03)
Macros for Script (5:19)
More fun with Macros (3:55)
Google Apps Script Scripting (1:57)
Create Standalone Script (11:12)
Get by ID Document (5:24)
Document Service (3:59)
JavaScript code and Google Apps Script Coding
JavaScript in Apps Script (5:30)
JavaScript Array (5:26)
Google Sheets AppendRow (4:31)
JavaScript Objects (3:43)
JavaScript Functions (3:49)
JavaScript Conditions (2:54)
JavaScript Loops (3:31)
Explore the online IDE Code editor for Google Apps Script
Online Google Script Editor IDE Online Editor (3:07)
Online Google Script Editor Edit Tab (5:18)
Online Google Script Editor View Tab (1:47)
IDE Run Google Apps Script Editor (1:46)
WebApp launch and Publish Tab (6:51)
Web App Dynamic Code (2:45)
Editor Resources and Help (2:16)
Document App UI and Spreadsheet App - Fun with Google Apps Script Projects
Document Service (4:17)
Dialogs and custom UI buttons (8:34)
Document as PDF (8:00)
Spreadsheet Data (4:27)
Add new sheet (6:28)
Copy Content in Sheet (4:34)
Calendar Data to Spreadsheet (10:08)
Google Apps Script Conclusion (5:00)
Frequently Asked QuestionsWhen does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
After enrolling, you will have unlimited course access for 12 months.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
Who is this course for?
Requirements
Career path
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.