Advertisement
Guest User

Untitled

a guest
Jul 21st, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function create_event(){
  2.  
  3. var calendar = CalendarApp.getDefaultCalendar();
  4.  
  5.   var data = get_data();
  6.   //Title = nombre cliente
  7.   var title = data[0];
  8.   var startTime = data[1];
  9.   var endTime = data[2];
  10.   var options = data[3];
  11.  
  12. calendar.createEvent(title, startTime, endTime, options);
  13. }
  14.  
  15.  
  16. function get_data(){
  17.   var form = FormApp.getActiveForm();
  18.   var responses = form.getResponses();
  19.   var response = responses[responses.length - 1];
  20.  
  21.  
  22.   var items = response.getItemResponses();
  23.  
  24.   var cliente = items[0].getResponse();
  25.   var tipo_proceso = items[1].getResponse();
  26.   var servicio_requerido = items[2].getResponse();
  27.   var startTime = formatDateTime(items[3].getResponse());
  28.   var endTime = formatDateTime(items[4].getResponse());
  29.  
  30.  
  31.   var options = {
  32.     description: "Tipo(s) de proceso: " + tipo_proceso + "\n \n" +"Servicio Requerido: "+ servicio_requerido
  33.  
  34.   };
  35.  
  36.   Logger.log([cliente, startTime, endTime, options]);
  37.   return [cliente, startTime, endTime, options];
  38.  
  39.  
  40. }
  41.  
  42.  
  43. function formatDateTime(dateTime){
  44. //  var dateTime = "2018-05-16 09:00";
  45.   var date = dateTime.split(" ")[0].split("-");
  46.   var time = dateTime.split(" ")[1].split(":");
  47.  
  48.   var year = parseInt(date[0], 10);
  49.   var month = parseInt(date[1], 10) - 1;
  50.   var day = parseInt(date[2], 10);
  51.  
  52.   var hour = parseInt(time[0], 10);
  53.   var minute = parseInt(time[1], 10);
  54.   var second = 0;
  55.   var milisecond = 0;
  56.  
  57.   var  new_date = new Date(year, month, day, hour, minute, second, milisecond);
  58.   Logger.log(new_date);
  59.   return new_date;
  60.  
  61.  
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement