Multiple rows in the same composition

---

Hey guys,

Before I purchase templater, trying to make sure I can do what is needed with this plugin. Right now I’m trying to take a data set and spread it across 7 different layouts. The issue is that the data is provided to me in rows (Sample sheet here - https://docs.google.com/spreadsheets/d/1N14IKR5vBFaS2VwDRqlXVQmoNWfa0dHzVznHN1CvcHs/edit?usp=sharing ) and not columns. The final output needs to look something like this (https://drive.google.com/open?id=1NcjAFSHl9Yj6Nue5kjAHzti4POwJp1Ag) and pull multiple rows into the same composition. Is this even possible with this plugin?

I know this use is a little different than what I see most rigged templates doing, but hoping this is possible.

edit - I need to do this across 50 venues with varying calendars/tours. Copying/Pasting would be hell,

@keithvlk

If you are using a Sheet, Templater requires that each “row” is equal to one “job.” You will need to do some sort of conversion or correction on the data to get it into a format that Templater can understand. Your best bet would be to create formulas in a separate worksheet that reference the data in your source Sheet. I’ve created a sample Sheet based on yours that shows one way this could work. Feel free to copy and play with it.

The slight complication is that your 7 layouts can’t be directly queued for rendering simultaneously with Templater Pro/Bot, but you can swap in all of the data to all of the layouts for one “set” of data, then manually queue them, or you can copy a row seven times, then add a target column in your data, which allows you to choose which comp to render– in this second case you would be able to batch render.

Thanks for the sheet conversion idea…that is going to come in handy for this.

As for the 7 layouts, I’m getting a little lost. ( Sorry, new to this whole templater world.) So you’re saying its not possible to send the same 5 dates to 7 different layouts at the same time? I’m fine if I need to manually queue everything. For me, this is just saving me from copy/pasting everything for every venue every month.

@keithvlk sorry for the confusion. Yes, you can swap the data in any and all comps within your project at one time. The limitation I was speaking of is the concept of a “target,” which is the comp that you can set Templater to automatically render once the swap is complete. You can only have one “target” per row of data, but you can swap the data, then add all of your layouts to the render queue manually-- this skips needing to use Templater’s automatic rendering, but it still saves you a significant amount of time tediously swapping the copy for all of those layers.