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.
Below you will see the end result of what we are doing:
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:
You can find the example spreadsheet here: https://docs.google.com/spreadsheet/ccc?key=0At-tnrDq1KRmdGdISXZrZ0dHQW9fMlRQNmxaNXdmMVE&usp=sharing
Find Me Online:
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.