title: Change a question on a form based on cell in Google Sheets
body: <p>Completely new to coding and am teaching myself as I go along. Pretty chuffed with what I have achieved so far and now want to push my boundaries of learning!</p>
  
  <p>So context - I organise youth football tournaments. Teams enter the tournament via a google form. The form goes into a google sheet that I then use formulas to ensure I can see how many teams have entered per each age group. Each age group has a maximum number of teams it can have in the tournament. The link to a live form is <a href="https://forms.gle/8VoBddM8AAJMFXqM7" rel="nofollow noreferrer">https://forms.gle/8VoBddM8AAJMFXqM7</a></p>
  
  <p>What I want to do</p>
  
  <p>At the moment, I have to manually edit the form when an age group becomes close to being full. For example clubs can enter a max of two teams. When there is only one space left, I currently manually have to delete the option to enter 2 teams ensuring one 1 team can be entered. This sometimes results in me not being able to do it fast enough and 2 teams being entered even though there is only 1 space available. So it all becomes a bit messy</p>
  
  <p>So - is there code that when a cell in sheets equals a specific number, the google form automatically deletes the option to enter 2 teams so I don't have this issue?</p>
  
  <p>Secondly.......</p>
  
  <p>When an age group becomes full, I have to manually edit the form to direct any future entries for that age group to a different section of the form for teams to fill out a reserve list form. Like the above, I sometimes can't do this quickly enough. So, is there any code I can use to automatically direct the user to a different section of the form based on the value of a cell in sheets?</p>
  
  <p>So in summary</p>
  
  <p>One thing I need is to automatically delete an option in forms based on a cell value in sheets. And secondly, automatically redirect to a different section in forms based on a cell value in sheets</p>
  
  <p>I am new to all this and learning so please be kind! :)</p>