findURL – Custom Google Function Fun

via the magical XKCD Fun being a fairly relative term . . . but I’m amused. The Meat You can write custom functions in Google Spreadsheets and then use them like other built in functions. I didn’t realize that. The script below1 grabs all the URLs from a chunk of text. You could add it […]

Read More… from findURL – Custom Google Function Fun

Documentation – Google Doc Drawing Tip

I’ve created documentation in lots of platforms with lots of people over the last 15 years. These attempts tend to fail, or fail to thrive, for a variety of reasons. I can’t address all of the human factors but I can look harder at a few of the mechanical ones. Here are a few of […]

Read More… from Documentation – Google Doc Drawing Tip

Embed Collector Tool

Some people don’t have websites handy or their blogs won’t allow iframe embeds. They should still be able to have their students do stuff and get it all in one place. This is the Internet! And this tool is meant to deal with that. You can see a working example with three submissions (via a […]

Read More… from Embed Collector Tool

Angular and Google Sheets JSON

flickr photo shared by Kecko under a Creative Commons ( BY-ND ) license Man. This was a slog and really highlighted gross inadequacies in my conceptual understanding of pretty much everything. That being said, with an end-around, it works. The whole thing is below but there were really two pieces where I got stuck and […]

Read More… from Angular and Google Sheets JSON

Fridge Poetry – Google Sheets as Database

Back in 2013 I built a refrigerator poetry page using javascript. I really wanted to make it so anyone could add any words they wanted in some easy way but didn’t have the skills to do that at the time. It’s been hanging out in the back of my mind since then and the bits […]

Read More… from Fridge Poetry – Google Sheets as Database

Weekly Web Harvest (weekly)

Podcast: the only way to get evidence-based policy is to embrace ambiguity in science / Boing Boing “The reality is that, in the world of science and research, the “truth” is messy, and evolving. There’s this moment in an interview that every researcher dreads: “Yes, Dr Knowitall, but are you certain?” But researchers say to […]

Read More… from Weekly Web Harvest (weekly)