There is an issue with templates. A template cannot use columns from a different source. The data must be added as a column in the table where the template will be applied.
For example, when working in a people table sourced from a companies search, we cannot use the company name in a template unless we add it as a column first.