Jun
25
2013

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

 

Related Posts

About the Author: 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.

  • http://www.trendmatcher.nl/ trendmatcher

    Just great! Next challenge will be to get the QR code as an image into the PDF document.
    Your RSS feed is on top in my reader;-)

    • http://www.tjhouston.com/ TJ Houston

      Thanks for your kind words. I am working on a solution :)

Find Me Online:

About Me:

My name is TJ Houston.
I am the Director of Technology at Huron City Schools. I love integrating technology into the classroom and helping teachers find the way on the information super highway. Things I love: My family, My awesome Girlfriend, Technology, Education, and Photography.

I run PD sessions twice a week and run community training the first Saturday of the month. I love teaching people new things.

Best School Admin Blog

Nominated for Best School Admin Blog

Facebook Friends

Sponsors

Classroom 2.0

Presentations

Presenter Badge
diigo education pioneer

Friends