MYSQL backend database, where does the image/file saved in?

[San_Tou]

I am using Mysql as the backend data source

I tried setting a file column, with the datatype as BLOB, but as soon as I put a file in that column in Appsheet, it will give me a triangle exclamation mark error.

I changed the datatype of the column to TEXT, and it seems to work, that is, I can upload the file/image onto the column in Appsheet, and it shows the file.

The question is, where does Appsheet store my file in? I can only see a link-like string saved in the raw table, a link that I cannot open by clicking it.

[WillowMobileSys · Accepted solution]

Generally, most App Creators will setup their account using one of the cloud providers - Google, Microsoft, Dropbox, etc.  Files and Documents will then be stored in that cloud service following the default AppSheet folder path specified in the app.  In the db, the path to that folder and file will be stored.

[WillowMobileSys · Accepted solution]

Correct.

[WillowMobileSys · Accepted solution]

Generally, most App Creators will setup their account using one of the cloud providers - Google, Microsoft, Dropbox, etc.  Files and Documents will then be stored in that cloud service following the default AppSheet folder path specified in the app.  In the db, the path to that folder and file will be stored.

[San_Tou]

Thanks. 

So the image would have been saved in my Google Drive, as I used Google to login to Appsheet, and the MYSQL database table would only save the link to my Google Drive of that file, is that right?

[WillowMobileSys · Accepted solution]

Correct.

[San_Tou]

I have found the location of where all files and images are stored in Google Drive

If I moved them into other folders of Google Drive, and/or to rename them, would it still show properly in Appsheet? That way I can use the Appsheet as a quick way to input and categorise files, but then I can move/rename them after in the drive.

[SkrOYC]

---

@San_Tou wrote:

If I moved them into other folders of Google Drive, and/or to rename them, would it still show properly in Appsheet? That way I can use the Appsheet as a quick way to input and categorise files, but then I can move/rename them after in the drive.

---

Afaik, no.

Can you share the data inside of the field on your database that has the file?
It is a full link or a relative path?

I expect it to be a path but I'm not sure

[San_Tou]

Thanks for the prompt reply.

I hope I understand you correctly.

1. The backend is MYSQL

2. The field storing the file is a TEXT field

3. only the link is being stored

4. it is NOT a Google Drive link (see photo)

I wonder if there is a way that if I post an actual Google drive link of a file into Appsheet it can provide a preview, as that's all I needed

 

[SkrOYC · Accepted solution]

Perfect, so the answer is no, you can't move the files.
I mean you can, but AppSheet will not know where they are anymore.

https://support.google.com/appsheet/answer/10107317#file-name-value