G_S
September 29, 2022, 12:54pm
1
I need a help on bring QR code from google sheet to appsheet application
I am using google sheet formula and creating QR Code in google sheet ,i need that QR code to display in appsheet application
Currently its not showing in appsheet application but the QR Code is in google sheet
QR Code generate formula : image(“https://image-charts.com/chart?chs=150x150&cht=qr&choe=UTF-8&chl= ”&ENCODEURL(A15)))
Suggest any expression to show this in appsheet application or to save this qr code in google drive
Since you want it in AppSheet, you could generate it in an AppSheet column of image type with an app formula something like
CONCATENATE(“https://image-charts.com/chart?chs=150x150&cht=qr&choe=UTF-8&chl= ”&ENCODEURL([Name]))
[Name] is the column from where you will supply the input to generate the QR code shown as (A15) in your example. You seem to be having an entire column giving inputs to generate QR codes in each row. You could include that column and QR code column in an AppSheet table.
2 Likes
G_S
September 29, 2022, 1:10pm
3
Hi @Suvrutt_Gurjar
Thanks for a suggestion ,my requirement is I have a URL column I just need to have link in that QR Code
When I scan the QR code I should able to click the link ,but current i am not getting the QR Code with full link
I tried in app but its doesn’t create the link has QR Code so I have created in google sheet
G_S
September 29, 2022, 1:25pm
4
Steve
September 29, 2022, 1:42pm
5
Remove the IMAGE() function from around the URL in the spreadsheet formula; put the URL directly in the cell.
1 Like
G_S
September 29, 2022, 2:16pm
6
Hi @Steve
I tried it is providing a clickable URL but it is not showing image in application
Below image for reference
I created a virtual column and put that URL column in show type ,its not showing in application.
Please suggest to show the URL has image in appsheet
@Steve