I use data sources a lot in my live streamed show. I use them to populate fantasy score results, pick ‘em contest results, previous days scores from various leagues (NBA, NFL, MLB, NHL), stats, news, and more.

A lot of this data is gathered through scripting using Google AppScript and Google Sheets and the Espn API, so I’m constantly coding and tweaking along the way so sometimes I’ll break a script or code or spreadsheet. The spreadsheet is the big one because in doing so this seems to break the data source connection to the title, which resets the mappings, which means I have to go back and remap everything, which is an absolute PITA.

For example, last night I had to re-map all my fantasy league titles.

That means:

10 team names
10 team records
10 team owners
10 team scores

X 4 leagues

That means I had to re-map 160 fields, and have to do so every time it “magically” resets ( I still haven’t figured out why it does this sometimes).

Is there a config file where the mappings are stored? (doggy got me thinking after my formatting rant 🤣)

If not can these mappings be scripted?

Anything has to be easier than doing this by hand every time.

oh niiiiice. This changes things a bit for me. Phew! Thanks Doggy! You have saved me AGAIN!