New Spreadsheets?

[ex-Pittsburgh Pirates]

Thinking about using more of a database > query approach on the spreadsheets. Would make maintenance easier I think. Also, would only need 1 link/bookmark to view all teams.

Take a look. What do you think? (Click on the little arrow in the team name cell to switch teams.)

docs.google.com/spreadsheets/d/1zUVEADT4Q4audiQBXkR-7Ec6OGRTPmkngsNrONF-paU/pubhtml?gid=18&single=true

This is just a demo sheet.

[ex-Pittsburgh Pirates]

Little arrow isn't working on the demo view. Hmmm. More experimentation needed.

[ex-Pittsburgh Pirates]

Ok. Try this...
docs.google.com/spreadsheets/d/1zUVEADT4Q4audiQBXkR-7Ec6OGRTPmkngsNrONF-paU/edit?usp=sharing

[ex-Pittsburgh Pirates]

THe only field you can change is the team name. Try choosing a different team in the drop down and watch the players change. Ignore the numbers for now (though the player contracts are and should be correct). The players are all kept on a separate hidden spreadsheet. This team sheet is just reading from the separate 'database' of players.

[Minnesota Twins]

On phone but i cant chg team name.

[ex-Pittsburgh Pirates]

May 14, 2015 15:14:42 GMT -5 Minnesota Twins said:

On phone but i cant chg team name.

Thanks for the input. I have the same issue on mobile. I'll have to rethink this a bit thanks