Creating the Template

You can create an XML template file as described here.

Viewing or Editing the Template

Once the template is created, click the View button to view or edit the template.

Manually Creating the Template

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

<?xml version="1.0" encoding="UTF-8"?>
<records>
   <<Start: Select(MyTable[MyKey], TRUE)>>
      <record>  
         <UpdateMode><<_UPDATEMODE>></UpdateMode>
         <Application><<_APPNAME>></Application>
         <TableName><<_TABLENAME>></TableName>
         <UserName><<_USERNAME>></UserName>
         <LastName><<[LastName]>></LastName>
         <FirstName><<[FirstName]>></FirstName>
         <Age><<[Age]>></Age>
         <Computed Total><<[Qty]*[Price]></Computed Total>
         <ComputedName><<_ComputedName>></ComputedName>
      </record>
   <<end>>
</records> 

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. Ensure that the "Convert uploaded files to Google Docs editor format" option is disabled as described here.
  2. Open Google Drive and navigate to the Google Drive folder where you wish to upload the file. 
  3. Click the "New" button and then click "File upload". 
  4. 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?