Google Apps Script – File Clone
This little script makes a copy of a list of Google Drive files in a Google Sheet in a folder called “Cloned Files”. You can get a copy by clicking on this link. You can see the script in Extensions […]
Category: Software Development
Merging two 2D arrays/datasets/tables with Google Apps Script
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 […]
Screencast of developing Google Apps Script offline
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.
Comparison of Ways to Share a Google Apps Script
I have done a write-up of the various ways the functionality of a Google Apps Script can be shared/published/deployed.
Google Apps Script Library Database
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 […]
A year (mostly) in Google Apps Script
Apps Script guru Bruce McPherson has produced an excellent summary of some of the latest developments in 2018.
What is Agile?
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…
Google Apps Script Dev Flow with GitHub
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 […]
PDF Creator – Email form submission in a PDF
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 […]
Why should I pay for bugfixes?
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 […]