Templates App - Dynamic Images & Custom Triggers

The Data tab in the Enplug Templates app allows you to create and/or import spreadsheets of linked data to your sign. You can create dynamic templates by linking data triggered by a specific date, time, and images. 

Reference the Templates App article for information on using canvas tools.

Adding Data

To add data:

1. Log into Enplug.
2. Click the App drop-down in the top menu, then select Templates.
3. Navigate to the Data tab within the template.

Next, you'll choose to upload an existing spreadsheet, link an API data source, or creating a new spreadsheet. 

To upload existing data:

1. After following the steps above, select Connect Data.
2. Click Upload Spreadsheet.
3. Select the desired file.
   • Supported file types are .xlsx, .xls, or .csv.
   • If your spreadsheet has no formatted Date column, you'll be prompted to add an optional one for Event Triggers.
   • If your spreadsheet has a formatted Date column, select a column to use as your Event Trigger.
4. Select from the drop-down options to import columns from your spreadsheet and assign file types to column.
5. Once completed, click Done.
6. Make any desired edits, then click Save.

Note: Connect an API Data Source to your template to use with List View.

To create a new spreadsheet:

1. After following the adding data steps, select Start With Empty Spreadsheet.
   • A blank spreadsheet will generate.
2. Add columns by clicking the button in the right-side menu.
3. Delete columns by hovering over the column name and clicking the button.
4. Add rows by clicking the button in the bottom row.
5. Remove rows by clicking the button in the right-side menu.
6. Make any desired edits, then click Save.

Setting Event Triggers

Event Triggers use the Date column to display specific graphics. 

Note: You need, at least, one Date column to use Event Triggers.

To set a trigger:

1. Follow the steps above to populate a template/spreadsheet.
2. Click Set Trigger in the toolbar.
3. Select the desired Date column.
4. Set a start time for your content.
5. Set an end time for your content.
   • This will default to one day after the provided date.
   • Toggle on Repeat Yearly for content to repeat annually.
6. Click Save Changes.

Once the trigger is saved, you'll see Event Trigger in the column title.

Note: The start time for triggered content is the Date and Time on the corresponding spreadsheet column.

Linking Data to Canvas

Once you've added content to your spreadsheet, you can link a column to your canvas. Each row of content will an individual slide on your canvas.

To link a column from the Data tab:

1. Hover over the column name.
2. Click the button.
3. Select the Add as ... option for your column type.
   • When adding a date you will be prompted to Add as Date or Add as Countdown/up.
   • Date will appear as a standard date format.
   • Countdown/up will appear on your canvas as a countdown timer based on the date and time in the spreadsheet.
4. You'll be redirected to the Canvas tab to place the linked content.

Repeat these steps for all columns you wish to add to your canvas.

To link data from the Canvas tab:

1. Select a date, text or image item on the canvas.
2. Click the button.
3. Choose to change the linked data or add a new column in the drop-down.
4. Add Dynamic Images to your canvas and spreadsheet.
5. Click Image Placeholder.
6. Click Setup Data Column.
7. You'll be redirected to the Data tab to title the column(s) and upload images.

After linking your data, you can view and edit it on your canvas.

Notes:

• When you edit the placement of linked dates, text, or images, it'll move on all pages of your canvas.
• Navigate between your sign previews using the Preview Row arrows.
• Reference the Templates App article for more information on the Canvas.

Unlinking Data from Canvas

If you'd like to remove linked data, but keep it in your spreadsheet, you'll unlink columns.

To do so:

1. Hover over the column title and click the button.
2. Click Remove from Canvas.

To unlink from the Canvas tab:

1. Select a date, text or image item on the canvas.
2. Click the button.
3. Click Unlinked.

Notes:

• Click Clear Data from the toolbar to clear all data.
• Click Download Data from the toolbar to download your spreadsheet as a .csv file.

For questions or concerns, please reach out to our Support Team at support@spectrio.com.