Give every asset in your inventory its own QR code, from the asset list you keep in Google Sheets. Every time a row is added, this template: - creates a static QR code in CodeQR that opens the row's URL - names it with the row's Asset Tag and Asset Name, so you can find it in your CodeQR dashboard - writes the QR code's ID and a link to its PNG image back into the same row Set up the sheet with five headers in row 1: Asset Tag, Asset Name, URL, QR Code ID, QR Code Image. Fill in the first three and leave the last two empty. Static QR codes are unlimited on CodeQR Pro and above. On Free and Starter they count toward your monthly QR code limit. When you turn the scenario on, choose "All" to process the rows already in the sheet, or "From now on" for new rows only. Apps used: Google Sheets, CodeQR This template was created by CodeQR. Learn more at https://codeqr.io
This is a predefined template that will make the creation of your scenario much easier. Of course, you can always expand and customize the scenario to meet your own individual needs.
Google Sheets
CodeQR - Link and QR Analytics