How to Upload Images to AppSheet Database

[V-A]

How do I upload images to AppSheet database via the app editor (rather than the app)?

My app uses AppSheet's database.  When creating a new image-type column, I see that it's not possible to upload image files into the column's cell:

I know my default folder path is "/appsheet/data/MyApp-123456789" but do not know how to access it to upload images.

How are images uploaded in AppSheet database?  Thanks.

[Marc_Dillon]

You probably don't upload images directly to the database, just like you don't upload them directly to a gsheet or sql database. Only the relative path to the file stored on your gdrive is saved to the table.

Keep in mind that appsheet databases are still in beta/preview.

[V-A]

Thanks for the reply.

I understand AppSheet database is in preview stage so it may have some limitations.  I've uploaded image links prior to AppSheet apps using Google Sheets as the database; I just needed to place the images folder in the same folder as the spreadsheet database and reference the "folder/filename.png", for example.

The problem is that I don't know how to access the AppSheet path where my app's database resides so I can upload an images folder or the images without a folder.

Please let me know how can I access "/appsheet/data/MyApp-123456789", if this feature is currently possible.  Thanks.

[Marc_Dillon]

Upload a photo through the app, and then see what kind of value ends up in the database.

[V-A]

The database entry doesn't provide the full path nor much else meaningful; just "TableName_Images/RandomAlphaChars.ColumnName.RandomDigits.png".

[Marc_Dillon · Accepted solution]

Correct, it's a relative path. Go find where that file is that you just uploaded and you have your answer.

[V-A]

I searched my Google Drive for those RandomAlphaNum characters, found the file, and found the root folder.  Thanks.

[PgM]

Hello All, 

I'm jumping to this thread:

I currently have an app based on the gsheet with images saved on my drive

I'm creating a new app based on appsheet database as it seems to be the most efficient data storage. On this new app i'm reusing a big part of the data from my "legacy" gsheet app. 

I'm struggling to get the images available on the new app.

i have copy paste path of the image

which is where it is saved  in my g drive

here is what i see in the app

Could you please help me to figure it out ?

Thanks for your help

[Marc_Dillon]

For ASDB (as well as any sql database), the path to the image is relative to the app's "default app folder", which is different than for a GSheet where the path is relative to the location of the GSheet.

[PgM]

Thanks @Marc_Dillon 

I guess i've saved the images (transfer) to the right folder as i've transfered the images where the new one (uploaded from the App itself) have been stored.

Am i missunderstanding your reply ?

Many thanks

PG

[PgM]

@Marc_Dillon 

To illustrate my asnwer: the last image is a new one from the App, the 2 others are the ones i've transfered to my previous App

[Marc_Dillon]

And what are the data values stored in the table for those 3 images?

[PgM]

This is the values in the ASDB

[Marc_Dillon]

The folder names are different, "STOCK" vs "STOCKAGE".

[PgM]

argh!!!!!

I'm stupid!! sorry to bother and many thanks for your precious help!

[PgM]

argh!!!!!

I'm stupid!! sorry to bother and many thanks for your precious help!🙏