# QR code scanner demo

**URL:** <https://community.glideapps.com/t/qr-code-scanner-demo/11620>\
**Category:** Community Resources\
**Created:** [June 28, 2020, 1:54pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620 "2020-06-28T13:54:37Z")\
**Posts on this page:** 13\
**Page:** 2

<div class="post-metadata">

**Author:** ![Fredibu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fredibu/32/15200_2.png) [@Fredibu](https://community.glideapps.com/u/Fredibu)\
**Post date:** [October 22, 2020, 8:21pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/22 "2020-10-22T20:21:55Z")

</div>

With the fonction **template** i used your url to create a free QrCode generator 😊

> **[QrCode Generator](https://qrcodegenerator.glideapp.io/)**

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [October 23, 2020, 3:02pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/23 "2020-10-23T15:02:43Z")

</div>

Nice ! I found another site which actually gives you a link to the generated QR Code, so that I don’t have to worry about storage of the code… [https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=YOURQRDATA](https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=YOURQRDATA)

---

<div class="post-metadata">

**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\
**Post date:** [January 20, 2021, 3:56am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/24 "2021-01-20T03:56:41Z")

</div>

I was tried @Killko solution. It’s work on google sheets.  
 ![Screen Shot 2021-01-20 at 10.54.03 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/870f9ac9854c053ba23d61e3651a3828b8bfa35f.png)

But I can’t display it on the app.

 ![Screen Shot 2021-01-20 at 10.55.06 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc18b0c976a91cecb395c2854a38821b94e5f946.png)

How can you do that? @Fredibu

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 20, 2021, 4:13am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/25 "2021-01-20T04:13:57Z")

</div>

Seems like you’re using an image formula in the Sheet. You would need an actual link (without the image function) for Glide to read and display it.

---

<div class="post-metadata">

**Author:** ![PaulVu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paulvu/32/14973_2.png) [@PaulVu](https://community.glideapps.com/u/PaulVu)\
**Post date:** [January 20, 2021, 4:28am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/26 "2021-01-20T04:28:56Z")

</div>

Awesome. Thank you alot.

> **Formula**
>
> =ARRAYFORMULA(IF(E2:E="","",“[https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=](https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=)”&F2:F))

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [January 20, 2021, 10:54am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/27 "2021-01-20T10:54:42Z")

</div>

Hi @PaulVu, my initial way didn’t display because the google api gives you an image rather than a link to the QR Code. I found another QR Code api that works like a charm…  
Change :  
=ARRAYFORMULA(IF(E2:E="","",“[https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=”&F2:F](https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=%E2%80%9D&F2:F)))  
to  
=ARRAYFORMULA(IF(E2:E="","",“[https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=”&F2:F](https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=%E2%80%9D&F2:F)))

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 20, 2021, 11:51am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/28 "2021-01-20T11:51:21Z")

</div>

You can also generate QR codes using [quickchart.io](https://quickchart.io/documentation/#qr)  
Rather than using an arrayformula in the Google Sheet, I’d recommend using a template column in Glide. ie. something like this:

 ![Screen Shot 2021-01-20 at 7.50.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/caaeaf18567bf5c75f3a2ac90608151729498f56.png)

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [January 20, 2021, 12:20pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/29 "2021-01-20T12:20:03Z")

</div>

I’ve always wondered about which was more efficient. Do you have data about this ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 20, 2021, 12:26pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/30 "2021-01-20T12:26:38Z")

</div>

For me, it’s less about efficiency, and more about avoiding spreadsheet formulas where ever possible.

That said, any time you’re doing calculations in the spreadsheet, you’re always going to see a delay due to the time it takes to sync changes. In this case that might not be an issue, but often it is if you need instant results.

But again, I just use a general rule of thumb - only do it in the spreadsheet if it can’t be done in Glide.

---

<div class="post-metadata">

**Author:** ![Brad\_Legassick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brad_legassick/32/8289_2.png) [@Brad\_Legassick](https://community.glideapps.com/u/Brad_Legassick)\
**Post date:** [January 20, 2021, 6:05pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/31 "2021-01-20T18:05:52Z")

</div>

Hi @Killko , I learned the hard way about QR codes generated in the Google sheet. The load times became really slow for the app & I had around 700 to a 1000 members rows with QR code spreadsheet formula. David advised me to create the template column in the Glide table & remove the spreadsheet array formula & it helped speed the app up. So definitely do the QR code generation in the glide tables. Cheers

---

<div class="post-metadata">

**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\
**Post date:** [February 3, 2021, 10:03am UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/32 "2021-02-03T10:03:26Z")

</div>

Could we do this with the new Webhook action in Glide by any chance?

---

<div class="post-metadata">

**Author:** ![MGD\_Tecnologia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgd_tecnologia/32/35265_2.png) [@MGD\_Tecnologia](https://community.glideapps.com/u/MGD_Tecnologia)\
**Post date:** [May 4, 2022, 2:21pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/33 "2022-05-04T14:21:35Z")

</div>

Hello ! Can you purge google sheet rows ? We cannot get your template to learn because its exceeds the limit for duplicating the app. Thank you.

---

<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:** [May 4, 2022, 9:04pm UTC](https://community.glideapps.com/t/qr-code-scanner-demo/11620/34 "2022-05-04T21:04:35Z")

</div>

@MGD_Tecnologia you could have a go - I did manage to copy the app today. I did clean up quite a few rows

[Previous page](https://community.glideapps.com/t/qr-code-scanner-demo/11620.md?page=1)
