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?
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:
For reference:
User | Count |
---|---|
16 | |
9 | |
9 | |
7 | |
3 |