Open images added using AppSheet in Google Sheet

Hi.
I have a spreadsheet on Google Sheets that contains a column with the employee's name, a column for the personal photo, etc.
Using AppSheet, I made it possible for the user to add an image and made the column type (image), but if I return to the source file on Google Sheet, it does not appear as a direct link to the image in Google Drive, but rather appears as a path name like this: "Sheet2024_Images/Joseph.Your profile picture.180454.jpg" And I have to fetch it manually from Google Drive.
Is the problem with my application to AppSheet or where?

0 1 140
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @iOS64 

This is not a problem, this is intended behavior.

The picture will be loaded on your Drive default app folder. If you go into it, you will probably see:

- a folder named appsheet,

- which contains a folder named data,

- then a folder with your app name and a serie of numbers, such as "myapp-123456". This is your default app folder.

In this one, you'll see your spreadsheet and another folder that contains all of your images.

 

So, in the spreadsheet you will see the relative path toward your image, starting from the default app folder.

 

If you wish to retrieve easily your images from your Drive folder, I would suggest to specify a relative path in the settings of the column image. For example:

 

"/" & [Name]

 

 Here:

Aurelien_1-1716357124644.png

Aurelien_2-1716357327953.png

For reference:

Capture signatures and drawings - AppSheet Help

Capture images - AppSheet Help

Top Labels in this Space