how building appsheet with images inserted in cells of Google sheets?

[clubman]

A thank you in advance for the person that will help me solving this issue.

I have a Google sheets (subscribtion details) that contains a column of images that were inserted in the cell of sheets.

These (inserted in cell)  images are visible in sheets.

For appsheet the correct column name, IMAGES, and SHOW are activated but in the app I can's see the images.

Is there a way to use tis column in appsheet to obtain also the image for each subscription?

[Aurelien]

Hi @clubman 

Images from within cells won't be read by AppSheet.

Basically (in very short):

- you can read url that directs to a public image

- you can read images stored in your Drive, provided you have the relative path from your default app folder to your image

More information here:

https://help.appsheet.com/en/articles/961605-displaying-images-and-documents

[clubman]

Dear Aurelien,

I organised now a folder for the sheet and a subfolder IMAGES. I copied the link of a JPG image in the column of the images.

In the app I get a triangle in light grey instead of the image - the column is foreseen as IMAGE.  link is composed as https://drive.google.com/file/.........................../view?usp=sharing

Can you further advise in what I do wrong ?

[Aurelien]

Hi @clubman 

It may work, provided your folder content is made available to public.

Please see here:

https://support.google.com/drive/answer/7166529?hl=en&co=GENIE.Platform%3DDesktop

You may check that at copying the url link and paste it in a incognito mode browser.

Can you confirm ?

Note: if you are building a folder with all of your images, you may prefer store it in your app default folder and use a relative path instead.

[clubman]

Dear Aurelien,

I can indeed see the image in another browser then the one I'm working in with Google drive.

Do you mean that I better consider to use the app for adding the images ?

Or do you mean that I better don't use the subfolder IMAGES and instead store the images together ith the sheet in the same folder?

[Aurelien]

This, indeed 🙂

"Do you mean that I better consider to use the app for adding the images ?"

[clubman · Accepted solution]

dear Aurelien,

ok ..... will take some time and effort but this realy works

thanks a lot for your advise