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 […]
I have repurposed Amit Agarwal’s GSheet for India for use with Welsh regional data. Amit’s website describes how his work’s behind the scenes. The main difference is mine uses the data put together by Tom White for UK cases who […]
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.
A common question I get asked when people are merging values from a Google spreadsheet into a GDoc and/or PDF is how to format the values. So I have written this formatString() function. For example if you wanted to use […]
An exciting day for all us Apps Script devs: Google have finally replace the Rhino JS engine with the V8 used in Chrome and Node.js! So we can now use all those funky new features. If there is not a […]
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 […]
There have been a few interesting new resources pop up recently: “The G Suite Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with G Suite Developer technologies. These samples showcase different ways to […]