@rivalpro I wrote a forum post a while back for this type of “slideshow,” with a variable number of slides. You can find it here.

There is one minor tweak that you can do with this method. We’ve added comp switching via a flag in your data (wrapping the comp name in double curly braces) to the latest version of Templater, so instead of swapping with a video asset, you could swap with an empty 2-frame comp that is double the framerate of the containing comp.

@pej87 We are always happy to help. Please submit a ticket to support@dataclay.com for more information.

Thanks!

@rivalpro Yes, you can pull in the value as a text layer, then use an expression to tie your shape size / percent completion to the SourceText property of the text layer by wrapping it in a parseInt(). If your text layer is “text-1”, and your text layer is in the same comp as whatever numerical value you are using to control your bar, the expression would be:

parseInt(thisComp.layer("text-1").text.sourceText)

That would convert your text value from being just a text string into a number.

@rivalpro Unfortunately, what you are encountering here is a known issue with using Bot and Google Sheets. Can you somehow, make an invisible field that does the “stitching” of the other fields in the form and inject that invisible field into the Google Sheet. In other words, the output column should be hard coded. I know this is not what you want to hear, but it is a limitation of writing data back to a Google Sheet using their API.

Unfortunately, yes text animators can throw off Templater’s layout logic. You will like have to tweak the animator’s params based on how the data looks for various jobs. Does the issue show up each time you preview? To gain a clearer sense, can you post a short screencast or GIF capture?

Thanks,
Arie

Also, after first download and import on empty placeholder, after that if I change the link to the image, it wont download it again, I need to put new empty placeholder to download new image. Is it possible to fix that in some way ?

@rivalpro

The way to avoid the issue is to use a # before all hex values in spreadsheet data. This shouldn’t happen with JSON data, as it is a quirk of how spreadsheet software (including Google Sheets) attempts to detect the data type in a cell and set the formatting. Using # will override the Sheet from setting incorrect formatting while the Bot is processing its data. While the Bot is running, the Sheet will think that you are changing data, and will try to automatically format all-numerical hex values as numbers unless they use the #.

Hi Rival,

Apologies for the long delay on the forum reply. We’re you able to get this solved? It sounds like a cacheing issue or possibly that either AE or AME need to be restarted. Were you able to get it resolved?

@spelgrift Take a look at the table in our documentation that defines each event and when it is broadcast within Templater’s algorithm. This should help you decide which events to register your scripts to.