Changing which Drive Folder I can access

AppSheet AppSheet Q&A
,
1

I had an interesting problem that is still rattling around in my head. I had to create a focused app to show the contents of a Google Drive folder, but also allow the user to supply different folder IDs to view the contents.

Initially I tried with a Drive folder as a data Source, but I couldn’t change the SourceID. Eventually I solved it by using Sheets and AppScript to do the heavy lifting with the AppSheet app as a simple view. Is there a pure AppSheet wat to achieve the same outcome?

2

If there is a discrete list of folders you wish to be able to view, then “Drive folder as a data Source” is the way to go. Just bring in each folder as its own Table.

However, if you wish the user to be able to specify ANY Google folder for viewing, there is no AppSheet native way to handle it. Instead I would recommend providing a navigation link/integration to the Google Drive app or Browser. Use what has already been built.

1 Like