Open this link and add the add-on to Google Spreadsheets.
2015-12-24 - Version 1.1
To create QR codes from values in a sheet select a single cell.
Or multiple cells in a column.
Selected range can contain empty cells. Those will be skipped.
Or the entire column.
Values in the selected cells will be encoded into QR codes.
Size of QR codes in pixels.
IMPORTANT: If you want to encode long values make sure you select larger size as QR codes have certain character limitations. For example if you want to encode 100 characters into a QR code of Tiny size you will get an empty image as it is not possible to encode so many characters into such small size.
When checked add-on creates new Google Document and inserts QR codes into the document. Use this option if you need to print out QR codes.
Following table displays number of QR codes per row for each size.
When checked add-on draws border around QR codes.
NOTE: This option is available only when the option Create Document is checked.
When checked add-on saves QR codes as PNG files in a folder. Use this option if you need to work with QR codes in graphical format. For example you need to send it to your graphic designer or include on a website.
TIP: You can easily download all PNG files in a ZIP archive. Select the folder and choose the Download option in Google Drive.
When this option is checked you have to select range with two columns. Values in the first column will be encoded as QR codes. Values from the second column will be inserted below generated QR codes in Google Document (if option Save as Document is checked) or will be used as filenames for PNG files (if option Save as PNG is checked) or both.
NOTE: If the selected range contains empty cells entire rows will be ignored.
Resulting QR code contains value from first column and label from second column.
If enabled URLs in selected range will be shortened using goo.gl service. This is particularly handy if you want to encode long URLs into QR codes. These long URLs will be converted into short URLs which contains less characters and QR codes are then faster to scan.
Furthermore, you can login to goo.gl service and see how many times each shortened URLs was clicked. In other words how many times each QR was scanned.
To generate QR codes either option Create Document must be checked or option Save as PNG or both. Then the button GENERATE is enabled and you can start the process. When the process is over you can open created document or folder.
IMPORTANT: Keep in mind that generating a single QR code takes a few seconds. If you select many values the process might take several minutes to finish.
If you want to cancel generation of QR codes just press the CANCEL button. This button is available if you select more than five values.
Currently there are following limitations in place:
This section is for users of Mobile attendance solution. Customers can easily and quickly create employee ID cards.
To create ID cards for employees you must select a row with exactly three columns where the first row is the ID of an employee, the second name and the third value is surname,
Or multiple rows.
You can select a range with empty rows. Empty rows will be skipped.
Rows will be skipped also if: