title: Google Form random questions from a bank, different every time Form is opened
body: <p>I have a list of 14 questions in a Google Sheet that I would like to use 5 of at random to populate a Google Form. I have managed to do this using the FormCreator add-on to some degree but I would like the questions to be randomly generated <strong>every time</strong> the form is opened. At the moment the form populates with 5 random questions but will always stick to the original 5, regardless if the selection changes.</p>
  
  <p>Formula I have used to select the random 5 from my 14 (in Sheets):</p>
  
  <pre><code>=ArrayFormula(Array_Constrain(vlookup(Query({ROW($A$2:$A$16),randbetween(row($A$2:$A$16)^0,9^9)},"Select Col1 order by Col2 Asc"),{row($A$2:$A$16),$A$2:$A$16},2,FALSE),5,1))
  </code></pre>
  
  <p>I am trying to create one form that will be different every time my students open it, rather than painstakingly creating 100+ 'random' forms manually to be used.</p>