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.
-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
-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?!