“QR Code Access Card” is our Google Sheets™ addon that makes it easy to register people to events, then check their registration or record their participation to various activities, using QR codes.
Install addon
Post-install tips
Frequently asked questions
Privacy policy
Terms of use
Check out our QR code pass extension for Google Forms™
Usage
The initial (Configuration tab) page of the addon is used to setup the sheet where you have your event registration data. It is expected to have headers on the first line, and a line for each attendee.
When you initialize the addon with the sheet containing your attendee data, it will transparently configure an app on our QR code tracking platform for you. This step is based on the columns on your sheet, so make sure your attendee data has all needed columns, and some attendee data, before using the addon.
From the Dashboard tab, you can click on “Generate QR codes” every time you add new attendees, and tracking columns will be automatically filled for you. One will link to the QR pass for this attendee.
From the same Dashboard tab, you can scan any QR code pass to check or track every attendee. Scanning is easier from a smartphone (though you can use your laptop with a camera too). The addon will display a QR code for each action. Scan that code from your smartphone and follow the link to have access to your QR pass scanner ou lookup page.
You can scan a group of QR code passes, by showing them to the camera one after another, in quick succession. For the default check-in, you don’t need to enter any additional data. Currently, the title on QR passes is derived from name fields in your form, and the subtitle is the attendee email. These (and the design) can easily be changed on request.
You also have access to several reports (people registered but not checked in, people checked in, etc.), which you can export to Excel. You can also download all QR passes here, if you need to print them for your attendees (though you can directly scan the PDF on their phone to avoid printing).
This service is free for less than 20 attendees. Please reach out for more responses or for any custom data collection configuration.
For pricing information, please consult the addon description on the store or reach out.
Post-install tips
Make sure you already have a sheet with some attendee data, with headers on the first line, then select that sheet in the configuration to setup QR code pass generation.
Labels on the QR code pass PDF will be automatically build from questions with “name” in their title, or the first question in the form.
After initialization, click the “Generate missing attendee codes” to test QR pass generation, and click the links added to the sheet to download the pass.
Frequently asked questions
How do I add other staff to help validate passes or record attendance?
Use management is not yet integrated in the addon, but supported by the underlying platform. Please get in touch and we’ll activate it for you.
How do I record attendance per event session?
The default configuration only records one type of attendance, but you can do so much more! Advanced configuration is not currently exposed inside the addon, but you can reach out and we’ll do it for you quickly.
How do I customize the design of the PDF QR code ticket?
Your QR title and subtitle will use default settings derived from attendee data sheet. Those defaults might not suit you though, either because you prefer static text, or data from different fields. Until this setting is exposed inside the addon, you can reach out and we’ll handle it for you. This also applies to custom logos on the PDF, or completely custom designs.
How can I get attendance data in Google Sheets?
Once you generate QR code tickets, the add-on provides adds a special column that loads check-in status for each row. This is refreshed every time you open the spreadsheet.
How do I add a shortcut for the validation camera on my smartphone’s homescreen?
You can use “Install app” or similar from your browser’s menu, or click the “Android app” link at the bottom of the page.
Terms of use
By using this addon, you agree to:
- Let us collect and use attendee data from your sheet to generate QR code passes and track attendance.
- Keep the attribution on generated QR passes, unless explicitly authorized to remove it.
- Understand that the addon is provided as is and we are not liable for any damages.
- Contact us with questions.