Last active
October 16, 2019 15:44
-
-
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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