Solved: QR Code image Bug - Page 2

Aaron_Moolb · 04-02-2021 12:50 PM

I have an app to randomly generate a unique password based on criteria I pass to it and then the app generates a QR code image. Everything works great except 2 things.
When using a string of text that contain a “%” or “&” sign, the image will not show in the app.

EXAMPLE:
-My [Password] column has the following text “%”
-Virtual column as text =ENCODEURL([Password])
This will kick out a result of “%25”
-Virtual column [QR Code] that is set as an image with the following app formula:
=CONCATENATE(“https://chart.googleapis.com/chart?chl=”, [ENCODEURL], “&chs=200x200&cht=qr&chld=H%7C0”)
-If I take the [QR Code] output, I get the following URL
https://chart.googleapis.com/chart?chl=%&chs=200x200&cht=qr&chld=H|0

-I can paste this in a web page and it displays the QR code. The app just shows a triangle

This also happens with the “&” sign or any string of text with those two symbols in it. All other characters work great. Any ideas?!

Aaron_Moolb

BEAUTIFUL!
The issue was in my image column. I had a VC type Image with the expression [ENCODE Website]
The solution
VC type Image with the expression ENCODEURL([ENCODE Website])

I had assumed that since I was encoding the url already, that I could just put that in an image column with no need to encode it again.

Thank you!!!

View solution in original post