Test booking form project. Get data from Google form with link to Google Sheet and Create Event on Google Calendar.

Test Booking Form 02.gs

// Calendar Booking Project
// Chaiyachet Ukham, 2019
// All rights reserved
// Get data from google form with link to google sheet and create event from sheet version 1.0

function addBooking() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var lastRow = sheet.getLastRow();
  var lastColumn = sheet.getLastColumn();
  
  // Creates output requests from the last form submission
  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());
  
  // Calendar to output requests
  var calendar = CalendarApp.getCalendarById(google calendar Id);
  
  //Creates a calendar event using the submitted data
  var titles = (name + ' ' + 'Tel.' + phoneNumber);
  var descriptions = roomNumber;
  calendar.createEvent(titles, startDate, endDate, {description: descriptions});
}