Test Booking Form 03.gs

function meetingRoomBooking() {

  //Set data from Spread Sheet
  var spreadSheetID = "xxxxxx";
  var ss = SpreadsheetApp.openById(spreadSheetID);
  var sheet = ss.getActiveSheet();
  var lastRow = sheet.getLastRow();
  var lastColumn = sheet.getLastColumn();
  
  /*
  Logger.log(lastRow);
  Logger.log(lastColumn);
  */
  
  //Set data for Google Calendar
  var name = sheet.getRange(lastRow, 2).getValue();
  var phoneNumber = sheet.getRange(lastRow, 3).getValue();
  var roomNumber = sheet.getRange(lastRow, 4).getValue();
  var startDate = new Date(sheet.getRange(lastRow, 5).getValue());
  var endDate = new Date(sheet.getRange(lastRow, 6).getValue());
  
  /*
  Logger.log("name:" + name);
  Logger.log("Phone Number:" + phoneNumber);
  Logger.log("Room Number:" + roomNumber);
  Logger.log("Start Date:" + startDate);
  Logger.log("End Date:" + endDate);
  */
  
  //Creates a calendar event using the submitted data
  var calendar = CalendarApp.getCalendarById("yyyyyy");
  var titles = (name + ' ' + 'Tel.' + phoneNumber);
  var descriptions = roomNumber;
  calendar.createEvent(titles, startDate, endDate, {description: descriptions});
}