🔴 On2Air Docs has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

The templates use a syntax called Handlebars. You can create Simple or Complex templates.

In this article

The On2Air syntax is largely shared between each of the different On2Air Function Templates, but there are differences. These differences are caused but differences in the actual Google applications.

As an example, considered the following tables for Google Docs and Google Sheets. They will create the same table, but the required syntax is slightly different.

Google Docs

Google Sheets

The Difference

For Google Slides, there is not an equivalent of the Simple Table from the Google Docs Function. The header and body merge fields must be broken out individually.

If you are running into syntax challenges in Google Slides, please double check that you are using the Google Slides syntax specifically, and not copy/pasting the syntax from a Google Doc.

The easiest way to insert your data is to use Lookup fields in your base. Create a lookup field for each set of values you want from your base.

Once you set up your Table source and a Lookup field, you can then reference any field from the secondary table in your base inside your template table in Google.

To format the templates, add the template type name, then a space followed by an =. Finally, surround your data or formatting in parentheses.

Example

The tutorial will walk you through:

For this tutorial we are the imaginary company Peak Commercials. We are creating a Google Slides template so we can more easily create presentations of material for customers.

In this example we will walk through the following merge fields:

The input and output for the tutorial look like the following:

In example above, we’re bringing in Airtable data from 2 different tables - the Quotes table and the Items table. The Quotes table is the source for all of the merge fields except the table. The table uses the Budget Items field, which is a Linked Record that points to the Items table.

Step-By-Step Guide

To begin the tutorial, make a copy of the Google Slides Template document and the Airtable base.

This video will show you how to create your Google Docs Template and show you how an Airtable base might be set up.

It will also provide an overview of the different merge fields used in the Google Slides Template.

This video will show you how to configure the automation in On2Air Docs. Before this step, you need to create your Google Slides Template from Step 1.

Step-By-Step Guide

Note: During the following steps, if you click on a drop down menu and it says “no options available” you need to refresh the connection. Scroll back to the top of the screen and click the “refresh” button.

{{Your Field Name}}

These are used to insert your data anywhere in the file. Wrap the name of your Airtable Field in two curly braces.

The field placeholder will maintain its current styling. If you want to apply specific styling you will need to use the {{text}} merge field.

Example

The placeholder text of {{Quote Name}} will be replaced with the data stored in the Quote Name Airtable field. If {{Quote Name}} is in bold and 24 pt font, the merged content will also have that styling.

{{text}}

Inserts data from the selected Airtable Field into the text box. Insert a text box and position it where you want the merged data to go. Then enter the {{text}} field and options.

{{text}} Parameters

field

The Airtable field name that contains the text you want to insert

The text from the Quote_Explanation Airtable field will be displayed.

value

Set static text that will display in place of the merge field.

No Airtable data will display. Instead it will display “This text will display”

keepShape

If set to “1”, the text box that contains the merge field will maintain all of it’s styling features, such as borders, background color, font size, font color, etc.

“0” is default, which will not maintain styling. “1” will maintain styling.

useStyle

Use the styles provided for the template text

“0” is the default, which will not maintain template styling. "1” will maintain template styling.

Examples

For all three examples, the content from the Quote Name Airtable field will be populated.

In the first example, both the text box and text will maintain the template styling, even though useStyle is set to 0.

In the third example, none of the template styling will be maintained. This is the same as if useStyle and keepShape where both set to zero.

Insert images into a slide by placing the template text inside of a text box. Images will fit to the size of the text box. You can resize the text box to change the resulting image size.

Borders from the text box will not be included in the merged document. You can use borders accurately size and place the text box. If the text box overlaps with other text box or elements the resulting image will overlap them as well.

Only one image can be inserted per text box.

{{image}} Parameters

field

The name of the Airtable field that contains the image you want to insert.

Example

url

A publicly accessible URL of the image you want to insert. To test if the URL will work, paste the URL into your browser. If the image is displayed then you should be able to use the URL.

Example

This is used to insert your Airtable data as a link. To use a link field insert the template into a text box. Only one template per text box can be used. For example, if you have two link templates in a single text box, only the first link will display.

{{link}} Parameters

url

The URL you want to link to. This can either be a static value or another merge field.

value

This is the text that will be displayed.

Example

The first example has static values for both the url and value. The link will look like: On2Air Website

The second example has placeholders for both values. The display text will be value contained in the Airtable field Quote_Title, and the url will point to the value in {{Quote_URL}}

{{video}}

With the video template you can insert a video from YouTube or a video from your Google Drive. To use it, place the template inside of a text box. Position and size the text box how you want the resulting video to be. Set the value parameter according to the video you want to use.

{{video}} Parameters

value

To display a video, set the value parameter equal to the the YouTube ID or Google Drive ID for the video.

To Get The Youtube Video ID

To Get The Google Drive Video ID

Example

This will insert the classic Rick Astley - Never Gonna Give You Up music video. The full URL to the video is below, with the Video ID highlighted.

https://www.youtube.com/watch?v=dQw4w9WgXcQ

{{chart}}

Insert a dynamic or static chart from a Google Sheets document. You can have the chart automatically update when updated in Sheets or use it as a snapshot image of the chart.

