# QR Code - Attendee Check-In

**URL:** <https://community.glideapps.com/t/qr-code-attendee-check-in/11549>\
**Category:** Feature Requests\
**Created:** [June 27, 2020, 2:33pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549 "2020-06-27T14:33:57Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\
**Post date:** [June 27, 2020, 2:33pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/1 "2020-06-27T14:33:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Augusto\_Sergio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augusto_sergio/32/5767_2.png) [@Augusto\_Sergio](https://community.glideapps.com/u/Augusto_Sergio)\
**Post date:** [June 27, 2020, 11:53pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/4 "2020-06-27T23:53:15Z")

</div>

You can use a Google API within your spreadsheet.

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

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

---

<div class="post-metadata">

**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\
**Post date:** [June 28, 2020, 12:31am UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/5 "2020-06-28T00:31:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![valerio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valerio/32/5158_2.png) [@valerio](https://community.glideapps.com/u/valerio)\
**Post date:** [June 28, 2020, 8:13am UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/6 "2020-06-28T08:13:41Z")

</div>

googleapis doesnt work

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

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [June 30, 2020, 3:55pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/7 "2020-06-30T15:55:39Z")

</div>

@_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.

> [@QR code scanner demo](https://community.glideapps.com/t/qr-code-scanner-demo/11620):
>
> URL: [https://qrcode.glideapp.io/](https://qrcode.glideapp.io/) 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 crazy_face ) Inspiration was also coming from this thread The app makes use of two scripts (one for pulling…

---

<div class="post-metadata">

**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\
**Post date:** [June 30, 2020, 6:35pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/8 "2020-06-30T18:35:23Z")

</div>

Thanks so much @Krivo !

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 11, 2020, 1:50pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/9 "2020-07-11T13:50:51Z")

</div>

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…

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9af018897eba74c414b0b8ac01057807438ca001.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 11, 2020, 2:02pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/10 "2020-07-11T14:02:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 11, 2020, 2:15pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/11 "2020-07-11T14:15:51Z")

</div>

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=](https://image-charts.com/chart?chs=150x150&cht=qr&chl=)”&G2)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 11, 2020, 2:34pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/12 "2020-07-11T14:34:18Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![valerio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valerio/32/5158_2.png) [@valerio](https://community.glideapps.com/u/valerio)\
**Post date:** [July 11, 2020, 3:35pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/13 "2020-07-11T15:35:30Z")

</div>

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

 ![Schermata 2020-07-11 alle 17.29.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/17c6f3340b4397adc66dec462054ff1fcbff3a14.png) ![Schermata 2020-07-11 alle 17.27.16](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ae5968e1eef9cc7bd148ff06d55cab7a6085a88d.png)

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [July 11, 2020, 5:11pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/14 "2020-07-11T17:11:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![scott74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scott74/32/19575_2.png) [@scott74](https://community.glideapps.com/u/scott74)\
**Post date:** [January 11, 2021, 9:12pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/15 "2021-01-11T21:12:49Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![scott74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scott74/32/19575_2.png) [@scott74](https://community.glideapps.com/u/scott74)\
**Post date:** [January 11, 2021, 9:23pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/16 "2021-01-11T21:23:47Z")

</div>

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.

Thanks

---

<div class="post-metadata">

**Author:** ![scott74](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scott74/32/19575_2.png) [@scott74](https://community.glideapps.com/u/scott74)\
**Post date:** [January 11, 2021, 9:29pm UTC](https://community.glideapps.com/t/qr-code-attendee-check-in/11549/17 "2021-01-11T21:29:48Z")

</div>

Second this
