var wsData = SpreadsheetApp.openById(ssID).getSheetByName("SF Report");
var form = FormApp.openById(formId);
function inductionAssessment() {
var item = form.getItemById(260761081);
var values = wsData.getRange(2,13,wsData.getLastRow()-1,1).getValues().filter(String);
item.asListItem().setChoiceValues(values);
Logger.log(values);
}
Hi! I have been trying to solve this but for some reason it keeps throwing this error, I have checked all the ID of the form, and they are all okay, any reason why this happening please?
How come this code work?
var wsData = SpreadsheetApp.openById(ssID).getSheetByName("SF Report")
var form = FormApp.openById(formID)
function coachingAssessment() {
var item = form.getItemById(401000225);
var values = wsData.getRange(2,13,wsData.getLastRow()-1,1).getValues().filter(String);
item.asListItem().setChoiceValues(values);
Logger.log(values);
}