my goal is to create a script that will randomly select 5 questions from spreadsheet and insert them into Google Form. I would like to do this with each form opening, so that each respondent has a unique, random set of questions.
Given that there is no option to set a trigger for the respondent to open the form and set random questions with them. I built a script that randomizes the questions every minute. However, there was a problem that when someone starts to fill out the form, and I run the script, the questions will update already in the resolved script!
Do you have any idea how to solve this from within Google Apps Script?
