How to recreate Google Drive file structure in AppSheet

[simransaluja03]

Hi, I have recently started working with AppSheet. 

I want to simply recreate the file structure (along with the hierarchies) of a Google Drive folder.

So far, I have been able to use AppScript to have all the links to folders and subfolders, and files listed in a google sheet. I am using this data in my app. The problem is, that all the rows are being displayed in my view in the App Sheet. Is there any way I can create structure in the data? I want the basic hierarchy - folder -> subfolder1, files -> subfolder2, files -> .............. -> files. 

From what I've explored, I want an automated slicing type thing (according to File Path) to happen when I click on a folder to list all the files and subfolders inside it. How do I achieve this?

Also, if there is any easier way to achieve what I want to achieve, then do let me know.

[WillowMobileSys · Accepted solution]

There are no views within AppSheet to support a a File system path + file structure or even a Hierarchical structure.  The closest you can come is using a Grouped Table View.  This would require you to create a row for each "node" (folder or file) of the path.  Otherwise, you are left with attempting to simulate the structure using Gallery views, for example, using a series of tables to represent your path structure.  Not really worth the effort.

You might be better served to find a 3rd party app that provides the capabilities you are looking for and simply link to that from your app.

[simransaluja03]

That makes sense. Can you suggest some 3rd party apps that will help me with this? 

[WillowMobileSys]

I'm sorry.  I haven't yet needed this capability so I don't have a recommendation for you but I do know there are some out there. 

[Joseph_Seddik]

One idea is to create as many columns as you have of subfolder levels and use app formulas to split the complete path and fill in the subfolder names or the file itself if you have already reached the deepest level. UX view grouping would simulate folder navigation, while file open action would attach to the columns and be available only if the column contains a file rather than a subfolder. 

I believe this would work.