Tag: how to

Posts tagged how to

Sort a Google Sheet with Vertically Merged Ranges

This is a quick tip, but if you've ever tried to sort a sheet with vertically-merged rows, you've probably been disappointed. Here's an example: If... Read more

Handling Paginated API Responses in Google Apps Script

One of my favorite things about Google Apps Script is that I can get information from an API and write it directly to a shared document or spreadsh... Read more

Unit Testing GAS Part 2: Simple Tests

If you're brand new to unit testing, start with the first post in this series to get caught up. Part 1: QUnit Setup Part 2: Simple Tests Part 3: Ad... Read more

Mask Text in Keynote on the iPad

Keynote has image masking built in. Masking allows you to more or less shape a picture in a frame. A simple example would be showing a portion of a... Read more

The Boot Loop Returneth

I have an aging Macbook Pro. It's older than my children and starting to show it's age. Before I remove Mac OS and replace it with Linux, I'm tryin... Read more

Running arbtt on Mac OS

Tom Woodward has a semi-regular weekly roundup blog post with links to interesting things he finds on the Internet. A couple weeks back, he posted ... Read more

Reclaiming Jekyll

In December, I moved off of WordPress to Jekyll. This is easy to do with GitHub Pages, but I wanted to self-host because keeping a SSL certificate ... Read more

Moving from WordPress to Jekyll

This is a long post in several parts. Jump to different sections using the links below. Introduction Exporting WordPress Hosting Comments Updating ... Read more

Building a Custom Registration Form with Google Apps

One of the main responsibilities my team has is offering and running training on a number of resources teachers in the district have access to. The... Read more

Easily Filter Large Data Sets in Google Sheets

I use Google Sheets in my classroom a lot. I used to rely on combinations of the vlookup, importrange, and index/match functions to get information... Read more

How To Get Text Messages into Google Form Responses

Continuing on my data collection and analysis streak, I’ve got a little project to throw out into the wild and see what happens. Student response s... Read more

Making Endnotes from Footnotes

**Update 12.22.2016** Since this has become quite a popular script, I’ve converted it into a Google Docs Add On so it can be used across documents.... Read more

Making Sub Plans Easier

I hate missing school. It’s stressful. I have to do multiple days worth of planning ahead of time, plus know what’s happening the day I get back. T... Read more

How To: Find Emails You Haven’t Replied to in Gmail

David Wees asked a question on Twitter today that I thought would be pretty easy to solve: @bennettscience I probably read the email though. In fac... Read more

More Attribution Done Just for You

I’m expanding on a post I wrote a week or two ago in which I added automatic Flickr attribution to header images on the blog theme I’m working on. ... Read more

If You’re Not Going to Use Attribution, I’ll Just Do It For You

It’s important to use attribution online. When you pull a picture, make sure you tell other people where it’s from. Some sites make it easy for you... Read more

How To: See Any Site as it Appears on Mobile

I was working on a Chrome Extension (feel free to download and use it) this evening and I noticed something awesome. If you right click on a webpag... Read more

Animate (SOME) of the GIFs!

Not all GIFs are created equal. Some just need a little help. I haven’t posted more than once in a day in a while, but I’m really excited about my ... Read more

Experimenting with Pictures

I have a permanent item on my to-do list which says, “make pictures better on the blog.” I don’t really know what that means in the long run, and t... Read more

Google Voice Search Coming to Chrome

I’ve been ensconced in Chrome lately. I worked with the team at TechSmith who brought Snagit to Chrome and now, I’m researching different ways to m... Read more

How to: Efficient Account Management in Chrome

This post has been on the back burner for a long time, but I finally have a little time to sit down and finish it. I use Chrome exclusively. There ... Read more

How To: Create a Custom Callout in Camtasia

When the Camtasia Mac update came out a few years ago, I was intrigued by the new sketch motion callouts included in the media. Essentially, they’r... Read more

How To: Use IFTTT to Crowdsource Conference Photos

A year ago, I discovered If This Then That (IFTTT), which might be one of the most innovated web services I’ve ever come across. Ever. In short, it... Read more

How To: Manage Hangouts On Air with Google+

I’ve been diving into Google+ a little bit more lately, and this is stemming from some of the experimenting I did yesterday, when I posted how to r... Read more

How to: Record Google Hangout in High Quality

I’m working on a super-secret project right now (more to come this summer…bear with me) which will require me to record interviews via Google Hango... Read more

Screencasting on Chromebooks

Update 7/2/2015 – An older update (this news came out a few months back) but it’s worth noting that some Wacom tablets are now supported on Chromeb... Read more

Get in touch

Comments are always open. You can get in touch by sending me an email at brian@ohheybrian.com