Appsheet integration with Google Drive Folders and Files

[JuanRomo]

I have an App Sheet app to create a Medical Record for Patients for a Medic, so I want to create a Folder in Google Drive for each Patient that creates, so the Doctor can add the Patients documents that are part of the Medical Records (Lab Test results, Especific Test, Docs, Sheets, Presentations, etc).

I have created a Data Source from GDrive to able to have a folder in the App

Folder Access Problem:

• I can not create the Subfolders for Each Patient, I try creating a file and adding the additional path for the folder and the name of the file, but it did not create the subfolder, I can use a Script to create the folder if that is not a way to do it without coding. 
• I create a Subfolder Manually to see if I can reference the subfolder, butI can not reference the Subfolder with in the app so I can see the documents inside the view of the app

Files Access Problem

• The documents that I create inside the GDrive Data Source folder with the App, works for PDF, Images, but I can not open the file to Edit in Google Docs directly, it always download the files but for the files that are Google Docs I want to edit with Google Docs docs app or in the browser. 

Hope you can give me some ideas for this. Thanks

[WillowMobileSys · Accepted solution]

---

@JuanRomo wrote:

I have created a Data Source from GDrive to able to have a folder in the App

---

AppSheet does not support folder hierarchy in any form.   It uses table and table relationships.  When using a folder as a datasource, only the files and their meta data in the sourced folder are loaded as table rows.

This just means what you are trying to achieve needs to be handled in a different way.  How will depend on the data structure you are building. 

For example,  you likely have a Patients table but since you want the ability to upload several documents, you probably want a Patient Documents table as well.  When uploading documents, you can specify a specific folder (e.g. by Patient ID) that each document goes into.  BUT...these folders will be managed under the AppSheet app folder structure in GDrive.

AppSheet also does not have an ability to open a file for editing at all.  However, you might be able to use AppSheet webhook function to send the file to Google Doc's API so the file is opened within Google Doc's.  This is something you would need to build but don't think it's difficult once you know how.  I have never done this so not exactly sure how it works.

I hope this helps!

[WillowMobileSys · Accepted solution]

---

@JuanRomo wrote:

I have created a Data Source from GDrive to able to have a folder in the App

---

AppSheet does not support folder hierarchy in any form.   It uses table and table relationships.  When using a folder as a datasource, only the files and their meta data in the sourced folder are loaded as table rows.

This just means what you are trying to achieve needs to be handled in a different way.  How will depend on the data structure you are building. 

For example,  you likely have a Patients table but since you want the ability to upload several documents, you probably want a Patient Documents table as well.  When uploading documents, you can specify a specific folder (e.g. by Patient ID) that each document goes into.  BUT...these folders will be managed under the AppSheet app folder structure in GDrive.

AppSheet also does not have an ability to open a file for editing at all.  However, you might be able to use AppSheet webhook function to send the file to Google Doc's API so the file is opened within Google Doc's.  This is something you would need to build but don't think it's difficult once you know how.  I have never done this so not exactly sure how it works.

I hope this helps!

[AleksiAlkio · Accepted solution]

One option is to add the Folder URL to your patient's record and the app user can open the Drive folder from the app and do what ever with those files.