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