this receive the data from a google form then it get the string from the checkbox and split it by "," then it put them back in a google sheet in a different column

GoogleFormToSheetsScript.js

function onFormSubmit(event) {

  record_array = []

  var form = FormApp.openById('1kpoqfzJ4QGlYU5iDkeeTNheCe3AfeTZ4Eu-AmnbIQv4'); // Form ID
  var formResponses = form.getResponses();
  var formCount = formResponses.length;

  var formResponse = formResponses[formCount - 1];
  var itemResponses = formResponse.getItemResponses();

  for (var j = 0; j < itemResponses.length; j++) {
  var itemResponse = itemResponses[j];
    var title = itemResponse.getItem().getTitle();
    var answer = itemResponse.getResponse();

    Logger.log(title);
    Logger.log(answer);
    Logger.log(record_array);

    record_array.push(answer);
  }
   
 var date = record_array[0];
 var startDate = record_array[1];
 var endDate = record_array[2];
 var lunchTaken = 1;
 var names = record_array[3];

if(record_array[4] = "Si"){
  lunchTaken = 0;
}
 
   AddRecord(names,date,startDate,endDate,lunchTaken);


}

function AddRecord(names,date, startDate, endDate,lunchTaken) {
  var url = 'https://docs.google.com/spreadsheets/d/1zUFcPhqWHLu5mv7JvWxiD7ntyLhDhDhnCfocuplW7jw/edit#gid=399244888';   //URL OF GOOGLE SHEET;
  var ss= SpreadsheetApp.openByUrl(url);
  var dataSheet = ss.getSheetByName("Fijos");


  for (var i = 0; i < names.length; i++) {
    var name = names[i];

      var nextRow = dataSheet.getLastRow() + 1;

      
    dataSheet.appendRow([
      name,
      date, 
      startDate, 
      endDate,
      lunchTaken,
      '=((D'+nextRow+'-C'+nextRow+')*24)+E'+nextRow,
      '=IF(F'+nextRow+'<8;0;F'+nextRow+'-8)']);
  }
}