With the fonction template i used your url to create a free QrCode generator 
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
1 Like
I was tried @Killko solution. It’s work on google sheets.
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