Microsoft Forms Registering for Sports League

SteveP29

New Member
Joined
Jul 1, 2007
Messages
31
Office Version
  1. 365
  2. 2019
Platform
  1. 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.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Yes, it was, for anyone wondering.

Another Google search pointed me in the right direction, all I had to do was add another question after the minimum number of players to each subsequent player and specify an action dependent on the response.
 
Upvote 0
Solution

Forum statistics

Threads
1,221,310
Messages
6,159,176
Members
451,543
Latest member
cesymcox

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top