Solved: Show image in Appsheet (Original data from Google ... - Page 2

Yokuinin · 03-14-2022 02:21 AM

I am trying to show the image in Appsheet.

I had read some relevant Q&A, but it still doesn't work.

*data type --- QR code generated by formula

*data source --- Google spreadsheet

*formula in the spreadsheet --- =image("https: / / chart.apis.google.com/...........)

I would like to show this QR code image in the Appsheet.

What is the fine for the column settings?

SkrOYC

First of all, don't use spreadsheet formulas.

In general, 90% of creators will never need them.

Second, the IMAGE() function on GSheets seems to be needed to show an image on the spreadsheet itself.

Just leave the URL, forget about any function. Or you could use an expression that creates an image URL.

If the column type is "image", AppSheet will automatically show the image on the UI. Just make sure yo have a public URL.

Also, I think I read that Google Chart API was not available since some time ago.

You can use one of this ones:

CONCATENATE(
  "https://quickchart.io/qr?text=",
  ENCODEURL([YourDataForQrCode])
)

or

CONCATENATE(
  "https://qrcode.tec-it.com/API/QRCode?data=",
  ENCODEURL([YourDataForQrCode])
)

PD: Quickchart option is quite customizable. You can take a look at the docs here

Show image in Appsheet (Original data from Google spreadsheet, image formula)