Change from project key to scriptid
The Apps Script Script service is deprecating the getProjectKey() method. At this time it’s not clear when or why, but…
What I’ve learned from my first play around with BigQuery/Sheets integration
So this just happened. BigQuery integration with Sheets!. This is great; now you can use a spreadsheet as a federated…
Targeting training material for Google Apps Scripters
Google Apps Script is the script language for Google Apps. If you are an Office user, think VBA, but in…
A belated post – 2015 – a year in Apps Script
I’ve more or less stopped using blogger this year – looking back I’ve only made 6 posts since my end…
Null should mean something
It’s a common pattern in JavaScript to do this to assign a default value to a variable : var theThing…
Running JavaScript directly from Excel makes ‘going Google’ easier
I’ve been dong a lot of writing over on Desktop Liberation looking at techniques to run Apps Script/JavaScript code directly from…
GitHub and VBA integration
If you develop shared code for VBA, you’ve probably got some massive workbooks that contain multiple projects that you wish…
Some best practise notes on DbAbstraction usage
Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million since…
First shot at Polymer
I’ve just completed my first Polymer app and have mixed feeling about the experience. Regulars to this blog and the…
A year in the desktop liberation blog
I posted the other day in A year in apps script and my bucket list my take on what happened in the…
A year in apps script and my bucket list
2014 has been an eventful year for Google Apps Script with some great new capabilities arriving (add-ons), as well some…
Google Apps Script locking and optimum wait times and the golden ratio
You are probably familiar with the Google Apps Script Lock Service, which is a way of preventing concurrent access to…