Subcategories

• Google Sheets

  Questions, answers, and discussions about using Google Sheets as a Templater data source.

  29
  Topics
  110
  Posts

  undefined

  Hi @Jeff,

  Thanks for the super speedy response!

  So I tried the expressions in that other link about highlighting text but it didn’t quite work (it was returning Error:“Can’t turn result into numeric value”).

  But it’s ok as it led me to an alternative but still perfectly effective solution!

  For more context:

  We have 13 different risk warnings (set as collumns) for each row of data (e.g. Bitcoin, Ethereum, etc)

  The way I have set this up is so that I simply change the name of the Risk Warning pre-composition in After Effects from one license to the next (i.e. changing the data collected from one collumn to another in the Google Sheet) which then updates to the correct pre-composition with the correct text (also linked to the spreadsheet.)

  Each Risk Warning pre-composition now has a text animator with the stroke added individually which was a simply copy/paste job really.

  Here’s some visuals to help bring my terrible explanation to life:

  Screenshot 2024-09-06 at 13.12.29.png
  Each risk warning is in its own collumn (depending on the request from the marketing team for a particular risk warning we can generate the appropriate text directly in the project file and render a batch of assets for them)

  Screenshot 2024-09-06 at 13.12.54.png
  This pre-composition links to the corresponding collumn in the Google Sheet and changes the Pre-comp based on the collumn we want to use

  Screenshot 2024-09-06 at 13.13.13.png
  Each Pre-comp is set with an animator to create the stroke giving it that ‘bold’ effect (not linked to the spreadsheet as the stroke will not change - only the text within the Google Sheet will change once per quarter (and even then it’s just 2 numbers which won’t affect which words are ‘bold’ and which are not)

  Thanks for your help!

  Jake

• Local JSON

  Questions, answers, and discussions about using a local JSON object array as a Templater data source.

  6
  Topics
  18
  Posts

  undefined

  @eric_dean

  Great question! Escaping the quotation marks should be as easy as putting a backslash before the quotes in the text block of our JSON file. So, for example, if we wanted something like this:

  Lorem ipsum "dolor" sit amet

  we’d write it like this:

  Lorem ipsum \"dolor\" sit amet

  The backslashes should be read as an “escape” to keep the quotation marks in the text from interfering with the formatting of the JSON data file.

  Hopefully, that should be all we need, but if you have any other questions, please feel free to reach out.

  Thanks,

  Jeff

• Remote URL Feeds

  Questions, answers, and discussions about using URL feeds as Templater data sources.

  5
  Topics
  24
  Posts

  undefined

  @oms The structure of the data returned is not readable by Templater. You need to have it respond to your request as an array of objects. Inside the objects, you cannot have nested objects either. You actually can, but Templater will ignore it.

  So for example your structure now is this:

  { "data": { "id":2, "name":"fuchsia rose", "year":2001, "color":"#C74375", "pantone_value":"17-2031" }, "support": { "url":"https://reqres.in/#support-heading", "text":"To keep ReqRes free, contributions towards server costs are appreciated!" } }

  But really it needs to be an array, and it needs to be “flat” objects inside that array. So it would be best to do:

  [ { "id" : 2, "name" : "fuchsia rose", "year" : 2001, "color" : "#C74375", "pantone_value" : "17-2031", "url" : "https://reqres.in/#support-heading", "text" : "To keep ReqRes free, contributions towards server costs are appreciated!" } ]

  Note how the singular object is still within an array [ ]. Also note that there are no nested objects in that singular object in the array.

  Does this help?

• Tabbed Separated Values

  Questions, answers, and discussions about using Tabbed Separated Value files as a Templater data source.

  1
  Topics
  1
  Posts

  undefined

  If your data is stored in Microsoft Excel, you will need to export it as a Tabbed Separated Value file—known as a TSV file.

  With all the various Microsoft Excel releases, the steps to convert a worksheet to a TSV file vary between versions and operating systems.

  Also, don’t forget that you may need to enable the “Tab delimited file exported from Excel or Numbers” checkbox within the Templater Preferences dialog to work with TSV data exported or saved from Microsoft Excel.

  0_1469650487624_Screen Shot 2016-07-27 at 3.14.17 PM.png