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.
(1) generate QR code upon user registration
(2) check-in attendee by scanning QR code
You can use a Google API within your spreadsheet.
The code looks like this: = image (“
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
=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.
There a been a number of posts regarding QR code scanner functionality. A native Glide QR code scanner would be very beneficial - so this app is just a kind of workaround.
@Zhijing_Eu made a great presentation earlier on (and I forgot which service he used so I started a search for a QR code decoder myself and ended up with the same as him )
Inspiration was also coming from this thread
The app makes use of two scripts (one for pulling…
@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.
@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!)
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).
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
@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
Interested in video showing how this works also… Would be great if you provide this. Thank you in advance… I have a security company that staffs guards at locations. They want them to checkin. I need to read the code of the qr to pull out the location then store that data in a sheet along with the logged in user / guard how scanned it.
Could you show me how you set this up?
not sure how you are getting the data from the QR code and pasting it in a sheet along with a times stamp and name of the logged in user who scanned it. Is that possible … Need a workaround until Glide implements a seamless one where you don’t have to take a picture.