Customize contents using HTML templates as described in the following sections:
- Customize content using an HTML template
- View the template
- Edit the template
- Manually create an HTML template
See also Use templates in a bot.
- Create an HTML template, as described in Create a template.
- Manually create an HTML template in your cloud file system and use it, as described in Use an existing template.
For information about customizing the template, see Customize content using templates and the tips provided below.
After creating or selecting the template, click View adjacent to the template property to view the template.
To edit the template:
- Download the template file from your data source to your computer.
- Edit the template file on your computer using the text editor of your choice.
- Upload the edited template file from your computer to your data source.
Manually create an HTML template file by creating an empty text file, entering valid HTML, and saving the file using an
Template variables like
<<FirstName>> must be HTML encoded. For example, the < character is HTML encoded as < and the > character is HTML encoded as >.
The following provides an example HTML file with HTML encoding:
<html> <head> </head> <body> <h1>MyTable</h1> <p>UpdateMode: <<_UPDATEMODE>></p> <p>Application: <<_APPNAME>></p> <p>TableName: <<_TABLENAME>></p> <p>UserName: <<_USERNAME>></p> <p>LastName: <<[LastName]>></p> <p>FirstName: <<[FirstName]>></p> <p>Age: <<[Age]>></p> <p>Computed Total: <<[Qty]*[Price]>></p> <p>ComputedName: <<[_ComputedName]>></p> </body> </html>
After the template file is saved to your computer, upload it to one of the data sources described in Configure the data sources for storing templates.
For example, you can upload the template file to Google Drive, as follows.
- Ensure that the Convert uploaded files to Google Docs editor format option is disabled as described in Upload .txt templates to Google Drive.
- Open Google Drive and navigate to the Google Drive folder where you wish to upload the file.
- Click New and then click File upload.
- 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, use it as described in Use an existing template.
Each time you modify the HTML 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.