Can't see images - Google Cloud Storage

juanpa · 06-16-2021 01:40 PM

Hi,

I copied an existing (Google Sheet) app to a SQL Database (Google Cloud).

I followed all the steps from here:

And here:

Now, the app runs but I’m having problems with the images.

I contacted the Appsheet support team and they told me that we must use BLOB (data type) for images fields in SQL I changed the data type to this but I still can’t see the images.

Does anybody know how to solve this?

I really appreciate your time and help

Austin

I recommend leaving the images in gdrive and accessing them the same way you did previously. I don’t think there is a benefit to using a database for the images over gdrive but could be wrong on that.

Koichi_Tsuji

I don’t thing we are able to save and retrieve image file onto SQL as a blog, as far as I know. If AppSheet support said so, it should be wrong, unless they introduced new features recently.
We are running apps with MySQL as backend, but we save the image and other files onto Google Drive. Working fine.
In the SQL data table side, they hold the path to image as string, which is exactly same as we do with Spreadsheet.

If you really want to store image in other way, move to Enterprise plan where you can use Bucket services to save image instead of saving images in google drive folder, if it is absoutely necessary.

Steve

This seems to confirm:

juanpa

Hi @tsuji_koichi and @Steve thanks for answering.

I was storing everything in Google Cloud Storage and images never show up. I changed everything to Default (Google Drive) and I still have the same problem.

When I save the image it shows up, then when the app syncs the image is not there …

Any ideas?

Koichi_Tsuji

I remember you “copied” app and direct the sql as new data source.
I doubt your new (copied) app is looking into the newly create default folders for stored images, files.
Go to old app first, visit info pane, property tab. Copy the default folder path.
Then go to new app, the same place, paste the path you just copied.
Both apps, new and olds will be looking into the same set of folders in the Drive.