AppsScriptPulse

Structure and simplify your Google Apps Script (with) V8

Apps Script now supports the V8 runtime. Time for an update to the story “Structure and simplify your Google Apps Script Apps script”. The V8 runtime brings modern ECMAScript syntax to Apps Script. So we can now use arrow functions and destructuring assignments. No more hoisting with let and const and my personal favorite, template literals.

In this story Jasper Duizendstra shows the added value of the changes made in the constructor pattern using the factory functions. It also shows how to implement chaining and a builder pattern in Apps Script.

Source: Structure and simplify your Google Apps Script (with) V8

Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium

Jasper Duizendstra provides some Google Apps Script coding tips…

Organise your JavaScript objects in Google Apps Script with the constructor pattern by Douglas Crockford.

Source: Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium

Record time and activities with Google Sheets, Calendar and Apps Script

Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started

Source: Record time and activities with Google Sheets, Calendar and Apps Script

Create BigQuery tables with Google Sheets and Apps Script

Creating BigQuery tables using the GUI can be a hassle. This article describes an alternative way to create BigQuery tables

Source: Create BigQuery tables with Google Sheets and Apps Script

Subscribe to Apps Script Pulse...