Enable Technology

Google Scripting

Google Script Training Courses Midlands

Google Scripting Training Courses Midlands | Birmingham | Telford | Wolverhampton

Enable Technology deliver scheduled Google Scripting programming courses primarily at e-Innovation Centre, near Birmingham, but also on demand across the Midlands.

Ideally candidates should have had some exposure to JavaScript syntax although this can be incorporated into the course. The main emphasis of the course is on manipulating spreadsheets although the course encompasses dynamically manipulating calenders and email. All delegates are issued with course materials which give direct VBA equivalent code to the Google Script examples.

Class sizes are small, all delegates receive detailed reference materials and we offer a post training support service.

Please contact Enable Technology if you would like additional information about multiple booking discounts, course dates or bespoke Google Script training.



Google Script Programming Course Overview


A three aday course introducing the fundamentals  Google Script Programming.  Participants will learn the how to create and manipulate Goolge documents, folders, calendars and spreadsheets.  The course will also demonstrate how to link google documents a a underlying database.

Duration: 3 day course

Cost: £950 plus VAT



Course Content


Introduction
Google Apps Scripting
JavaScript Scripting
Google Spreadsheet Limitations

Getting Started
Google Apps Script Examples
Executing Code

User Defined Functions
Built-in Versus User-Defined Functions
Custom User-Defined 
Introducing JavaScript Functions
User-Defined Functions Versus JavaScript Functions
Checking Input and Throwing Errors
Encapsulating A Complex Calculation
Numeric Calculations
Date Functions
Text Functions
Using JavaScript Library Methods
Using A Function Callback
Extracting Useful Information About The Spreadsheet
Using Google Services

Spreadsheets and Sheets
Native And Host Objects
Method Overloading In Google Apps Script
Object Hierarchies
SpreadsheetApp
The Spreadsheet Object
The Sheet Object
Practical Examples Using Spreadsheet And Sheet Objects

The Range Object
Range Objects Are Complex
Creating A Range Object
Getting And Setting Range Properties
The Range offset() Method
The Data Range Of A Sheet
Transferring Values Between JavaScript Arrays And Ranges
Named Ranges
Practical Examples 

MySQL and JDBC
JDBC Overview
My SQL Preliminaries
Setting Up Google Cloud SQL
Connecting To The MySQL Database
Creating A Table
Populating A Table
Writing Database Records To A Google Spreadsheet
Database Metadata
Adding Users

Building Simple Graphical Interfaces
Menus And Dialogues
Form Example
Layout and Panels
Building A Data Entry Form
Using List Boxes

Google Drive, Folders, Files and Permissions
List Google Drive File And Folder Names
Creating And Removing Files And Folders
Adding Files To And Removing Files From Folders
Methods Of Folder And File Objects
File And Folder Permissions
Practical Examples

Email and Calendars
Sending An Email Using MailApp
GmailApp
Calendars

Web Apps With Html Service
A Data Entry Form
Creating A Web App
Displaying Spreadsheet Values In A Web App



Please contact Enable Technology if you would like to discuss any of our Google Script training courses or would like to discuss the possibility of either bespoke or onsite training.



Midlands Training Locations : Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.

Scheduled Midlands Courses: Midlands Excel VBA; Midlands MS Project, Midlands SSRS; Midlands SQL; Midlands Crystal Reports; HTML; Midlands Adobe Illustrator; Midlands ASP.NET; Midlands Dreamweaver; Midlands Flash; Midlands Photoshop; Midlands InDesign; Midlands Google Scripting; Midlands Visio; Midlands PHP; Midlands Microsoft Access; Web Development Midlands; Midlands Microsoft Office;

Birmingham Telford Wolverhampton Midlands Database Onsite Courses: Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2012 Database Administration Training Courses; Birmingham Telford Wolverhampton Midlands SQL Server 2012 Data Warehouse Implementation Training Courses; Birmingham Telford Wolverhampton Midlands SQL Server 2005 Reporting Services SSRS Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft SQL Server 2012-2014 Analysis Services SSAS Training Courses; Birmingham Telford Wolverhampton Midlands Oracle PL/SQL Training Courses; Birmingham Telford Wolverhampton Midlands SQL Training Courses;

Birmingham Telford Wolverhampton Midlands Web Development Onsite Courses: Birmingham Telford Wolverhampton Midlands PHP Training Courses; Birmingham Telford Wolverhampton Midlands JQuery Training Courses; Birmingham Telford Wolverhampton Midlands ASP.NET using VB.NET Training Courses; Birmingham Telford Wolverhampton Midlands HTML 5 Training Courses; Birmingham Telford Wolverhampton Midlands Developing Websites for Mobile Devices Training Courses; Birmingham Telford Wolverhampton Midlands JQuery Mobile Training Courses;

Birmingham Telford Wolverhampton Midlands Project Onsite Courses: Birmingham Telford Wolverhampton Midlands Project 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Project 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Project 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Office Onsite Courses: Birmingham Telford Wolverhampton Midlands Word 2013 Basic Training Courses; Birmingham Telford Wolverhampton Midlands Publisher 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Word 2010 Basic Training Courses; Birmingham Telford Wolverhampton Midlands Publisher 2010 Training Courses; Birmingham Telford Wolverhampton Midlands PowerPoint 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Word 2010 Advanced Training Courses;

Birmingham Telford Wolverhampton Midlands Visio Onsite Courses: Birmingham Telford Wolverhampton Midlands Visio 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Visio 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Visio 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Access Onsite Courses: Birmingham Telford Wolverhampton Midlands Microsoft MCAS Access 2007 Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft MOS Access 2010 Training Courses; Birmingham Telford Wolverhampton Midlands Microsoft MOS Access 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Access Programming Using VBA Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Adobe Onsite Courses: Birmingham Telford Wolverhampton Midlands Flash CS6 Training Courses; Birmingham Telford Wolverhampton Midlands Dreamweaver CS6 Training Courses; Birmingham Telford Wolverhampton Midlands Illustrator CS5 Training Courses; Birmingham Telford Wolverhampton Midlands Dreamweaver CS5 Training Courses; Birmingham Telford Wolverhampton Midlands InDesign CS5 Training Courses; Birmingham Telford Wolverhampton Midlands Photoshop CS5 Training Courses;

Birmingham Telford Wolverhampton Midlands Crystal Reports Onsite Courses: Birmingham Telford Wolverhampton Midlands Crystal Reports 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports 2008 Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports XI Training Courses; Birmingham Telford Wolverhampton Midlands Crystal Reports 2011 Training Courses; Birmingham Telford Wolverhampton Midlands Training Courses;

Birmingham Telford Wolverhampton Midlands Excel Onsite Courses: Birmingham Telford Wolverhampton Midlands Excel 2007 Basic Training Courses; Birmingham Telford Wolverhampton Midlands Excel MOS 2013 Training Courses; Birmingham Telford Wolverhampton Midlands Excel Programming Using VBA Training Courses; Birmingham Telford Wolverhampton Midlands Excel 2013 Intermediate Training Courses; Birmingham Telford Wolverhampton Midlands Excel 2007 Intermediate Training Courses; Birmingham Telford Wolverhampton Midlands Excel MOS 2010 Training Courses;