Shaun Mccran

My digital playground

15
J
U
N
2011

Creating in-cell drop down lists in Google Spreadsheets

I use Google Docs a lot, especially the Google Docs Spreadsheet format. Recently I wanted to give users the option of selecting one value from several pre-defined values rather than an open field. I thought that the best way to do this would be through a drop down list attached to the cell, but how to do this?

[ More ]

14
J
U
N
2011

Using url rewriting ( .htaccess or httpd.ini ) to block hot linking resources

After my recent move to HostMediaUK I've been able to see more in depth statistics about one of my sites, including traffic and data usage. This also includes having visibility of other domains that are linking directly to my content. This is popularly known as hot linking, and if you haven't asked permission is considered very impolite.

This also uses up your servers bandwidth rather than theirs. This article explores how I use a URL access file, either .htaccess of http.ini depending on your platform, to stop other domains from linking directly to your hosted resources.

[ More ]

11
J
U
N
2011

Backing up your SMS and MMS to GoogleMail from an Android device

I've been using the same Android phone for over a year now, a HTC Desire. Over the last year I've been sending and receiving texts on a frequent basis. My SMS app seems to struggle with the volume of messages it is now holding, over 5000+, so I thought I'd find a way of backing them up and clearing it all out in an effort to speed things back up.

This article explains how I used the 'Backup to Gmail' application to backup all my SMS and MMS messages.

[ More ]

08
J
U
N
2011

Handling Error templates in FW/1

I've been using Framework one for a few smaller scale projects, and during a wrap up session I noticed that I didn't have a global catch-all error page, or any kind of error notification subsystem, like an admin email prompt.

This blog article describes how FW/1 looks for and uses an error handling template.

[ More ]

_UNKNOWNTRANSLATION_ /