Enable Technology

Web Development 

Google Script Programming




Course Overview


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

Duration: 3 day course



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






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in 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.




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

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;