แชร์บทความนี้

google form ดึงข้อมูลจาก google sheet

Script ส่งข้อมูลจาก Google Sheet ไปยัง Google Form

function updateForm(){

// call your form and connect to the drop-down item

var form = FormApp.openById(“****formurl****“);

var namesList = form.getItemById(“****data-item-id****“).asListItem();

// identify the sheet where the data resides needed to populate the drop-down

var ss = SpreadsheetApp.getActive();

var names = ss.getSheetByName(“Sheet1”);

// grab the values in the first column of the sheet – use 2 to skip header row

var namesValues = names.getRange(2, 2, names.getMaxRows() – 1).getValues();

var studentNames = [];

// convert the array ignoring empty cells

for(var i = 0; i < namesValues.length; i++)

if(namesValues[i][0] != “”)

studentNames[i] = namesValues[i][0];

// populate the drop-down with the array data

namesList.setChoiceValues(studentNames);

}

แชร์บทความนี้