Skip to content

Instantly share code, notes, and snippets.

@ChaiyachetU
Last active October 16, 2019 15:44
Show Gist options
  • Save ChaiyachetU/ae46129c1c51f73db0f9e1bdb4e24698 to your computer and use it in GitHub Desktop.
Save ChaiyachetU/ae46129c1c51f73db0f9e1bdb4e24698 to your computer and use it in GitHub Desktop.
Test booking form project. Get data from Google form and Create Event on Google Calendar.
// 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
var itemResponses = formResponse.getItemResponses();
// Creates output requests from the last form submission
var firstName = itemResponses[0].getResponse();
var phoneNumber = itemResponses[1].getResponse();
var roomNumber = itemResponses[2].getResponse();
var startDateString = itemResponses[3].getResponse().slice(0, 16).split('-');//split for new format (YYYY/MM/DD HH:MM)
var startDate = new Date(startDateString[0] + '/' + startDateString[1] + '/' + startDateString[2]);
var endDateString = itemResponses[4].getResponse().slice(0, 16).split('-');//split for new format (YYYY/MM/DD HH:MM)
var endDate = new Date(endDateString[0] + '/' + endDateString[1] + '/' + endDateString[2]);
// Calendar to output requests
var calendar = CalendarApp.getCalendarById("google calendar Id");
//Creates a calendar event using the submitted data
var titles = (firstName + ' ' + 'Tel.' + phoneNumber);
var descriptions = roomNumber;
calendar.createEvent(titles, startDate, endDate, {description: descriptions});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment