Save
Saving
  • 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

    @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

    @darrencase “id” is a reserved column name in Templater, and it is used for Templater to identify which object is being referenced. JSON ids.

    posted in Pulling Data read more
  • 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

    @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

    @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

    @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
  • Jon

    @darrencase on your tweet we mentioned using comp swapping for your precomps. You can follow the “variable slideshow” instructions on this post, but instead of swapping video clips, you can swap your city precomps in and out.

    We do have a Templater Bot NodeJS stitching script on our GitHub repo, but I don’t know that that would be exactly what you are looking for, and would likely overcomplicate the workflow.

    posted in Batch Output read more
  • Jon

    @darrencase Yes, you can use JSON as a data source, though the JSON needs to be “flat” with no nested object arrays. You can take a look at our JSON documentation. JSON has some significant advantages over Sheets/TSV data when it comes to being able to adapt data points being passed to Templater on a per-job basis, but it can be not as user-friendly for a lot of people who are already extremely familiar with Sheets. JSON can effectively act as if each object array is a unique worksheet with values that are only relevant to that particular job. If it were a Sheet, it would be like having different columns on a per-job basis. If you still want to use a Sheet, did you take a look at the sample Sheet that I made for Keith’s case?

    posted in Templates read more
  • Jon

    @pbretz Are you able to share a screen recording illustrating the issue? If you want it to be private, you can create a support ticket.

    posted in Templater Bot Deployment read more