SteveP29
New Member
- Joined
- Jul 1, 2007
- Messages
- 38
- Office Version
- 365
- 2019
- Platform
- Windows
Last year, the pool league (UK, 15 ball game) that I do admin work for used Microsoft Forms to collect and collate data from the teams instead of printing 20 sheets of paper with lines for them to write in their players and details and hand back at the next monthly meeting.
I created the form and surprisingly for me, it worked well.
For the coming season, I'm looking at updating and improving the form.
The basic set up of questions is:
-Team Name
-Player Name
-New Player or Returning Player
-Phone Number
The Team Name is a standalone section
The rest of the questions need to be completed for all of the team members.
Once all the data has been entered for the first player, the form moves to a new section and starts again at Player Name.
What I'm thinking about is, I've allowed enough sections to register 10 players per team, but not all of the teams have the same number of players registered, so I'd like to be able to allow the person completing the form to submit the form once they have got all of their players input (if they have less than 10) rather than them have to cycle through every section till they get to the tenth player.
I've Googled and read about branching but haven't had a chance to investigate that properly yet, is that the right track to be heading down or can anyone suggest a better method?
Thanks in advance.
I created the form and surprisingly for me, it worked well.
For the coming season, I'm looking at updating and improving the form.
The basic set up of questions is:
-Team Name
-Player Name
-New Player or Returning Player
-Phone Number
The Team Name is a standalone section
The rest of the questions need to be completed for all of the team members.
Once all the data has been entered for the first player, the form moves to a new section and starts again at Player Name.
What I'm thinking about is, I've allowed enough sections to register 10 players per team, but not all of the teams have the same number of players registered, so I'd like to be able to allow the person completing the form to submit the form once they have got all of their players input (if they have less than 10) rather than them have to cycle through every section till they get to the tenth player.
I've Googled and read about branching but haven't had a chance to investigate that properly yet, is that the right track to be heading down or can anyone suggest a better method?
Thanks in advance.