QR Code Shenanigans


#1

Hello,
I’m trying to create an event check in table. I have it set up right now where they register via a form online in the days leading up to the event. A QR code is automatically generated for them (using their email) and attached to their record via Zapier.

I want to set it up so that when their QR code is scanned at the event it updates a checkbox on their record to ‘Attended’. I’m assuming I need Zapier to do this but I’m not sure where to begin setting this one up. Any tutorials you can point me to would be helpful.

Alternatively, it would be nice if the event manager could scan the QR code into a separate table and have it populate with the information from the registration table (First Name, Last Name, etc.). Not sure if this can be done by lookup/linking.


#2

Hi Cady. I’m new to Airtable, but I’ve found formulas to be extremely powerful so far. I’m not at the point where I can write one for you, but maybe the resources I’ve been using will help you as well. This video about formulas, and this field guide in Airtable Support.
Hope that helps!
:+1: for using Shenanigans in the title :sunglasses:


#3

I think your form would need to create a new record and a barcode for that record. Connect Zapier to trigger on the record creation and use the email address the participant entered into the form to send them an email from zapier with the QR code.

That sounds like a multi step zap, which is a paid subscription.

Good luck and post your results if you get it working, sounds like a great use case!


#4

From what I think I understand here, it sounds like you have a QR code stored in Airtable with each registrants record, and that QR code is sent to the registrant also, which they present when attending to have it scanned.

If that’s the case, when you scan an attendees QR code at the event, what will happen is Airtable will search for and find that registrants record — the QR scanner in the mobile Airtable app is linked to the search bar. Once the registrants record shows, it should be pretty trivial for the person checking them in to just tap on their record to open it, and then tap a checkbox to mark them as in attendance. I’d suggest doing that, as it’s simple, quick, and far less prone to sync errors and issues.


#5

Here’s an example of what that looks like: