Ever needed to merge two similar datasets and automatically get rid of any duplicates? This article describes how to do that using the SsObjects Google Apps Script library. And if you are just looking for a solution without taking […]
This GDrive folder contains a great video demo of how Alex Ivanov has set up his environment to develop Google Apps Script offline using Visual Studio Code, the Clasp script and this boilerplate.
I have done a write-up of the various ways the functionality of a Google Apps Script can be shared/published/deployed.
Unfortunately we don’t yet have our own npm in Google Apps Script 🙁 Although there have been efforts to pull together all those Apps Script libraries that are out there, nothing seems to have ever stuck. So this is […]
Apps Script guru Bruce McPherson has produced an excellent summary of some of the latest developments in 2018.
There are a lot of videos like this out there, but I particularly like this one and its emphasis on Agile as a set of beliefs…
Here’s a writeup of a GitHub work flow for multiple devs with various tips and tricks we’ve picked up along the way. What do you think? It is a little prescriptive, but they are all things I’ve found useful, just […]
This script automatically emails the submission from a Google Form as a PDF. The PDF is created by populating a Google Doc template from the values in the Google responses spreadsheet. Further to user requests, I have created many variations […]
I had an interesting question from a client recently about why should they pay my full rate (I charge hourly) for bug-fixes when they are my mistakes? Here is my response where I argue that bugfixing is an integral part […]
