title: google forms multiple choice grid: validate
body: <p>I am trying to put together a multiple choice grid in a google form, which should have some logic in it.</p>
  
  <p>The idea is that people can use the form to predict a starting line up from a football team. I want to keep the form as easy and small as possible, thus going for a multiple choice grid.</p>
  
  <p>The design I had in mind to use is pretty simple:</p>
  
  <p><img src="https://image.ibb.co/fANXcJ/Capture.png" alt="example of form"></p>
  
  <p>The logic I need is:</p>
  
  <ul>
  <li>you can and must put only 1 player on goal </li>
  <li>the total number of players selected should be 11</li>
  <li>if you reach the 11 selection, you shouldn't be able to select any more players</li>
  <li>if you have selected 1 player on goal, you shouldn't be able to select any more players on goal</li>
  </ul>
  
  <p>Ideally: the check should be dynamic, while you are filling in the form. As soon as you reach the 11th name, you shouldn't be able to continue selecting options.</p>
  
  <p>I have already tried tinkering with some add-ons for google forms, but they all struggle with the multiple choice grid. </p>
  
  <p>Does any one have any advice how and if I can even achieve this with google forms or maybe it's wiser to move on to another solution?</p>