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

[Yokuinin]

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?

[Aurelien]

Hi @Yokuinin 

Image Type.

I suggest you have a look to this excellent sample app from @SkrOYC 

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Sample-App-Barcode-Generator/m-p/399541#M5921

[Yokuinin]

Thank you but sorry to say I don't understand how to set.

What I would like to know is

How to convert from

Google spreadsheet ( image formula)

to Appsheet (to be seen in any view).

[SkrOYC · Accepted solution]

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

[Yokuinin]

Thank you for your detailed explanation!

I will discard my current app and revise using your suggested generator.