Quote:
Originally Posted by EricH
If hidden sheets can be done, it might be a good idea to have a "list input" sheet that will dump to a hidden sheet, if that can also be done.
|
I was considering having each FF team having their own hidden sheet so that they could make edits after without confusing the draft runner.
Quote:
Originally Posted by EricH
With an online component, shouldn't be too hard to rig one Gdoc to scrape another--bet I could do it with Excel, too, in terms of picking up data and dropping it off in a sheet.
|
Yeah, I will look at scraping from on g-doc to another and if that is possible.
EDIT
So it seems hidden sheets are a no-go. However I did end up getting scraping working, so each team can have their own submission sheet. Currently I can pull from one sheet to another, and it updates pretty quickly, have a look.
Sample submission sheet #1
Sample submission sheet #2
Autodraft Testing
EDIT 2
I have it automatically removing already picked teams from the list for each team's first picks. It's not pretty work, but it's functional