I’ve documented my techniques and best practices in developing Google Apps Scripts.
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 […]
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 […]
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 […]
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 github.com, along […]
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 […]
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.
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 […]
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.
Most of the online search position tools are based on the global google.com rather than the UK site, so when I found this spreadsheet that used Google.co.uk 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 […]