2. Basic use of templates

• 1. In your Template sheet, add a column with the same header name as the one created in your data sheet.

  2. Build your template with HTML and CSS in the second row of your column. Inside the template, you can specify which data to write by using markers in the form : ${"Name Of Your Column"} or {{Name Of Your Column}}

When Awesome Table loads, it will fetch the data, then the template, and combines the two to display your data and the chosen layout.

Note : Templates are parsed from right to left, which means that a parsed column can be reused in markers, and will contain the data previously built.

Note: You can directly add HTML to format your AT content in the data sheet. However, we do not recommend this way of using templates. As the HTML will be part of data, it will be loaded again and again for each cells, slowing the gadget consequently.

Configuring the gadget

In the Awesome Table view configuration, for the data, just use the normal configuration parameters :

Then, in the Advanced parameters tab, fill the Template range settings with the complete range of your templates :

Note : If you are using a query to select which column to use, or to select the columns order, don't forget to include all the columns that contain source data for the templates !

More on Template !

Learn more about Template in these articles :