Save
Saving
  • dwalters dwalters

    @ariestav pssshhht, of course it was ridiculously easier LOL

    Thank you.

    posted in Google Sheets read more
  • dwalters dwalters

    @ariestav Okay, I’m not sure which version of Templater is being used in that video, which is probably why I was confused when I watched it before, but I don’t have an option for colors anywhere within the Templater “effect” I apply to my layer. I am using Templater 2 -Rig, and I’m assuming that’s probably why, and that sucks, but I have a slightly annoying workaround.

    Capture.PNG

    posted in Google Sheets read more
  • dwalters dwalters

    @Jon Very nice, are there any examples of this anywhere? I’m not really sure where to even start to accomplish something like this. However, it sounds amazing, and I’m definitely going to be diving deeper into this.

    posted in Google Sheets read more
  • dwalters dwalters

    @ariestav So, in your example, I’m not quite sure how I could set that up. Are you pointing to specific comps within a project, or different projects? I’m trying to utilize different pieces of information within the same project, but that may just not be possible in a clean, easy way for outsiders to easily update information I suppose.

    I’ll give you a working idea of my particular implementation:

    I currently have a “scoring box” in the top left. It lists the team name, current score, the inning, what bases are loaded (which is being driven by manual checkboxes) and how many outs there are (which is also being driven manually by checkboxes)

    Then in the top right I have a “Due Up” box which simply lists the player and their respective number.

    I also have another info box that swaps spots with the “Due Up” box I call an “Info Box” which houses the current batter along with the next 3 batters and the numbers for ‘Runs’, ‘Homeruns’ and ‘Errors’.

    Right now I have a controller setup using mostly if/else statements and dropdown menus to control what boxes are being shown.

    So, I guess my question is, is there a better way to do this? I would sort of like to keep this within Google sheets just because it’s an easy to understand way for the team to update the numbers, but if there’s a better way, I’m all for it.

    Thanks for your help thus far, you’re very kind and I appreciate that.

    Scoring.png
    dueUp.png
    Scoring.png
    lowerThird.png

    posted in Google Sheets read more
  • dwalters dwalters

    I’m currently making in-show graphics for a minor league baseball team and using one sheet for every game, but I have nested sheets for the roster and another one that will be updated with the batting order for each game.
    Is there a way to use these separate sheets that reside in one sheet? Or is there a better, more practical way to handle something like this that I’ve not thought of?

    This seems confusing typed out, so if it doesn’t make sense I can do screenshots or something to help explain.

    posted in Google Sheets read more
  • dwalters dwalters

    Seems easy enough. I’m not sure if it will help yet, as I will need to give it a whirl, but I’m sure it will do exactly as I need. Thank you.

    posted in Google Sheets read more
  • dwalters dwalters

    I’ve rigged up a lot of matchups for a minor league baseball team and the only missing piece is changing the background color with the rest of the team stuff (images/name etc). I have seen the repo for using JSON, but is there a way to do so utilizing the same Google sheet I’m already using that has all of the current information?

    I’m using Templater 2, if that makes a difference.

    Thanks, fam!

    posted in Google Sheets read more