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.