Latest content

Looping through files in a directory

Here’s an alternative snippet for how to iterate through a collection of files. Lets say we want to look at…
Read More

Ramblings blog

Read More

Use a spreadsheet as a database in 5 minutes

This tutorial will get you started with Database abstraction with google apps script and show you how to write a small app…
Read More

2019 – a decade in Apps Script

I usually do an annual post on what’s been going on in the world of Apps Script, like this one but…
Read More
4 Replies

2018 – yet another year in and out of Google Apps Script

For some years now I’ve been writing this annual summary around Christmas time, on how my year in Apps Script…
Read More

Apps Script Back end platform – some thoughts on a different approach

Apps Script runs on Google Servers, probably the Rhino JavaScript  engine running on Google App Engine. Rhino is written in…
Read More
1 Reply

Is it still worth creating blogposts ?

I’ve considerably cooled on the whole blogging thing over the years, preferring to post either to G+ communities, github, to…
Read More

How about free VMs for Chromebook owners?

I’ve been using a Chromebook for a few years now, and find myself going for long stretches without needing to…
Read More

2016 – Another year in Apps Script

  2016 The real world of 2016 has been full of madness, badness and sadness. It’s impossible to reflect on…
Read More

App Maker – Build engaging custom apps on G Suite with minimal coding

What is App Maker App Maker provides a ‘low code’ way to create professional looking G Suite custom apps without…
Read More

Using an Apps Script webapp to distribute assets

I wasn’t completely satisfied with the distribution method for the assets associated with my first Apps Script book and subsequent video…
Read More

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…
Read More

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…
Read More

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…
Read More

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…
Read More

Null should mean something

It’s a common pattern in JavaScript to do this to assign a default value to a variable : var theThing…
Read More

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…
Read More

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…
Read More

Some best practise notes on DbAbstraction usage

       Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million…
Read More

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…
Read More
1 2 3 12
UA-153666997-1