14c Appointment System

14c-Appointment System

function meetingTimes() {
  var form = FormApp.getActiveForm();

//Get current times on Form
  var timesArray = [];
  var questions = form.getItems();
  var timeQ = questions[1].asMultipleChoiceItem();
  var choices = timeQ.getChoices();
  for (var i = 0; i < choices.length; i++) {
   timesArray.push(choices[i].getValue());
  }

//Get all form responses and the latest one  
  var formResponses = form.getResponses(); 
  var latestFR = formResponses[form.getResponses().length-1];
  
//Get submitted time from form
  var itemResponses = latestFR.getItemResponses();
  var itemResponse = itemResponses[1];
  var submittedTime = itemResponse.getResponse();   

//Remove submittedTime from array
  for (x in timesArray){
   if(timesArray[x] === submittedTime) {      
    var indexT = timesArray.indexOf(submittedTime);
    timesArray.splice(indexT, 1);   
   }    
  }

//Replace time question on form with array
  timeQ.setChoiceValues(timesArray);     
}