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 every time 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.
Formula I have used to select the random 5 from my 14 (in Sheets):
=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))
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.
Aucun commentaire:
Enregistrer un commentaire