Going GAS: From VBA to Google Apps Script

Machine generated contents note: 1.Introduction --
What Is VBA? --
Extending --
Fragility --
Security --
Asynchronicity --
Efficiency and Performance --
Maintainability --
What Is JavaScript? --
A Quick History --
Versions --
JavaScript Is Not Java --
Learning JavaScript --
What Is Apps Script? --
Versions --
It Runs on a Server --
Services --
Fully Authenticated Environment --
Quotas --
Performance --
Asynchronicity --
Events --
Triggers --
Web Apps --
Maintainability --
IDE --
What Is Apps Script Good For? --
What Are Google Add-Ons? --
Types of Add-Ons --
Security --
The Publishing Process --
What Are Google Forms? --
What Are Microsoft Add-Ins? --
Comparison --
2.Language Basics --
Style --
Hungarian --
Camel Case --
Case Sensitivity --
Copy/Paste Porting --
Types --
Operators --
Mathematical Operators --
Assignment Operators --
String Operators --
Comparison Operators --
Logical Operators --
Bitwise Operators --
Variables --
Variable Types --
Functions Note continued: Assigning Functions to Variables --
Anonymous Functions --
Functional Programming --
Loops and Iteration --
Layout --
Whitespace and Newlines --
Semicolons --
Curly Braces --
Scope --
Objects --
JavaScript Object Notation --
JSON Examples --
Classes --
Prototypes and Constructors --
Inheritance --
Methods --
A Note on this --
Getters and Setters --
VBA Example --
Using Object.create --
Conclusion --
Namespaces --
Google Services --
Libraries --
Creating Your Own Namespace --
Avoiding Namespace Collisions --
The IDE --
Container-Bound Scripts --
Standalone Scripts --
Code Examples --
Accessing the IDE --
Running a Function --
Examining Results --
Libraries --
Libraries in the Cloud --
Namespaces and Libraries --
Managing Library Versions --
Adding Libraries to a Project --
Some Notes on Library Sprawl --
3.Translating VBA Functions --
Conventions --
Library and Namespace --
JSDOC --
JSDOC Example --
VBA Built-Ins Translated to JavaScript Note continued: Helper Functions --
String Functions --
Conversion Functions --
Math Functions --
Informational Functions and Constants --
Date and Time Functions --
Optional Arguments --
Testing for undefined --
Applying Default Values --
Named Arguments --
Handling Errors --
VBA Exception Branching --
JavaScript try/catch --
Raising an Error --
VBA Built-In Objects --
Type --
Key/Value Pairs --
Collections --
4.Living with the Quotas --
The Quotas --
Daily Limits --
Limitations --
Triggers --
Rate Limits --
Throttling --
Sleeping --
Exponential Backoff --
Splitting --
Libraries --
Batching --
Parallel Running --
Offloading --
Avoiding Service Calls --
Cache Service --
5.The Properties Service --
APIs Versus Built-In Services --
Getting Started with Properties Service --
Uses and Types of Property Stores --
Selecting a Property Store --
The Registry Versus the Property Store --
Comparisons --
6.The Spreadsheet Service --
Custom Formulas Note continued: Container-Bound Versus Standalone Scripts --
Getting Started with the Spreadsheet Service --
A Note About Authorization --
Opening the Active Sheet --
The Range Class --
Creating a Range --
Returning the Data Range --
Getting the Values of a Range --
Writing Values to a Range --
Returning Selected Data --
Reading and Writing for Partial Ranges --
Reading Attributes from a Range --
Writing Attributes to a Range --
Inserting and Deleting Rows and Columns --
Opening Other Sheets --
Iterating All Sheets --
Getting a Sheet by Name or Index --
Opening Other Workbooks --
Creating a Standalone Script --
Accessing Multiple Workbooks --
Working with Multiple Workbooks --
Updating Sheets --
Showing Messages --
Toast --
Showing Messages with Buttons --
Getting Input --
Getting and Setting Properties --
Document, User, or Script? --
Setting Properties in the Registry --
Setting Properties Using the Properties Service --
Changing Settings --
Custom Formulas Note continued: Copy/Paste Port --
Native Port --
Arguments to Custom Formulas --
Performance --
Documentation and Autocomplete --
Adding Functions to Menus --
Tables --
Converting Values to an Object --
Emulating Tables in Apps Script --
ListObject --
7.The Document App --
Opening Documents --
Working with Elements --
Traversing the Document --
Traversing in VBA --
Annotating the Document --
Ranges --
VBA Range --
VBA Discontiguous Ranges --
RangeElements --
The showRange Utility --
RangeBuilder --
Named Ranges --
Setting a Cursor Using a Named Range --
Position --
Position Within Element --
Creating a Selection --
Creating a VBA Selection --
Inserting Text --
Bookmarks --
IDs --
VBA Bookmark Insert --
Bookmark Appearance --
Traversing Bookmarks --
Text Bookmarks --
Creating Links --
Setting a Cursor Position --
Removing Bookmarks --
Editing Text in Elements --
Adding Elements --
Containers --
Element childIndex --
VBA childIndex --
Inserting Elements --
Tables Note continued: List Items --
VBA ListParagraph --
Images --
Docs Automation Example --
Selecting the Target Area --
Inserting the Table --
Adding to Custom Menu --
Attributes --
Text Attributes --
Attribute Equivalence --
Partial Attributes --
Attribute Indices --
8.Gmail, Calendar, and Contacts Apps --
Email Automation Exercise --
Scenario --
Threads --
Searching --
Messages --
Message Filtering --
Regular Expression Searching --
Name Lookup --
Body Errors --
Result Reduction --
Generate a Regular Expression --
Attachments --
Organizing --
Recipients --
Organizing by Recipient --
Sending --
Labels --
VBA Categories --
Calendar --
Events --
The Courses Namespace --
Advanced Calendar Service --
Contacts --
ContactGroups --
Contacts Namespace --
Organizing Courses --
Setting Up the Example --
The Settings --
Triggers --
Apps Script Main Function --
VBA Main Function --
Scheduling --
9.Drive and DriveApp --
Microsoft OneDrive --
Reading and Writing Files Note continued: VBA FileSystemObject --
Apps Script DriveApp Service --
10.HTML Service --
Why Client Execution? --
The Downside --
The VBA Connection --
HTML Service Varieties --
Web Apps --
Dialogs --
Sidebars --
jQuery --
Event Handling --
Templates --
Structure --
Controlling Apps Script from the Client --
Using Namespaces in HtmlService --
Multiple Menu Items --
indexRun.html --
mainRun.js --
Client Namespace --
Render.js --
App.js --
Dialog HtmlService --
HtmlService Web Apps --
VBA User Form --
Create a User Form --
Initialize the Combo Box --
Listen for Changes --
The Form --
11.Content Service --
The Content Service --
Where to Use the Content Service --
Types of Content --
Example --
Request --
Response --
Details --
doGet --
The Settings --
SheetOb --
getFlight --
getRegex --
Initial Result --
JSONP --
XML --
makeXml --
Publishing --
Script Files --
The Publishing Process --
Permissions --
Delegation from VBA --
Querying Apps Script --
12.Charts Note continued: Chart Data --
VBA Charts --
Code --
Sheets Charts --
EmbeddedChartBuilder --
setPosition --
Types of Chart --
Visualization API --
Google Visualization HtmlService App --
Other Chart Formats --
13.Sites --
Apps Script --
Gadgets --
Code Lockdown --
Advertising --
VBA --
The Future of Sites --
14.Advanced Google Services --
What Are Advanced Google Services? --
Advanced Services Versus Google APIs --
Developers Console --
Enabling Advanced Services --
Fusion Tables Example --
Settings Namespace --
Copy Sheet to Fusion --
Fusion Namespace --
Fusion Quotas --
Scripts Structure --
Currently Available Advanced Services --
15.Authentication and Security --
OAuth 2.0 --
Setup --
Access --
Refresh --
Scopes --
Limiting Scope to the Current Document --
Listing Authorized Apps --
Revoking Access --
ScriptApp --
Service Accounts --
Libraries --
OAuth 2.0 Example --
Creating the Cloud Console Project --
Scopes --
Accessing Other Oauth 2.0 Services Note continued: OneDrive Authentication --
Other OAuth 2.0 Services --
OAuth 2.0 with VBA --
Developers Console --
getGoogled --
Content Service with OAuth2 --
Other Kinds of Authentication --
Basic Authentication --
JWT (JSON Web Tokens) --
What Is a JWT? --
Firebase Authentication --
JWT Format --
FirebaseAuth Namespace --
Standardized OAuth 2.0 Process --
16.External APIs and Integration --
REST API --
Code --
Reuse --
Databases --
Firebase --
Main Code --
Permissions --
Settings --
Firebase Class --
Reuse --
Result --
Databases and Apps Script --
17.Execution API --
What Is Incremental Migration? --
Migration Process --
The Execution API --
Inventory for Execution API --
Authentication and Access --
Credentials --
Publishing --
Scopes --
Getting Googled --
JSON --
SheetExec --
Example Workflow Migration from Office --
Moving a Workbook to Sheets --
VBA Code to Read a Sheet --
Apps Script Code to Read a Sheet --
VBA Code to Write Data to a Local Workbook Note continued: VBA Code to Write to a Sheet from a Local Workbook --
Apps Script Code to Write to a Sheet from a Local Workbook --
Migrating Logic --
VBA Code to Initiate Logic on Apps Script --
Logic Code Delegated to Apps Script --
VBA Orchestration --
VBA Process Orchestration Code --
Apps Script Logging Code --
Final Migration Steps --
Testing JavaScript on the PC --
VBA Code to Get Source Code from Apps Script --
Apps Script Code to Return Source Code --
Getting the Source and Testing Local Execution --
Execution API Potential --
18.Office Add-Ins and Google Add-Ons --
Add-Ons --
Add-Ins --
The Same... --
... But Different --
Add-On Example --
The Dataset --
Capabilities --
Apps Script Add-On --
What You Will Learn --
The Namespaces --
Sharing Code Between Client and Server --
index.html --
main.js --
styles.css --
App Namespace --
Cors --
Add-On Script --
Reused Namespaces --
Server Namespace --
Client Namespace --
Render Namespace --
Testing an Add-On Note continued: Office Add-In --
What You Will Learn --
The IDE --
Structure --
index.html --
mainOffice.js --
App.js --
Client.js --
Testing the Add-In --
Result Comparison --
Further Exercises.