问提交时触发的Google表单是在推送到电子表格之前还是之后触发的

EN

function setPrice() {
  var ws = SpreadsheetApp.openByUrl("spreadsheet_link");
  var ss = ws.getSheetByName("BPS")
  var inventory = ss.getRange("A2:A280").getValues();
  var prices = ss.getRange("B2:B280").getValues();
  var prices_no_bp = ss.getRange("C2:C280").getValues();

  var form = FormApp.getActiveForm();
  var formItems = form.getItems();

  var item_selected = form.getItemById("Question 1").asListItem();
  var bp_selected = form.getItemById("Question 2").asListItem();
  var price_selected = form.getItemByID("Price").asMultipleChoiceItem;
  var formResponse = form.createResponse();

// scan the inventory list, find the item selected, and return the price
  var this_price = 999999999;
  var sl = 8;
  for (var i = 0;i < sl; i++) {
    if (inventory[i] == item_selected) {
      if (bp_selected == "Yes") {
        this_price = prices_no_bp[i];
      } else {
        this_price = prices[i];
      }
    }
  }

// Create the multiple choice entry
// Change the response to the same value
// Attach the response to the form
  price_selected.createChoice(this_price);
  var response = price_selected.createResponse(this_price);
  formResponse.withItemResponse(response)

// Responses are ready for submission

}