Save
Saving
  • Jon Jon

    @vjn86 (and for anyone else reading this later)

    Yes, you can do this, but you will need to use expressions to accomplish it. You can set numerical values in your data, then map that data to a dynamic text layer in your project. Then, you can use a parseInt() expression to parse the value of the sourceText of the layer into a number that can be used in any numerical value such as position, scale, rotation, etc. See referencing dynamic text layers section.

    posted in Google Sheets read more
  • Jon Jon

    @Tasnadi-Otto Just to clarify, are you talking about pixel dimensions (length and width) or time/duration? If you’re talking about time, you can do what Arie suggested, or, as a workaround, you could set up your text layer(s) and have it mapped in multiple comps, each comp having a different duration, then use comp switching feature to swap between different precomps using the method shown in this demonstration.

    posted in Templates read more
  • Jon Jon

    @dwalters There are videos demonstrating setting a target as well as switching between project files. For data in expressions, see the link in my previous post under the section “referencing dynamic text layers.”

    posted in Google Sheets read more
  • Jon Jon

    @dwalters You can select individual comps within a project to re-version with the target property, or you can switch between projects with the aep property (and you can combine the two). Templater will parse through the entire project, not just the target comp, so you can set up really complex, modular systems that all update at once. You can use data from your data source to drive you controller/checkbox layouts.

    posted in Google Sheets read more
  • Jon Jon

    @dwalters You can use spreadsheet formulas to access data in other worksheets within a “master” worksheet. Just be aware that if you are using the Bot to process your jobs, a quirk of the Google Sheets API makes it so that Templater must “flatten” the formulas in any row that it processes. If you are using the Render/Replicate to process jobs, you don’t need to worry about that particular issue.

    posted in Google Sheets read more
  • Jon Jon

    @eliasnilsson19 How are you locally accessing the files uploaded to the Google Form? Are they being synced back to your computer via Google Drive (File Stream or Backup and Sync)? You would need to build a formula in your Sheet that transposes and concatenates a local file path based on the original file name of the file being uploaded-- the generated URLs for Google Drive are not absolute links, so Templater will fail to download them correctly (Templater can download URLs that are absolute links to the files, ending with a file extension). I’m not certain whether it is possible to get just the filename of the uploaded file via Google Forms, but if it is, that is how you would have to approach it. Outside of that, you’d have to look at a different form builder that can handle the requirement of uploading the file and pushing the absolute URL back into your Sheet. I know that it is possible to do with JotForm, if configured correctly.

    posted in Google Sheets read more
  • Jon Jon

    @darrencase There are several ways to set text color. We’ve got a sample project on our GitHub repo that demonstrates one of the ways, but there are others as well.

    posted in Data Sources read more
  • Jon Jon

    @darrencase I’m not familiar with how that script works. Are you using the same data for both that script and Templater?

    I think Arie linked you to our using data in expressions support page. Long and short, you can bring in values to your project as text in a text layer, then parseInt() (for numerical data) the sourceText of that text layer to use in numerical expressions on other layers. You can also do this directly with JSON data imported into AE, but be aware that AE’s JSON import support is actually finicky and prone to breaking in one particular way that makes it problematic for Templater (though I’m not sure that what you’re dealing with is the same issue).

    posted in Data Sources read more
  • Jon Jon

    @darrencase also, it might be helpful to watch this video to see a demonstration of how comp swapping works, to hopefully make it clearer.

    posted in Batch Output read more
  • Jon Jon

    @darrencase You could actually skip about 4 or 5 steps. Each JSON object is one “job” of data for your project. The formatted data should contain all of the variable data from your raw data, as well as data about the After Effects project-- namely which comps you are using to swap into your master “target” comp using the slideshow method I linked. Steps 3-7 should be just one step for Templater. The data swap inside the comps, swapping and re-timing comps (if necessary), and rendering all happen in one step.

    posted in Batch Output read more