AppSheet/Database Directory Structure

[Daisy_Ramirez]

Looking for some advice on setting up a good file structure for an AppSheet client

We have the following:

One main database (google sheets)
3 Apps (1-Admin App, 2-Field Apps)
Field Image Capture
“Saved to File” workflows generated from the field.

Because of the way AppSheet saves files by default I thought to set it up as follows:

Directory Folders:

1. Client Database Folder
   –Google Sheet spreadsheet
   –Image Folder A
   –Image Folder B
   –Image Folder C
2. Client Application (Admin)
   –Content
   –Files
3. Client Application (Field App1)
   –Content
   –Files
4. Client Application (Field App 2)
   –Content
   –Files

Is there a more efficient way of doing this? Ideally I’d like the Content and Files folders to be shared with any and all apps.

Any thoughts would be great! Thanks

[Austin]

A way of making the images available to all apps is to make sure that they are all contained within a single folder and then you can back up and go to different folders with VC’s that construct the folder path to the image. You can change the change the default file location for the apps and you should be able to direct the captured images into their appropriate folder. If you can’t then a Zapier should be able to move files are you please when they are added.
We don’t much image capturing so don’t quote me on that but as far as accessing goes what I said should be accurate.

[Daisy_Ramirez]

Thanks Austin! Do you mean we should construct an image path for the location of the centralized image folder? I’ve seen this for image types but not sure it can be used for Google Sheets.

[OptimiX_XcrY]

Or this