To use the chart template, place the template inside of a text box. Position and size the text box how you want the resulting video to be. Each text box can only contain one template.

Note: Before you can insert a chart, the Google Sheet document that contains the chart must be connected to your On2Air application first. The steps to do this are:

{{chart}} Parameters sheet

The ID of your Google Sheets document

value

The ID of your chart from the Google Sheet

linked

Determines whether to make the chart dynamic (always updated) or static (1-time snapshot).

A value of “1” will make the chart dynamic. A value of “0” will make it static.

Example

To insert a chart:

Google Sheets document ID

Chart ID

Adds all data from a field or linked table and will generate a flexible grid table

{{grid}}

To insert a grid:

Options:

field - your Airtable field name source - your Airtable table name type - you can use text, number, image, and link. If you specify the type, you can format the cells as needed. rowHeight - the height of your row colWidth - the width of your column padding - add padding to your grid column - add padding to your columns row - add padding to your rows useShape - use the shape for each grid cell it creates

Example: {{grid source=”Template Data” type=”text” field=”Name” padding=”column: 0.1; row: 0.2” useShape=”1”}}

This merge field enables you to format data as a date

field

The Airtable field that contains the content to be merged.

format

Determines the date format. A few common examples:

On2Air uses Moment.js under the hood to format dates. Any valid format from Moment.js should be valid. You can see many examples here.

This merge field enables you to format data as a number

value

Sets the static text for number that you want to format.

field

The Airtable field that contains the content to be merged.

format

Please note there is currently a bug with formats using the currency placeholder. Please avoid using the currency placeholder for now.

Determines your number format. A few common examples:

Numeral.js is used for the formatting. So any valid formats displayed in the Numeral.js documentation will work here.

Examples

Each of these number fields contain the same data but are formatted differently. The outputs are:

There are two types of tables. The simple table described here, and the advanced table described below. This section covers the simple table.

Required Merged Fields

The Google Slides simple table requires a more verbose syntax than the equivalent for Google Docs. For the table to format properly it requires {{header}} and {{body}} merge fields in addition to the {{#table}} merge field.

The general structure for a Simple Table in Google Slides is as follows:

The {{#table}} merge field defines where the data is being pulled from. {{header}} determines what will be in the header row (this can be excluded if you don’t need a header row), and {{body}} determines what fields will populate the columns.

Usage

Using the simple table merge you can quickly create a table that is populated with data from your Airtable base. To use it, simply place the {{#table}} merge field and additional parameters inside of a text box.

Placement

Tables are generated where the text box containing the table merge field is placed. Therefore, if you have a large table or a lot of content, it’s possible that the table will extend passed the slide.

Styling

The Simple Table has limited styling options. In order to adjust properties like font size, color, or boldness you must use the advanced table.

source

Source is the Airtable field name of the data source. The source should be the name of a linked record from your Airtable base. Then in the {{body}} of the table you can assign the fields from the linked record that you want to display

Example

“Budget Items” is a a linked record from the Peak Commercials tutorial series.

columnWidths

Used to set the width, in inches, of each of the columns in the table. You can either specify a single number that will be applied to each of the columns. Or you can specify the width for each column by using a coma separated list of numbers

Example

The first and second examples will both have columnWidths of 1 inch for all of the columns, assuming that the second example has 3 columns in the table.

In the third example, the first column will be narrower with a width of 0.5 inches, while the remaining two columns will have a width of 1 inch.

minRowHeight

minRowHeight is used to set the minimum row height, in inches, for each of the rows.

Example

In this example the columns will all have a width of 1 inch and each row will have a height of at least 2 inches.

The {{header}} merge field is used in the Simple Table to define the content in the first row. This can be excluded if you don’t need headers. Please note, that to style the headers (such as to bold them) you must use the Advanced Tabled.

values

Values is a pipe (”|”) delimited list of static text values. The text in the list is what will be displayed as the header

Example

This example is for a 3 column table. The headers will be the listed values: “Line Item”, “Item Subtotal”, and “Cat.”.

Note that because these are static values they do not need to be an Airtable field.

The {{body}} merge field is used to define the content that will populate the table columns.

fields

Fields is a pipe (”|”) delimited list of Airtable field names. Note that these should be fields that are contained in the Airtable linked record set in the {{#table}} source.

Example

In this example, “Item Name”, “Item Subtotal” and “Category” are the names of the Airtable fields.

Example 1

This is an example of the most basic Simple Table in Google Slides.

The data is from the “Budget Items” Airtable field, which is a linked record. The body fields define what fields from that linked record will populate the table. The header values are static text that will be displayed in the first row.

Note that only the {{#table}} merge field requires a “#”. This is because it is an advanced merged field, so it requires an opening and closing tag. Which are {{#table}} and {{/table}} respectively.

Example 2

This is the same example as above, except that each column will have a width of 0.5 inches, and each row will have a height of 1 inch.

Conditional Formatting

ifEq - only display when the data from this field is equal to a certain value. This parameter needs to be your Field Name in Airtable. ifVal - only display if this value is present. This parameter needs to be a specific Value from the Field Name you chose.

Example:

Go to

On2Air Help Center