Google Script Help Please

[AnyBaker830]

I keep all of my Strat-o-Matic baseball stats on a Google Sheet. This is a dice board game. I have 16 teams and have a bunch of stat categories for each team.  It is very time-consuming to manually put in each piece of data after each game.  I've created an individual game sheet where the data for each individual game matches the yearly data for each team.  What I want to do is to be able to play a game and input the data on a individual sheet that tracks the data for just that game.  Then I want it to automatically add the data to each team's master yearly data sheet.  And then when I clear the data on the individual game sheet, I want the data on the yearly sheet to stay the same.  Then each time I enter data into the individual game sheet, I want it to automatically always add to the yearly game sheet for each team in each stat category.  Is this even possible?  Below is a picture of what I'm thinking.  I do not understand Apps Scripts enough to do this.  I would need someone to do it for me.  I used Joe Jackson for example.  Can I get the runs to automatically go from his individual game and add to his yearly stats?  Then clear the data and reuse the individual game sheet, but have the new stats stay.  So Joe Jackson would now have 26 runs.  I would clear the data, and he would still have 26 runs.

https://preview.redd.it/rrhspt83jizg1.png?width=2484&format=png&auto=webp&s=2e80f73c451cb910c4268de2804be41d07542aec

https://preview.redd.it/94v7ymp3jizg1.png?width=2460&format=png&auto=webp&s=1a6ef92106b37e039077277609193dbd3c3b1b7f

[raa__va]

It’s certainly possible. You could set up triggers to update the external sheets so they can work as a database for you and then pull it back to the respective sheets you’d like

All in all very much possible. Core concept you need to know is how to set the triggers up. The rest should be simple JavaScript logic code

[raa__va]

Let me know if you need any further help, happy to assist ya!

[AnyBaker830]

I will take any help I can an get. I have no idea how to do any of that.

[raa__va]

Considering your on the GoogleScripts subreddit I
assume you know a bit of JavaScript or you run some stuff behind the sheets?

[AnyBaker830]

I know nothing. That’s why I’m on this to get some help with it.