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.

Table Schema

The following table describes the default schema given for a collection of files.

Field Name

Field Type

Description

Example

_ID

Text

The internal Drive ID of the file.

1Y1XAe9j0s3XenHPeROyB3FhAIcbBB3Uz

Path

Text

The full path to the file, from the root of the drive.

Documents/Invoices/Invoice-2021-04-20.pdf

File

File

The file within the containing folder.

Invoice-2021-04-20.pdf

CreateTime

DateTime

The time when the file was created.

7/13/2020 7:39:11 PM

LastModifiedBy

Email

The email of the user who last modified the file. This field may not be available in some cases.

me@example.com

Known Issues and Limitations

This list contains presently known issues and limitations with tables based on collections of files.

Did this answer your question?