Create and save a file by adding the Create a new file task to a bot.

Configure the Create a new file task by setting the properties described in the following table. When you are done, save the task by selecting one of the following:

  • Save - Save the task

  • Save & verify data - Save the task and verify the data defined.

  • Save & notify users - Save the task and notify users.

After you save the task, you can reuse it in other bots.

Property

Description

Default (if applicable)

Task name

Name of the task. It must be unique within your app.

Table name

Table referenced by the task. Select an existing table in the list.

Click View definition to view the structure of the selected table.

See Tables: The Essentials for more information about adding tables.

HTTP Content Type

Content type of the file.

Valid content type values include:

  • CSV

  • HTML

  • ICS_Calendar

  • JSON

  • PDF

  • XLSX (Microsoft Excel)

  • XML

Template

Template to use for more precise control of the file contents. See Using templates in a bot.

File Store

File system where files are saved.

When set to Default (the default setting), the file is stored on the authentication provider file system. For example, if your authentication provider is Google, the file is saved to Google Drive. If your authentication provider is Dropbox, the attachment file is saved to Dropbox.

Note: If Smartsheet is your authentication provider, AppSheet saves the file to Google Drive as Smartsheet does not have a file system. If you use Smartsheet and wish to save files, you must include Google as a data source, as described in Using multiple data sources.

Default

File Folder Path

Folder path where files are saved relative to the default app folder.

Use the Expression Assistant to specify text, variables, and expressions. For example:

  • Files/MyPurchaseOrders

  • <<CONCATENATE("MyFiles/PurchaseOrdersByMonth_", YEAR(NOW()), "_", MONTH(NOW()))>>:

In the second example, email attachment files would be stored in a separate folder, based on the month. For example: MyFiles/PurchaseOrdersByMonth_2019_02

Files

File Name Prefix

Prefix to prepend to the filename.

Use the Expression Assistant to specify text, variables, and expressions.

AppSheetDoc

Attachment Page Orientation

Page orientation used for PDF files. Valid values include: Portrait and Landscape

Note: This property is available only if you set HTTP Content Type to PDF.

Portrait

Attachment Page Size

Page size for PDF files. Select a standard size or select Custom and enter the Attachment Page Width and Attachment Page Height in millimeters.

Note: This property is available only if you set HTTP Content Type to PDF.

A4

Disable Timestamp?

Toggle to indicate whether to append a timestamp to filenames. Appending the timestamp will ensure the filenames are unique.

The timestamp contains the date and time at which the attachment file was created, formatted as follows: yyyyMMdd_HHmmss_fff indicating year, month, day, hours, minutes, seconds, and milliseconds. For example:

MyFileName20190207_133355_804.pdf

If you disable the timestamp, you must ensure that every filename is unique. Otherwise, the files may be overwritten. For example, if you are saving files to Google Drive and you disable the timestamp, only the most recent attachment file will be available. Older files with the same name will have been overwritten.

Disabled (timestamp is appended)

Did this answer your question?