Sheets

Sheets are similar to tables, with the difference being that the entire table is repeated for each line of data, rather than a table row being generated.

Sheets are usually repeated vertically but can be repeated horizontally. To see how horizontal sheets are produced please see here.

Sheets must have a beginning row and an ending row.

To start a sheet use:

{{ sheetName }}

To add a tag to the sheet use:

{{ sheetName.fieldName }}

To end a sheet repeat the starting tag:

{{ sheetName }}

Columnar Sheets

Columnar sheets are where you want a sheet to run horizontally rather than vertically. This is usually used for narrow sheets or photos.

This can be achieved using the _COLUMNS suffix on the sheet name. E.g. sheetName_COLUMNS and a secondary “move to” table. The “move to” table should contain the appropriate amount of columns for the sheet to be repeated.

The tag should be formatted as {{ sheetName_COLUMNS_MOVE_TO }} and placed in a blank row above the cells that you want the sheet to go into.

You can add additional rows above or below these 2 rows for headers, footer etc.

Alternatively, you can put the move to tag in the first cell of the row where the horizontal sheets should begin.