问我可以动态更新Google Forms列表框的内容吗

EN

//bonus, gets values from first column of spreadsheet and returns them
function getValues() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var lastRow = sheet.getLastRow();
  var range = sheet.getRange(1, 1, lastRow);
  var values = range.getValues();

  return values;
}

//what you'll need to call initially to create the form, and store id in project properties
function createForm() {
  var values = getValues();
  var form = FormApp.create('Test Form');
  var list = form.addListItem();
  var listItems = list.setChoiceValues(values);
  var formId = form.getId();

  PropertiesService.getScriptProperties().setProperty('formId', formId);
}

//use this to update on change event. Trigger can be created for this.
function updateForm() {
  var values = getValues();
  var formId = PropertiesService.getScriptProperties().getProperty('formId');
  var form = FormApp.openById(formId);
  var list = form.getItems(FormApp.ItemType.LIST)[0];
  var listItems = list.asListItem().setChoiceValues(values);
}