‘Getting Things Done’ with GMail

Overwhelmed by how much you’ve got to do? Want to make some sense of the chaos? Just want to hear about another great use for GMail? Then read on … Having played with various ways of keeping track of my day-to-day tasks over the years (from good ‘ole pencil and paper to the latest smart-phone […]


VeriClock RESTful API Google Apps Script library

VeriClock is a cloud-based employee time tracking system that provides a RESTful API. This library provides a straightforward way to access the VeriClock API from a Google Apps Script. The project id of the library is “Mnek5yp41nP-lNIwpLgcNFtnfWGfgtIUb”. Details of the API requests that have been implemented can be found in the libraries’ documentation. VeriClock API Docs Source code in […]

High-res terrain generator in Google Sheet!

You can see the terrain image in this spreadsheet. Having just released the Color Scale Add-on I was having a play around with a terrain generator and created this (fairly) high-res terrain in a Google Sheet! The terrain generation script is based on Hunter Loftis’ “Realistic terrain in 130 lines”, and just took a little tweaking to […]

Google Sheet Color Scale Add-on – v2 released

Ever popular in the Script Gallery, Color Scale is now available as an add-on in the Google Web Store for adding to your own Google Sheets. The Color Scale add-on for Google Sheets sets the background color of the cells in a selected range according to their numeric value. This is similar to the ‘color […]

Rose Task Manager – Google Apps Add-on Released

Rose Task  Manager is now available as a Google Apps Add-on in the Google Web Store! Rose Task Manager lists tasks in a Google sheet, use Google calendar to schedule regular events and send various emails notifications. You can read more about it here.

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 github.com, along […]

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com