Google Scripting + QR Codes = Awesomeness

Todays post came from a comment from a reader who asked about inserting QR codes into Google Spreadsheets. There are a few things that this can be used for such as ticketing for an event, etc. Its not exactly what the reader asked for but its a step in the right direction. Screen Shot 2013-06-24 at 3.12.35 PM

Below you will see the end result of what we are doing:

Screen Shot 2013-06-24 at 3.13.23 PM

So after some time playing with the URL and encoding (reference here: http://www.w3schools.com/tags/ref_urlencode.asp) I found that I could bring in values from different columns and insert them into a QR code.

 

All we are doing in our cell is using the =image formula and making a call to the chart API (https://developers.google.com/chart/ )

 

Here is an example of what we are doing:

Api Call:

=image(“http://chart.apis.google.com/chart?chs=150×150&cht=qr&chl=Name%3A%20″&A2&”%20″&B2&”%20DOB%3A%20″&C2&”%20Notes%3A%20″&D2&””)

 

You can find the example spreadsheet here: https://docs.google.com/spreadsheet/ccc?key=0At-tnrDq1KRmdGdISXZrZ0dHQW9fMlRQNmxaNXdmMVE&usp=sharing

 

TJ Houston

TJ Houston is the Director of Technology at Shelby City Schools and New London Local Schools for Epiphany Management. TJ leads professional development in all areas of technology and loves developing ways to make teachers, students, and staff's lives easier with the use of technology. TJ also loves photography and his portfolio can be found at http://www.tjshots.com. All of the views on this site are his own.