"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Google Apps/Google Scripting – Basics through to Sheet Customisation Duration: 1 day

Google Scripting - Basics Through To Sheet Customisation Duration: 1 Day

Course Overview

Google Apps Script is based on JavaScript and gives great flexibility to customise and automate Google Docs and Sites. The Script Editor allows you produce something as straightforward as a custom sheet function to a fully-fledged support ticketing system

 

   

 

Module 020: Google Script Basics

Script editor

Executing scripts

Example - Send email

Example – Creating a custom sheet function

JavaScript basics

If…Then…Else

Do…Until

For…Next

Module 021: Working with Sheets using Script

Sheet visibility

Column/row visibility

Event triggers in Google script

Protection options for scripts

Ability to record script and then edit

Run & Debug

Example: Support Tickets Sheet

Module 022: Google Scripts Code

Declaring variables & variable types/limits

Syntax

Beginning and ending scripts

Comments

Object libraries

Formatting with script

Error trapping

On error…

Resume next

GoTo

Input & message boxes

UDFs

This training can be tailored and combined with any of the further Google courses advertised