Solved: How to recreate Google Drive file structure in App... - Page 2

simransaluja03 · 06-17-2022 05:01 PM

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

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.

View solution in original post

How to recreate Google Drive file structure in AppSheet