QR code scanner demo

With the fonction template i used your url to create a free QrCode generator :blush:

2 Likes

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

I was tried @Killko solution. It’s work on google sheets.
Screen Shot 2021-01-20 at 10.54.03 AM

But I can’t display it on the app.

How can you do that? @Fredibu

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.

1 Like

Awesome. Thank you alot.

Formula

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

2 Likes

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))
to
=ARRAYFORMULA(IF(E2:E="","",“https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=”&F2:F))

You can also generate QR codes using quickchart.io
Rather than using an arrayformula in the Google Sheet, I’d recommend using a template column in Glide. ie. something like this:

6 Likes

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

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.

4 Likes

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

4 Likes

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

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.

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