Data in GCP but images are in Google Drive

[BJ_Prado]

I migrated the database that my app uses from Google Sheets to Google Cloud Platform SQL.
everything else works ok so far but I cannot view the images I uploaded.

This is how it was stored:

This is how it is displayed in the app:

When I checked, the images I uploaded are in the Appsheet folder in Google Drive.

How do I fix this or how do I store and call these images?

[Koichi_Tsuji]

I suspect the issue is coming from “default folder” path.

Before you migrate the data to Cloud SQL, I reckon you have been running the app with Google Spreadsheet. There should have been mismatching the actual spreadsheet location against the default folder path settings within info pane, properties tab.

Looking into the screenshot, “Sumitted Documents” should be the parent folder for your saved files. Check that folder location. Is it really placed under the default app folder? Then move that folder directly under the default app folder.
Then you edit app (whatsoever) just to increment the app version number, as the same app version will caching the files, images. Incrementing version number would clear the cache.

Then try to reopen the app.

[BJ_Prado]

This solved my problem. Thank you!