I will have various team rosters with all the same headers and type of data (folder, name, team, access code, coach, etc) but would like to change the csv data for each team and possibly have a have some generic sheets so I can manually add data. Is there a way to load different data sheets into one Appsheets "template" by selecting the sheet from drive or a folder on my phone?
Nope.
So I would have to make copies of the same Appsheet with different sheets as the source data?
Tough to say. You could do that, or you could do it all in one app. Off the top of my head, based on the very little info you've provided, I'd imagine having a separate table to import a CSV, then have an action that moves the imported data into the main table. The main table would include the data for all teams. Where are the CSV files coming from?
I would get the data from leagues and add that data to a google sheet along with sequential folder numbers and access codes in a separate columns each row would have unique info per player/student. Plus I would add a Checked In box so I would know if everyone was there
User | Count |
---|---|
16 | |
10 | |
8 | |
5 | |
5 |