Monthly Archives: February 2015

Google Calendar and SMS

For those with a smartphone there are plenty of ways to sync your calendar and access other Google apps. There are still one or two Luddites like me though, who prefer an older-style mobile / cell phone to a smartphone; it’s usually smaller, with a longer battery life, it’s less likely to be stolen or broken and, even if that should happen, it’s a negligible cost to replace it. more

Protect Spreadsheet Ranges in Google Apps Script

In a recent post I described how Google have extended the capabilities of range protection in spreadsheets. They’ve also made it possible to protect ranges in Google Apps Script by means of the new Protection class.

Usage is pretty straightforward, and code samples probably serve better than written description. Here’s how to protect a simple range:

// Protect range C1:G10
var ss = SpreadsheetApp.getActive();
var range = ss.getRange('C1:G10');
var protection = range.protect().setDescription('This is now a protected range');

The object stored in the variable I’ve called protection now represents my protected range, and I can manipulate it directly in code.

First want to set up who are the editors for it, starting with myself:

var me = Session.getEffectiveUser(); protection.addEditor(me); more

Spring Cleaning Google Drive

In this previous post I discussed managing your Google Drive storage. With spring just (I hope) around the corner, now seems a good time to do a little spring cleaning.

Items you’ve deleted go into the Bin (I believe it’s called Trash in accounts set to US English) and their number can build up alarmingly over time. To see what’s in there, click on Bin in the Drive menu: more

Open Google Contacts Page in its Own Tab

I find it a minor irritation that when I’m working in Gmail, and need to consult my contacts list, there’s no straightforward way to open it in a new browser tab. You can get to the Contacts item in the drop-down menu easily enough (as in the figure below) but right-clicking on the item doesn’t offer the option to open the page in a new browser or tab. more