Category: GDE

TAGSPresenter (alpha) – A Twitter/Google Sheets based presentation concept

Update: Didn’t go well but revised version on this I’ve used successfully is here and slides published here. Later today (2.30pmUTC) I’ll be presenting at #oer15 about Twitter in open education (tune in here). As I wanted to highlight the network effect of Twitter I wanted to engage not just the room, but leave ‘footprints’ […]

Google Sheets: Move a row of data to another sheet based on cell value

There was a question that came up in the Google Apps Script G+ community about moving a row of data to another sheet. In this post I look at how to solve this for Google new Sheets
3 Comments

Tutorial: Interacting With Your Google Drive with Apps Script (including parsing/writing .csv files)

A question came in on the Google Apps Script Google+ Community which in part was asking about parsing .csv files into a Google Sheet. I intially pointed the asker to some dated documentation so for my penance have updated it.

Revisiting issuing Mozilla Open Badges with Google Apps Script and Google Sites: Notes on new options

Back in 2012 I shared some of the exploratory work I did issuing Mozilla Open Badges with using a combination of Google Apps Script and Google Sites. I revisit this idea with new knowledge of the Mozilla Issuer API

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.

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
One Comment

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
One Comment

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
2 Comments

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.
One Comment
« Previous Page — Next Page »
css.php