Creating the Template

You can create an HTML email template file as described here.

Viewing the Template

Once the template is created, click the View button following the template file to view the template.

Editing the Template

To edit the template you must:

  1. Download the template file from Google Drive 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 Google Drive

You can download the template file from Google Drive to your computer as follows.

  1. In the AppSheet Editor click the View button following the template file.
  2. If you are using the Google Chrome browser, down load the template file to your computer by clicking the Download button at the top right of the browser screen.
  3. If you are using the Google Chrome browser, you will see the downloaded file at the bottom left of the browser screen. Click on the up arrow to the right of the downloaded template file and select Show in folder.

You can edit the template file on your computer as follows.

  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.

You can upload the edited template file from your computer to Google Drive as follows.

  1. In the AppSheet Editor click the View button following the template file.
  2. If you are using the Google Chrome browser, click More actions at the top right of the browser screen and select Details.
  3. Click the folder name hyperlink to the right of the Location property. This will open the Google Drive folder containing the template file.
  4. Drag and drop the updated template file from the folder on your person computer to the Content folder on Google Drive. The template file will retain its original DocId on Google Drive.

Manually Creating the Template

You can manually create a template file by creating an empty .txt file on your personal computer, entering JSON text like that below, and saving the file to your personal computer.

{
  "MyTable": [
  <<Start: Select(MyTable[MyKey], TRUE)>>
      {
         "UpdateMode": "<<_UPDATEMODE>>",
         "Application": "<<_APPNAME>>,
         "TableName": "<<_TABLENAME>>,
         "UserName": "<<_USERNAME>>,
         "LastName": "<<[LastName]>>",
         "FirstName": "<<[FirstName]>>",
         "Age": "<<[Age]>>",
         "Computed Total": "<<[Qty]*[Price]>>",
         "ComputedName": "<<_ComputedName>>"
      },
   <<End>>
   ]
}

Once the template file is saved to you personal computer, upload it to one of the following Data Sources:

  1. Box
  2. Dropbox
  3. Google Drive
  4. Microsoft Office 265
  5. Microsoft OneDrive

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

  1. Open Google Drive and navigate to the Google Drive folder where you wish to upload the file. 
  2. Click the "New" button and then click "File upload". 
  3. When the file open dialog appears, navigate to the template file on your personal computer, select the file, and click "Open". This will upload the template file to Google Drive.

Once the template file is uploaded:

  1. Click the file icon following the Attachment Template property. 
  2. When the "Select a file" dialog appears, navigate to the uploaded template file and select it.
  3. This makes the uploaded template file the current Template.

Each time you modify the template you must upload the template file to Google Drive. Google Drive will retain the original DocId. AppSheet will use the newly uploaded template file thereafter.

Did this answer your question?