Developing Google Apps Script – Best Practices

I’ve documented my techniques and best practices in developing Google Apps Scripts.


Google Apps Script to create PDF

This is a little script to create a PDF file using a Google Doc template and the values in a Google Spreadsheet. It take the fields from the active row in the active sheet the script is contained in and using a Google Doc template (identified by TEMPLATE_ID) creates a PDF doc with these fields […]

New release of Rose Task Manager – v0.4.1

Installation Guide – Demo Spreadsheet – Demo Form I’ve just released a new version of Rose Task Manager, a collaborative task manager that integrates Google Calendar with Google Sheets to provide regular task scheduling, plus other features: Now works with new Google sheets. Added Auto-record of start and stop time. When the status is changed to “in-progress” the time […]

‘Sweet’ wrapper for BetterLog

This is a simple wrapper for the Google Apps Script library BetterLog, a logging library that allows you to specify different levels of trace and write them to a log sheet. My wrapper allows you to pass in the function name of the calling function and adds a little synaptic sugar by shortening the function […]

New github repo from local code

Here is a list of git commands for getting a project that you have already started working on locally up onto Github. Here are instructions on forking a repo – getting the first copy of the project your are interested in onto your computer. 1. Create the repo online Create the repo on, along […]

New website finished:

I’ve just finished a sleek new photo gallery website for Lisa Davies, aka Lisa the Teapot, a freelance textile designer in West Wales. Check out the gallery on the front page, where she demonstrates some of the funky things she does with fibres. Her USP is her ‘ole school approach, taking it from plant/animal/mineral all […]

Flubaroo with automatic grading on submit

There is now a beta version of Flubaroo with automatic grading on the form’s submission (autograde). There are still various original features that aren’t working again yet but the autograde code is stable. Please contact me if you would like to get a copy.

WordPress Website – Tasks and Timescales

So you need (want?) a website. Lots of ways to do it aren’t there! Creating one with WordPress is one way to simplify what can be a daunting and time-consuming task. I’ve attempted to simplify it even further by summarising the typical tasks involved and give you an idea of the time and hence the […]

New version of Flubaroo for Google add-ons

The new version of Flubaroo (v12) is out to support the new Google add-ons, the replacement for the Google Script Gallery. Add-ons make Google Apps Scripts available via the Google Chrome Web Store.

Google UK search position tool

Most of the online search position tools are based on the global rather than the UK site, so when I found this spreadsheet that used and allowed comparative searches of different keywords I thought it was worth sharing (and you may have noticed I’m a  big fan of Google Spreadsheets): Good to get […]

Proudly powered by WordPress   Premium Style Theme by