Notes on feature request to access Fullscreen API in Google Apps Script

Recently I was trying to get full screen access in Google Drive using Google Apps Script and I couldn’t get it to work resulting in this feature request. In this post I want to share some of my thought processes and highlight why this would be a useful feature.

Protecting your self hosted WordPress from threats and securing with https/SSL for free with CloudFlare

My experiences of setting up and using CloudFlare to deliver a self-hosted WordPress blog over SSL

More Library Mashups: OpenRefine(ing) and Visualizing Library Data

I’ve a couple of book contributions in the bag. My latest output is my first solo effort in More Library Mashups, edited by Nicole C. Engard. The chapter, ‘OpenRefine(ing) and visualizing library data’, is a work up of one of the posts I released as part of the UKOER Visualisation Project on extracting and visualising repository data from Jorum.

Dynamically remove Google Form options after they have been selected by someone or reach defined limits

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

Allow anyone to add videos to a YouTube playlist from a Google Form using Google Apps Script

A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists

[Repost] Putting a pin in a map: Mapping evidence from OER Research Hub surveys

A repost of guest post on OER Research Hub on November 24th, 2014 As part of the OER Research Hub the community has been asked to respond to surveys examining OER awareness and usage. This has been done using the online web service SurveyMonkey. One of the features of SurveyMonkey is to record additional information […]

Google Apps Script: The authentic{ated} playground (3 things that make Apps Script rock) #DevFest

I was recently invited to London to talk at the GDG DevFest London. As part of the ‘authenticated playground’ I highlighted 3 core features of Google Apps Script

Converting .csv or Google Sheets into Wikipedia tables

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.

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.

TwtrService: A Twitter API client library for Google Apps Script

The TwtrService library for Google Apps Script centrally stores your Twitter access details allowing them to accessed from multiple script projects without the need for re-authentication. This post outline usage of the library.

Next Page »