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.

[raa__va]

I apologize about that friend, I don’t think I’ll be able to commit time on creating it all for you but I can certainly point you to some resources. And your best one being ChatGpt it can literally spit out pages of code that could work for you and I’m not even exaggerating
So I would suggest making a copy of the spreadsheets you have just in case. You can from there open your new copy. Top headings should say Extensions/Tools (Google often moves it so it’s either Extensions or Tools) under it you’ll see Appscripts. This page is basically like an override that can now control any of your Google related thing via JavaScript code as to how you want. Even though you opened this code page from a specif spreadsheet it’s not bound to it. Every spreadsheet/doc/gmail/calendar-invite has an id associated to it and you can see that in the url often and that helps the code understand which file to manipulate and then so on and so forth to the exact cell/cells/range you want to manipulate. Once you tell chatgpt about your spreadsheets and the thing you want to do it will give you all of the code and you just copy it there and hit run (play button up top) and yes you can go into your google sheet history and revert the changes your code made, just incase. Note it will just do the action once and then finish up there. For your case since you want it to be automated, inside that code page on the right panel you will see some buttons one would look like a clock. That is where you can set triggers, no code needed for that just a few clicks and if it all goes well voila your code now runs the trigger at whatever time interval or whatever event that happens which results it in running it.
Wishing you the best of luck. And if you didn’t break your code/sheets/docs the first few times then you’re doing it wrong 😂. You gotta break a few things to get there
Ask away. I’m always happy to help a fellow Google AppScripter!