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 […]
A new version of the Google Apps Script quiz grader/marker, Flubaroo v3.1, has just been released. I’ve added the ability to grade numeric answers within a specific numeric range, rather than only accepting a single value. Useful when you are only looking for an approximate answer, say when looking for the longitude and latitude of […]
Color Scales Spreadsheet The Google Apps Script contained in this spreadsheet sets the background color of the cells in a selected range according to their numeric value. This is similar to the ‘color scales’ or color gradient feature in Microsoft Excel. The lowest number found in the selection is set to the low color, the […]