Dataclay’s documentation describes what Templater does with an empty data cell for several specific cases, but it does not give one general rule that covers every cell. For footage, text styles, essential properties, output names, target compositions and AI prompts, the behavior is written down, and it is not the same in each case. What the documentation does not state is what Templater does with a plain text layer when its data cell is empty. That detail is not given here, so test it in your own project before you rely on it. The rest of this page goes through each documented case and then shows how to design a data sheet around them.
Empty Cells and Footage
Footage is the case the documentation covers in the most detail, and it has a setting you control. In Templater Preferences, the Footage group has a checkbox called Consider empty cells or null values as faulty. The result depends on whether it is selected. If empty cells are not treated as faulty, Templater holds over footage from the previously previewed row. That means a row with an empty footage cell can show the footage from the row before it.
When empty cells are treated as faulty, Templater applies its missing footage options. The options include Ask me what to do, Skip the row, Use my branded placeholder and Cancel. A further option, Let me find the footage asset, picks a replacement with the operating system file browser. Dataclay recommends the Use my branded placeholder option for smooth batch processing. Templater 2.9.5 and later installs default branded placeholder files and defaults to use my branded placeholder. The placeholder files default to /Applications/Dataclay on macOS and C:\Users\Public\Documents\Dataclay on Windows.
Cell Type Behavior
What each empty cell type does
| Cell type | What Templater does when empty | Condition or override |
|---|---|---|
| Footage | Holds over footage from previously previewed row | Faulty checkbox changes this to missing footage options |
| @style entry | Uses default values in Templater Preferences | Empty direction defaults to LTR; empty justification matches direction |
| Essential property key | Uses the default value | Wrong data type skips the key and writes an error to log |
| Output cell | Appends the id value to output file names | Without ids, uses spreadsheet row’s index |
| Target column | Processes the default target composition | Error shown if default target comp does not exist in project |
| AI-mapped text layer | Sends layer’s prompt to the AI service | Data in connected source always takes precedence |
Here is how those pieces fit together for a batch:
- To make an empty footage cell show up as a problem, select the Consider empty cells or null values as faulty checkbox.
- To keep a batch running when footage is missing, choose Use my branded placeholder, which Dataclay recommends for smooth batch processing.
- To drop rows that lack footage, choose Skip the row.
- To stop and decide each time, choose Ask me what to do or Cancel.
Footage file paths in a Templater data source must be relative to the path in the Footage folder field. Dataclay advises one footage folder per After Effects project configured for Templater. The guide on missing footage and remote footage in Templater walks through the choices, and the screencast on making dynamic footage layers with Templater shows footage layers in use.
Empty Cells in Text Styles and Essential Properties
Dynamic text styling uses a column or property key named after the text layer with @style appended. It supports the font-face, direction and justification properties. Templater font-face in @style uses the font’s Postscript name, for example the value ArialMT. The documentation states what happens when parts of that entry are empty:
- A blank @style entry makes Templater use the default values in Templater preferences.
- An empty direction value in Templater @style defaults to left to right (LTR).
- An empty justification value in Templater @style matches justification to direction.
- If Templater cannot determine the font-face, it defaults to the font set in Templater Preferences.
Font problems are written down as well. On Windows, a Templater font-face that is not installed falls back to the System Default Font. On macOS, a font-face that is not installed produces unexpected results. If the font-face does not support the text’s language, Templater does not import the text for that row. These cases are about a value that is present but cannot be used, which is different from an empty cell, but they are worth knowing when you design a text styling column.
Dynamic Essential Properties follow their own rules. If an essential property key is missing, null or undefined in the job data, Templater uses the default value. If an essential property value has the wrong data type, Templater skips that key and writes an error to its log file. For the property syntax, see the guide on essential properties promotion.
Empty Cells and Output Names
Output naming is another place where an empty cell has a stated result. Dataclay recommends a column named id to label each spreadsheet row for Templater output. Templater appends the id value to output file names if there is no output column or it is blank. Values in an output column override values in an id column for output naming. Without ids, Templater uses the spreadsheet row’s index to generate unique identifiers, and for a JSON array it uses the object’s ordinal position.
QUE follows a related rule. QUE names an output asset by the Job’s _id when the output naming option uses output but no output value exists. Keys cannot be deleted from a QUE job, but setting a key to an empty string clears its value.
The Bot will overwrite existing files if it renders to the same output file name. Dataclay also advises avoiding a period character in custom output names to avoid After Effects output errors. The guide on unique IDs and switching project files in a spreadsheet or JSON data source covers the id column in detail.
Empty Cells in Target, Project and Status Columns
Several reserved columns have documented empty behavior. Templater reserved column names include id, target, output, aep, render-status, bot, module and render-settings, and using a reserved name as a dynamic layer name can cause a processing error. For the target column, if it is missing or names no existing comp, Templater processes the default target composition. If the target composition set in Templater Preferences does not exist in a project, Templater shows an error.
The aep column switches After Effects projects per row, and each cell holds an absolute path to a project file prepared for Templater. When switching projects per row, Templater row ranges must start from row 2 or higher. Missing fonts or effects halt Templater’s project switching process, and the project files must open without error. The documentation does not state what happens when an aep cell is empty, so treat every row as needing a path.
The render-status column has its own guidance. With one Templater Bot, you or your app should only enter ready in render-status or empty the cell. The Bot retrieves rows with a render-status value of ready, so an empty cell is simply a row that is not ready yet. The guide on what happens when a column name matches a reserved Templater name explains the reserved names.
Empty Cells and Generative AI Prompts
Templater AI uses your own existing AI account to generate text from After Effects text layers. Templater AI prompts are entered in the Default Prompt box under Generative AI in the Templater Settings effect. This is the one case where an empty cell does something on purpose: Templater sends a layer’s prompt to the AI service when the layer is mapped and its data cell is empty. In Templater, data in the connected source always takes precedence over any generative AI suggestion, so a filled cell is never replaced.
That has a design consequence. Templater AI uses your own existing AI account to generate text from After Effects text layers. If you do use it, an empty cell is a request for generated text, and the result comes from the prompt on that layer. The guide on bridging generative AI and media automation explains where that fits.
Checking an Empty Cell in a Preview
You do not have to run a full batch to see what an empty cell does. Templater previews your template with data, and a few documented details affect what you see. In Templater Manual preview, Templater reads the data source again each time and does not use caching, so a change you make to a cell shows up the next time you preview. Previews may not update if the preview uses menu is set to current state instead of next row or previous row, so choose next row or previous row when you step through your data.
Keep in mind what a data cell can hold. Templater data source cells can contain text, URLs, image file paths, or hex color values, and an empty cell stands in for any of those. Use the Preview with the row that has the empty cell and compare it with a neighboring row. For footage, the previously previewed row is the one whose footage Templater keeps when empty cells are not treated as faulty.
Autografs show how placeholders are meant to work. Autografs are rigged with Templater and include placeholder data, and you replace the placeholder info with your own data to create custom video. A footage layer first created by inserting a Placeholder object may not update with new footage, so if a footage layer ignores your data, check how that layer was made. The screencast on previewing with the data transport shows the preview controls.
Designing a Data Sheet Around Empty Cells
The documented behaviors lead to a few practical rules for a data sheet, each tied to a fact above.
Decide on purpose what an empty footage cell should do. Select the faulty checkbox if you want the problem to be visible, and pick a missing footage option so the batch has a known response. Do not leave the setting unchecked and assume an empty cell will be skipped, because Templater then holds over footage from the previously previewed row.
Give every row an id. A filled id column means output names do not depend on a blank cell, and it makes it easy to match a video back to its row. Fill the target column for every row, or leave it out entirely, since a missing target column or a name that matches no comp sends the row to the default target composition.
Fill the style entries you care about. An empty @style entry uses the defaults in Templater Preferences, so set those defaults to something you are happy with. Keep essential property keys complete, because a missing, null or undefined key means the default value is used.
Finally, test with a spot check. Spot Checking in Templater lets you quality check a batch render by seeing how data merges across jobs, and Dataclay recommends a pre flight render of one video. Add a row with an empty cell for each kind of layer you use and look at what comes out. For a text layer, which the documentation does not cover, this is the way to find the answer for your own template. Start from Templater for Adobe After Effects if you want the product overview.
Data Sheet Design
What to do before you run a batch
- Select the faulty checkbox if you want an empty footage cell to be visible as a problem
- Give every row an id so output names do not depend on a blank cell
- Fill the target column for every row, or leave it out entirely
- Set the defaults in Templater Preferences to something you are happy with before relying on @style fallbacks
- Add a row with an empty cell for each kind of layer you use and look at what comes out
Bottom Line
There is no single answer to what Templater does with an empty cell, because the documentation gives separate answers for separate cases. Footage is held over from the previous row unless you select the faulty checkbox, @style entries fall back to the preference defaults, essential properties use their default value, output names fall back to the id, a missing target uses the default target composition, and an empty cell on a mapped layer can trigger a Templater AI prompt. What happens to an empty text cell is not stated, so check it in your own project and design the sheet so that no cell you need is left empty.
Frequently Asked Questions
What does Templater actually do when a data cell is empty?
It depends on the kind of cell, and Dataclay’s documentation does not give one general rule. For footage, Templater holds over the footage from the previously previewed row unless empty cells are treated as faulty. A blank @style entry uses the preference defaults, and a missing essential property key uses the default value. What it does with an empty plain text cell is not stated.
How do I make an empty footage cell count as a problem?
In Templater Preferences, select the Consider empty cells or null values as faulty checkbox in the Footage group. Then Templater applies the missing footage options instead of holding over the previous row’s footage.
What happens to the output file name if the output cell is blank?
Templater appends the id value to output file names if there is no output column or it is blank. Without ids, Templater uses the spreadsheet row’s index to generate unique identifiers.
What happens if the target column is empty or missing?
If the Templater target column is missing or names no existing comp, Templater processes the default target composition.
What happens when an essential property key is missing?
If an essential property key is missing, null or undefined in the job data, Templater uses the default value. If the value has the wrong data type, Templater skips that key and writes an error to its log file.
Which missing footage option does Dataclay recommend?
Dataclay recommends the Use my branded placeholder option for smooth batch processing. Templater 2.9.5 and later installs default branded placeholder files and defaults to that option.
Can an empty cell trigger generated text?
Yes, when Templater AI is set up. Templater sends a layer’s prompt to the AI service when the layer is mapped and its data cell is empty, and data in the connected source always takes precedence over any generative AI suggestion.