AppSheet allows you to create a table based on a collection of files stored in Google Drive. This feature allows you to view files contained within a folder as rows of a table, with attributes of those files presented as columns in the table.
How do I create a table from a collection of files?
To create a table based on a collection of files, you must have set up Google as a data source:
1) In the Data section of the editor, select New Table.
2) Select “Documents on Google Drive”
3) Select “Collection of Files”
4) Select the folder from which to create the table. Note that the file picker will only show and allow selection of folders, even if there are files contained within a folder.
5) If desired, customize the name of the table and select Create Table.
What can I do with a collection of files?
Tables based on a collection of files are regular AppSheet tables. This means that they can be used in any way that a table usually can be used. This includes:
Creating UX views for interacting with file data. You can build views that allow users to view file metadata and even upload files to the underlying folder.
Adding and deleting rows from the table. This results in files being added or deleted to the underlying folder.
Creating slices. This allows you to create subsets of data to, for example, filter based on file names or date modified.
Creating cross-references from other tables. Other tables which reference files contained in the underlying folder can specify these files as Ref columns. This enables using file metadata from tables which use files.
The following table describes the default schema given for a collection of files.
The internal Drive ID of the file.
The full path to the file, from the root of the drive.
The file within the containing folder.
The time when the file was created.
7/13/2020 7:39:11 PM
The email of the user who last modified the file. This field may not be available in some cases.
Known Issues and Limitations
This list contains presently known issues and limitations with tables based on collections of files.