خرید بک لینک

Vote count: 0

I'm not a programmer of modern languages, I graduated from college with a > programming degree in 1987 but got employment in computing hardware not > software.

I slightly modified the following code to update my calendar from a google > form. The code works great but now I'd like to add the email address and > name to Google contacts if it doesn't exist, can anyone help please?

//Load the Moment.js library once.
var moment = Moment.load();

var GLOBAL = {
  //the id of the form we will use to create calendar events 
  formId : "19qtJNTy-ja7QBc54lZqTDQDX-sD4vg-not compleate",  

  //the id of the calendar we will create events on
  calendarId : "[email protected]",


 //a mapping of form item titles to sections of the calendar event
  formMap : {
    eventTitle: "Name",
    startTime : "Date and Start Time",
    endTime: "End Date and Time",
    description: "Brief Description of Event",
    location: "Location",
    email: "Email",
    contact: "Contact Number"

  },
}

function onFormSubmit() {
  var eventObject = getFormResponse();
  var event = createCalendarEvent(eventObject);
}

function getFormResponse() {
  // Get a form object by opening the form using the
  // form id stored in the GLOBAL variable object
  var form = FormApp.openById(GLOBAL.formId),
      //Get all responses from the form. 
      //This method returns an array of form responses
      responses = form.getResponses(),
      //find the length of the responses array
      length = responses.length,
      //find the index of the most recent form response
      //since arrays are zero indexed, the last response 
      //is the total number of responses minus one
      lastResponse = responses[length-1],
      //get an array of responses to every question item 
      //within the form for which the respondent provided an answer
      itemResponses = lastResponse.getItemResponses(),
      //create an empty object to store data from the last 
      //form response
      //that will be used to create a calendar event
      eventObject = {};
  //Loop through each item response in the item response array
  for (var i = 0, x = itemResponses.length; i<x; i++) {
    //Get the title of the form item being iterated on
    var thisItem = itemResponses[i].getItem().getTitle(),
        //get the submitted response to the form item being
        //iterated on
        thisResponse = itemResponses[i].getResponse();
    //based on the form question title, map the response of the 
    //item being iterated on into our eventObject variable
    //use the GLOBAL variable formMap sub object to match 
    //form question titles to property keys in the event object
    switch (thisItem) {
      case GLOBAL.formMap.eventTitle:
        eventObject.title = thisResponse;
        break;
      case GLOBAL.formMap.startTime:
        eventObject.startTime = thisResponse;
        break;
      case GLOBAL.formMap.endTime:
        eventObject.endTime = thisResponse;
        break; 
      case GLOBAL.formMap.description:
        eventObject.description = thisResponse;
        break;
      case GLOBAL.formMap.location:
        eventObject.location = thisResponse;
        break;
      case GLOBAL.formMap.email:
        eventObject.email = thisResponse;
        break;
      case GLOBAL.formMap.contact:
        eventObject.contact = thisResponse;
        break;
    } 
  }
  return eventObject;
}

function createCalendarEvent(eventObject) {
  //Get a calendar object by opening the calendar using the
  //calendar id stored in the GLOBAL variable object
  var calendar = CalendarApp.getCalendarById(GLOBAL.calendarId),
      //The title for the event that will be created
      title = eventObject.title,
      //The start time and date of the event that will be created
      startTime = moment(eventObject.startTime).toDate(),
      //The end time and date of the event that will be created
      endTime = moment(eventObject.endTime).toDate();
  //an options object containing the description and guest list
  //for the event that will be created
  var options = {
    description : eventObject.description + eventObject.contact,
    guests : eventObject.email,
    location: eventObject.location,
  };
  try {
    //create a calendar event with given title, start time,
    //end time, and description and guests stored in an 
    //options argument
    var event = calendar.createEvent(title, startTime, 
                                     endTime, options)
    } catch (e) {
      //delete the guest property from the options variable, 
      //as an invalid email address with cause this method to 
      //throw an error.
      delete options.guests
      //create the event without including the guest
      var event = calendar.createEvent(title, startTime, 
                                       endTime, options)
      }
  return event;   
}

asked 2 mins ago

برچسب: updating google calendar from outlook,updating google calendar,updating google calendars from a google spreadsheet,updating google calendar on iphone,ical not updating google calendar,ipad not updating google calendar,iphone not updating google calendar,tripit not updating google calendar,lightning not updating google calendar,android not updating google calendar, نویسنده: استخدام کار تاريخ: شنبه 30 مرداد 1395 ساعت: 12:13

صفحه بندی