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:
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