ChaiyachetU

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

function addBooking() {
  // Form responses
  var form = FormApp.getActiveForm();
  var formResponses = form.getResponses();
  var formResponse = formResponses[formResponses.length - 1];//get the last form responses

ChaiyachetU

// 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();

ChaiyachetU

function autoFillDoc(e) {
  //e.values is an array of last google form values when submit
  //see more at https://developers.google.com/apps-script/guides/triggers/events
  var timeStamp = e.values[0];
  var firstName = e.values[1];
  var lastName = e.values[2];
  var title = e.values[3];
  
  //file is the template file
  //see more at https://developers.google.com/apps-script/reference/drive/drive-app

ChaiyachetU

var ssId = "<YourGoogleSheetID>";
var ss = SpreadsheetApp.openById(ssId);
var sheetProduct = ss.getSheetByName("product");
var sheetLog = ss.getSheetByName("log"); //get sheet for log

function doPost(e) {
  var data = JSON.parse(e.postData.contents); //convert request srting in JSON format into JavaScript object
  
  //Log text message
  var timeStamp = data.originalDetectIntentRequest.payload.data.timestamp;

ChaiyachetU

//get events from calendar to sheet
function getEvents() {
 
  var calenDar = CalendarApp.getCalendarById("Your Calendar ID");
  var lastDateOfYear = new Date(new Date().getFullYear(), 11, 31); // JavaScript counts months from 0 to 11. January is 0. December is 11.
  var events = calenDar.getEvents(new Date(), lastDateOfYear); // new Date() = today
  var spreadSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var lastRow = spreadSheet.getLastRow();
  spreadSheet.getRange(2, 1, lastRow, 5).clearContent();

ChaiyachetU

//delete and add events to calendar
function addEvents() {
  
  //open the event calendar
  var calenDar = CalendarApp.getCalendarById("Your Calendar ID");
  var spreadSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  //pull information into the code, in a form that the code can understand
  var lastRow = spreadSheet.getLastRow();
  var data = spreadSheet.getRange("A2:E" + lastRow).getValues();

ChaiyachetU

//create menu for sync to calendar
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Sync to Calendar')
    .addItem('Add events to calendar', 'addEvents')
    .addItem('Get events from calendar', 'getEvents')
    .addToUi();
}

ChaiyachetU

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);

ChaiyachetU

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);

ChaiyachetU

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();
  
  /*