I created an AppSheet app using a Google Spreadsheet stored in My Drive.
If I later move that Spreadsheet to a Google Shared Drive, could it cause any issues, such as broken file paths or lost file references?
1 Like
Hello @RYOTA,
Welcome to the community!!! The short answer is: yes, but that does not mean you cannot do it.
My first suggestion: I strongly recommend turning on “Maintenance Mode” in your app settings so users don’t try to sync data while you are moving files.
You could face a “Spreadsheet Not Found” error, please note that while the unique File ID usually stays the same, the access permissions might change and the app will fail to sync immediately. Having said that, you must ensure the person who “owns” the app in the AppSheet editor has explicit access to the new Shared Drive location.
Another possible issue is with images and files. Note that images and documents (usually PDFs) are stored using relative references i.e. if images were uploaded to My Drive/Apps/ProjectImages and you move only the spreadsheet to a Shared Drive, AppSheet will still look for the ProjectImages folder in the old location, I think it would even create a brand new folder in the new location. To prevent this, you must move the entire folder structure (the sheet AND its associated sub-folders for images/files) together and go to Settings > Resources in the AppSheet editor and verify the “Default App Folder” path.
If your app uses expressions like LOOKUP() or SELECT() that rely on specific file paths, those paths might start with /appsheet/data/… Moving to a Shared Drive changes the root folder. You may need to click “Update Table” and re-browse for the spreadsheet in its new Shared Drive location to “re-link” the connection.
It’s always a good idea to verify in AppSheet: Go to the Data tab in the editor and click “View Source” for each table. It should open the spreadsheet in the new location.
Test an Image Upload: Upload a new photo in the app to see exactly where AppSheet creates the new folder.
Sorry for the long response but I certainly hope this is useful!
2 Likes
Hello **Jose_Arteaga
**
Thank you for your response. I’m very grateful for your help. I will try implementing it in my app.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
Happy to help!
This community is such a powerhouse of expertise that it keeps me on my toes! It’s great to have you here, so please keep the questions and responses flowing.