Ich habe erfolgreich ein Google-Formular erstellt, das mit dem hier verwendeten Code aus einer Tabelle ausgefüllt wird:https: //www.youtube.com/watch? v = BYA4URuWw0s. Jetzt möchte ich das Formular zu einer bestimmten Frage weiterleiten, die auf der Antwort einer vorherigen Frage basiert, ohne die Aktualisierungsfunktion aus der Tabelle zu verlieren. Ich habe versucht, den Code von hier aus zu ändern:Wie wird Go_To_Page im Formulardienst bei Multiple Choice zugewiesen?, habe aber noch kein Glück. Unten ist, was ich ab sofort habe. Ich bin sehr neu in der Programmierung und jede Hilfe wird sehr geschätzt. Danke im Voraus!!

//insert your form ID
var FORM_ID = '1iA8jX720Eqi_GKwiA1RJiWwzt3vJ8XOOAqh-SjO9mXM';
//insert your sheet name with a list
var EMP_SHEET_NAME = 'empROSTER';
//insert your range of lis
//insert list id (before run getItemsOfForm function and look at t as A1Notation
var range1 = 'B2:B';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM_ID = '1097376824';

  /* 
  add date question? - 
    form.addDateItem()
        .setTitle('Date of Work Performed')
  */

//insert your sheet name with a list
var JOB_SHEET_NAME = 'jobROSTER';
//insert your range of list as A1Notation
var range2 = 'C2:C';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM2_ID = '773657499';

//insert your sheet name with a list
var AT_SHEET_NAME = '300';
//insert your range of list as A1Notation
var range3 = 'B2:B';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM3_ID = '1884670833';

//insert your sheet name with a list
var DT_SHEET_NAME = '1000';
//insert your range of list as A1Notation
var range4 = 'B2:B';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM4_ID = '379969286';

//insert your sheet name with a list
var CT_SHEET_NAME = '2000';
//insert your range of list as A1Notation
var range5 = 'B2:B';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM5_ID = '128282987';

//insert your sheet name with a list
var HOURS_SHEET_NAME = 'hourROSTER';
//insert your range of list as A1Notation
var range6 = 'B2:B';
//insert list id (before run getItemsOfForm function and look at log CTRL+Enter)
var ITEM6_ID = '1385334889';


  //Section in question
  function createGoTo(){
    var af = FormApp.openById(FORM_ID);
    var pAdmin = af.getItemById(AT_SHEET_NAME);  //use findPageIds to get the page id of a pre-created page
    var pDesign = af.getItemById(DT_SHEET_NAME);
    var pCon = af.getItemById(CT_SHEET_NAME);
    var item = ITEM2_ID
    //create choices as an array
    var choices = [];
    choices.push(item.createChoice('Administration Job', pAdmin));
    choices.push(item.createChoice('Design Job', pDesign));
    choices.push(item.createChoice('Construction Job', pCon));

    // assignes the choices for the question
    item.setChoices(choices);
  }

  function findPageIds(){
    var af = FormApp.getActiveForm();
    var pages = af.getItems(FormApp.ItemType.PAGE_BREAK);

    for (i in pages){
      var pName = pages[i].getTitle();
      var pId = pages[i].getId(); 
      Logger.log(pName+":"+pId); 
    }  
  }
  //End of section in question


function updateEmpName() {
var values_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(EMP_SHEET_NAME).getRange(range1).getValues();
values_[0][0] = values_[0][0].toString();
for(var i = 1; i < values_.length; i++){
 // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
if(values_[i][0] != "") {
  values_[0].push(values_[i][0].toString())
  }
 }
 var form = FormApp.openById(FORM_ID);
 var list = form.getItemById(ITEM_ID);
 list.asListItem().setChoiceValues(values_[0]);
}

function updateJobName() {
var values2_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(JOB_SHEET_NAME).getRange(range2).getValues();
 values2_[0][0] = values2_[0][0].toString();
     for(var i = 1; i < values2_.length; i++){
    // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
  if(values2_[i][0] != "") {
      values2_[0].push(values2_[i][0].toString())
 }
 }
  var form = FormApp.openById(FORM_ID);
 var list = form.getItemById(ITEM2_ID);
 list.asListItem().setChoiceValues(values2_[0]);
}

function updateAdminTasks() {
 var values3_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(AT_SHEET_NAME).getRange(range3).getValues();
 values3_[0][0] = values3_[0][0].toString();
 for(var i = 1; i < values3_.length; i++){
  // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
  if(values3_[i][0] != "") {
   values3_[0].push(values3_[i][0].toString())
  }
 }
 var form = FormApp.openById(FORM_ID);
  var list = form.getItemById(ITEM3_ID);
  list.asListItem().setChoiceValues(values3_[0]);
}

function updateDesignTasks() {
 var values4_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(DT_SHEET_NAME).getRange(range4).getValues();
 values4_[0][0] = values4_[0][0].toString();
  for(var i = 1; i < values4_.length; i++){
   // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
   if(values4_[i][0] != "") {
    values4_[0].push(values4_[i][0].toString())
  }
 }
 var form = FormApp.openById(FORM_ID);
  var list = form.getItemById(ITEM4_ID);
  list.asListItem().setChoiceValues(values4_[0]);
}

function updateConstructionTasks() {
 var values5_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(CT_SHEET_NAME).getRange(range5).getValues();
 values5_[0][0] = values5_[0][0].toString();
 for(var i = 1; i < values5_.length; i++){
   // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
   if(values5_[i][0] != "") {
     values5_[0].push(values5_[i][0].toString())
   }
  }
 var form = FormApp.openById(FORM_ID);
 var list = form.getItemById(ITEM5_ID);
  list.asListItem().setChoiceValues(values5_[0]);
}

function updateHours() {
 var values6_ = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(HOURS_SHEET_NAME).getRange(range6).getValues();
 values6_[0][0] = values6_[0][0].toString();
for(var i = 1; i < values6_.length; i++){
  // the if-block from https://productforums.google.com/d/msg/docs/v8ejYFpoGa8/HVqg6auIAg0J
 if(values6_[i][0] != "") {
   values6_[0].push(values6_[i][0].toString())
  }
 }
 var form = FormApp.openById(FORM_ID);
 var list = form.getItemById(ITEM6_ID);
 list.asListItem().setChoiceValues(values6_[0]);
}

function getItemsOfForm(){
 var form = FormApp.openById(FORM_ID);
 var items = form.getItems(FormApp.ItemType.LIST);
 for(var i in items){
  Logger.log('id: ' + items[i].getId() + ' title: ' + items[i].getTitle());
 }
}