google forms go to section based on answer not working

#Google forms go to section based on answer not working code

#Google forms go to section based on answer not working code

I cannot add an 'other' option to questions that contain skip conditions, at least not by using showOtherOption(true), as seen in the code example below - it also throws the exception Invalid data updating form. Show Questions Based on Answers in Google Forms 1 Open a form in Google Forms. it is treated as a completely new question, making it difficult to analyze the results. However, deleting and re-adding the same question will create a new column in the sheet that receives the responses (starting in column H of the test sheet), despite using the same question wording/title, i.e. My workaround is to completely delete and reconstruct the respective question to retain the skip logic (done in the code snippet below for Question 2). Trying this with setChoiceValues(MY_VALUES) will throw an Exception: Invalid data updating form. I cannot modify the response choices of questions that have 'Go to section based on answer' conditions attached to the choices (such as 'Question 2' in the test form). Upon submission of the form to the sheet, a Script function updateGoogleForm() is triggered (deactivated in the test sheet, code below) that modifies the Google Form so that the new 'other' mentions become part of the pre-defined response choices. Every multiple choice question includes an 'other' option. I have a Google Form (see simplified test form here) that sends the submissions to a Google Spreadsheet (see test sheet here). Then, to add the conditional logic feature, go to the Section based on answer option in a specific question, and add appropriate sections to each option.