Hope this tip may be of some help!
I was having an issue when generating QR Codes through external services like chart.googleapis.com, quickchart.io, image-charts.com.
Some strings to be encoded included the character “+”, which was vital to my QR Codes. It didn’t matter if I encoded the URL on Appsheet or not, the plus sign “+” always reached the external service as a blank space " ".
If I created the QR Code URL in the external service directly, the error didn’t occur (the QR Code contained “+” and worked fine).
When I encoded the text as URL on Appsheet the resulting text correctly encoded “+” as %2B. So the issue was probably not with ENCODEURL() expression.
Appsheet support came up with the solution eventually: ENCODEURL(ENCODEURL([Column Name)) as in “https://chart.googleapis.com/chartchs=150x150&cht=qr&chl=”&ENCODEURL(ENCODEURL([Column Name]))
Last time I was told they were checking with product engineer support why it was necessary to duplicate the expression.
LinkedIn
Twitter
