I really love QR codes. It makes reporting work requests fast and easy. I'm also a little OCD and really like to customize everything more than the average person. Limble does a great job of providing QR codes and lots of options for customizing them but sometimes I just want to do a little more than I can within their customized print center.
That's where Avery Design & Print comes in. I've been using them to create unique and custom QR codes and it's been scratching the itch to get things designed the perfect way.
Getting Started
Once you get to the website you'll need to click on "Start your design" and the create an account (totally free) so you can store your projects. Then choose a template size and style. I usually start with a blank one or copy from another project I've already created to save time.
Getting the Data Imported
Now it's time to add in your data from Limble. You can export data from assets, parts, PMs, etc. but I suggest pulling the data from the QR code page so you can easily add QR codes to the new labels.
Now take that excel spreadsheet and add it to the Avery template using the "Import Data" option on the left hand side.
NOTE: There is a max of 20 columns and 2000 rows so you will likely need to remove some of the columns and maybe some rows. Keep any data that you want to put on the label but remove the rest.
Make sure you keep "Work Request Portal URL" and "Asset Lookup URL" if you want to add QR codes to the label.
Next, you'll choose which fields you are going to use. Make sure you uncheck the first row (assuming it still has the headers on it from the export file).
Hit "next" and add the fields you want to display. Mess around and try adding a bunch of fields to see how they display. You can always come back and remove them later by going back to the import data selecting "Choose Fields". Once you are done hit "next" and then "Finish".
Customization Time!
Customize the fields to help it stand out. You can use the navigator on the right hand side to move around to different labels to see how they look. Adding bold, underlined, or color to the text can make the labels stand out. You can also realign the text and change the size.
Add In Some QR Codes
Now let's add a QR Code. On the left hand size choose "QR and Barcodes" and click on "Add QR/Barcode". Choose "Spreadsheet" and hit "Next". Choose the same spreadsheet you just used for the import earlier. Make sure to uncheck the first row again if it contains headers. Once you get to "Create barcodes" change the settings to what you see below.
Industry Standard Format: QR Code
Code Type: URL
Website: *This is where you will drag and drop either the "Work Request Portal URL" or "Asset Lookup URL".
Click "Finish" and boom chow. You got your customized QR Code label! Resize it and move it around to make it look nice. Keep editing it to make it look even better. Adding a company logo is a great example.
PRO TIP: If you are having trouble choosing between which of the two QR codes you want on the label then don't choose. Add both!
Got a cool idea you came up with? Add it to the comments so others can see ideas for QR Code designs.
