QR Code - Attendee Check-In

We need the ability to check attendees in via a QR code. Now more than ever, contactless solutions are important for us given the situation with COVID-19.

Request:
(1) generate QR code upon user registration
(2) check-in attendee by scanning QR code

2 Likes

You can use a Google API within your spreadsheet.

The code looks like this: = image (“https://chart.googleapis.com/
chart? chs = 150x150 & cht = qr & chl = ”& A2)

Reading can be done with any camera. IOS or Android.

@Augusto_Sergio do you know of any videos demonstrating in Glide the functionality I listed above?

googleapis doesnt work

below works
=ARRAYFORMULA(if(isblank(I2:I), “”, (“https://image-charts.com/chart?chs=150x150&cht=qr&chl=”&I2:I)))

@_eric You can have a look here for inspiration. The app probably wont perform as fast as you would like as you have to use a form button.

Thanks so much @Krivo !

Hi @valerio, is this formula supposed to generate a QRCode from an image stored in GSheet?
If yes, it’s great … but I don’t manage to use it…

Delete the double quotes and add them again. They paste incorrectly in the forum.

1 Like

Thanks @Jeff_Hager, in addition to rewriting the double quotes, for my sheet it also required to add the “image” function (surely basic for experts, not for newbies as I am!)

=IMAGE(“https://image-charts.com/chart?chs=150x150&cht=qr&chl=”&G2)

1 Like

Does the image function translate into glide? I’ve always thought of the image function as a way to show the actual image within the sheet and not as a way to show it in glide (which needs a url).

1 Like

The formula was supposed to generate a QR from any data you have in a row for a determinated column in the case column O where I have Row ID

Thanks @valerio, it works well; and indeed @Jeff_Hager you’re right: I was trying to display the QR Code in GSheet at this stage to check that it works well; sorry for the misunderstanding

1 Like