At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting […]
In this post I’ll show you how to make a searchable Twitter contributor map like the one below in a couple of clicks, however I feel it’s my duty to educate you first…
There are various techniques for automatically distributing these using Apps Script and in this post I’m going to highlight one method for emailing inline charts.
At the Association for Learning Technology (ALT) one of the core tools we use for membership management is CiviCRM. In this post I show you how we use Google Apps Script to automate reporting and analysis
At ALT we use Google Sheets as an easy way to share and collaborate on draft event timetables. Recent examples are the ALT Annual Conference 2014 and the OER15 timetables. […]
Basic little Google Sheet template for generating download links of new Google Sheets in different formats including pdf, csv and xlsx
My old colleague at Cetis, David Sherlock, posted a nice little ‘Twitter Question/Revision Bot’. This uses a .csv file of questions and multiple choice answers which get randomly tweeted out […]
You can imagine the scenario, you’ve got a Google Form perhaps setup as a booking form and a select option for picking timeslots. As the slots fill up you’d like the option to be removed. I was surprised not to find an example of this so here is a rough sketch of some code that might do the job
A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists
You’ll find lots of blog posts explaining how to do this the other way, converting a table from Wikipedia into a spreadsheet. This post looks at taking a .csv or a spreadsheet and formatting it as a Wikipedia table.