Empresas
Empleos
  • Sobre nosotros
  • Soluciones
    • Publicación de vacantes
      Publica tu vacante y recibe candidatos calificados en 48h.
    • Evaluación de candidatos
      500+ pruebas técnicas y psicológicas, más anti-fraude.
    • Headhunting
      Búsqueda ejecutiva a la medida de principio a fin.
    • Nómina + EOR
      Dispersión de nómina y EOR en más de 15 países de LATAM.
  • Precios
  • Empleos

0

164
Vistas
trying to change all new calendar events to busy(opaque) and default calendar view

I have appcript the uses google calendar I was able to easily figure out how to update calendar events to default calendar visibility; however, I am having a tough time making sure all my events are set to busy(opaque) on my calendar on occasion people set an event as free and it causing me trouble with double bookings. I am using google calendar api my function is below. I am a novice. function


  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Sheet1");
  var ssId = ss.getId();
  var sheetId = ss.getActiveSheet().getSheetId();

  var start_time = new Date();
  var end_time =new Date(new Date(start_time.getTime() + 120 * 1000 * 60 * 60 * 24)) ;
  var id_cal = sheet.getRange("C2").getValue();

  var cal = CalendarApp.getCalendarById(id_cal);
    var events = cal.getEvents(new Date(start_time), new Date(end_time));

  for (var i = 0;i<events.length;i++){
    

    
    
    var vis = events[i].getVisibility();

    if (vis != CalendarApp.Visibility.DEFAULT) {
var setvis = events[i].setVisibility(CalendarApp.Visibility.DEFAULT); 
var splitid = events[i].getId().split("@")[0];
var freebusy = {transparency: "opaque",
  };
var setbusy = Calendar.Events.patch(freebusy, id_cal,splitid);
var title =  events[i].getTitle();
var data = [title];
var lastupdate = new Date();
  sheet.insertRows(5, 1);
  sheet.getRange(5, 1, 1, 1).setValues([data]);

    }

  


  }


  Logger.log("Events have been added to the Spreadsheet");
  Logger.log("Filter has been added.");
}
about 4 years ago · Juan Pablo Isaza
Responde la pregunta
Encuentra empleos remotos

¡Descubre la nueva forma de encontrar empleo!

Top de empleos
Top categorías de empleo
Empresas
Publicar vacante Precios Comercial
Legal
Términos y condiciones Política de privacidad
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Recomiéndame algunas ofertas
Necesito ayuda