Customize content using form URL-encoded templates as described in the following sections:

See also Using templates in a bot.

Customizing content using a form URL-encoded template

When configuring a Call a webhook task, customize content using a form URL-encoded template by performing one of the following tasks:

For information about customizing the template, see Customizing content using templates and the tips provided below.

Viewing the template

After creating or selecting the template, click View adjacent to the template property to view the template.

Editing the template

To edit the template:

  1. Download the template file from your data source to your computer.

  2. Edit the template file on your computer using the text editor of your choice.

  3. Upload the edited template file from your computer to your data source.

For example, to download the template file from Google Drive to your computer:

  1. In the AppSheet Editor click View adjacent to the template name.

  2. Download the file to your computer.
    For example, if you are using the Google Chrome browser:

    1. Download the template file to your computer by clicking the Download button at the top right of the browser screen.

    2. You will see the downloaded file in the bottom left of the browser screen. Click ^ to the right of the downloaded template name and select Show in Finder.

To edit the template file on your computer:

  1. Open the template file in the text editor of your choice. For example, on Windows you might use Notepad.

  2. Edit the template file and save your changes.

To upload the edited template file from your computer to Google Drive:

  1. In the AppSheet Editor click View adjacent to the template name.

  2. If you are using the Google Chrome browser, click More actions in the top right of the browser screen and select Details.

  3. Click the folder name link to the right of the Location property to open the Google Drive folder containing the template file.

  4. Drag and drop the updated template file from the folder on your computer to the Content folder on Google Drive. The template file will retain its original DocId on Google Drive.

Manually creating a form URL-encoded template

Manually create a form URL-encoded template file by creating an empty text file, entering valid CSV text, and saving the file to your computer.

A form URL-encoded template typically contains a series of field name = field value pairs in the form:

<field name> = <field value> &


AppSheet automatically URL encodes each field name and field value in the template. For example:

LastName=<<[LastName]>>&
FirstName=<<[FirstName]>>&
Age=<<[Age]>>&
Computed Total=<<[Qty]*[Price]>>


You can include carriage return and line feed characters in the template to make it more readable.

After the template file is saved to your computer, upload it to one of the data sources described in Configuring the data sources for storing templates.

For example, you can upload the template file to Google Drive, as follows.

  1. Ensure that the Convert uploaded files to Google Docs editor format option is disabled as described in Uploading .txt templates to Google Drive.

  2. Open Google Drive and navigate to the Google Drive folder where you wish to upload the file.

  3. Click New and then click File upload.

  4. When the file open dialog appears, navigate to the template file on your computer, select the file, and click Open.

After the template file is uploaded, us it as described in Using an existing template.

Each time you modify the form URL-encoded template you must upload the template file to Google Drive. Google Drive will retain the original DocId. AppSheet will use the last uploaded version of the template file as the attachment template.

Did this answer your question?