changing name and location of the files/image after uploaded via Appsheet

[San_Tou]

I use MYSQL as data source, have a table with an image and a file field

I use Google for logging in.

Appsheet allows me to upload files and images through that, which will save in a folder in my Google Drive, under appsheet/data/[the app's name]/[the table name]...

After the upload, 

1. can I relocate the file to other folders as long as it is still in my Google Drive?

2. Can I rename the file?

What I want to achieve after all, is to use Appsheet to capture files/images, either by drag and drop with web interface, or via mobile phone's camera; then the image can be stored in different folders but still maintain the link with the database via Appsheet

Thanks

[Marc_Dillon · Accepted solution]

The value stored in the table's image/file column is a relative file path, from the apps "Default folder" * (from the "properties" tab in the editor), to the uploaded image/file. If you change the file name, or its location, you'd have to also change the value stored in the table. 

Also, you can only store files relatively "below" the default folder, otherwise the app cannot access them.

* (this behavior is specific to your MySQL case, for GSheets it is typically relative to where that table's GSheet is, not the default folder)