Saya memiliki skrip untuk mengotomatiskan kalender kami berdasarkan jadwal lembar Google yang kami miliki. Itu berfungsi dalam menambahkan acara ke kalender tertentu, tapi saya ingin menambahkan kalender individual ke skrip serta secara otomatis menambahkan grup Google sebagai tamu ke acara tersebut sehingga pemberitahuan keluar seperti acara kalender Google biasa.
function scheduleShifts() {
/**
Task 1) Open the Event Calendar.
**/
var spreadsheet = SpreadsheetApp.getActive();
var calendarID = spreadsheet.getRange("C2").getValue();
var eventCal = CalendarApp.getCalendarById(calendarID);
/**
Task 2) Pull each shift information into the code, in
a form that the code can understand.
**/
var signups = spreadsheet.getRange("A5:C100").getValues();
/**
[
[11/9/2019 0:00:00,11/10/2019 0:00:00,Werdah On-Call],
[11/10/2019 0:00:00,11/11/2019 0:00:00,Lucas On-Call],
[11/16/2019 0:00:00,11/17/2019 0:00:00,Aiden On-Call],
[11/17/2019 0:00:00,11/18/2019 0:00:00,Werdah On-Call],
[11/23/2019 0:00:00,11/24/2019 0:00:00,Mayra On-Call],
[11/24/2019 0:00:00,11/25/2019 0:00:00,Kyle On-Call],
[11/30/2019 0:00:00,12/1/2019 0:00:00,Cavan On-Call],
[12/1/2019 0:00:00,12/2/2019 0:00:00,Adam On-Call],
[12/7/2019 0:00:00,12/8/2019 0:00:00,Hillary On-Call],
[12/8/2019 0:00:00,12/9/2019 0:00:00,Melissa Pino On-Call],
[12/14/2019 0:00:00,12/15/2019 0:00:00,Kristi On-Call],
[12/15/2019 0:00:00,12/16/2019 0:00:00,Kevin On-Call],
[12/21/2019 0:00:00,12/22/2019 0:00:00,Alice On-Call],
[12/22/2019 0:00:00,12/23/2019 0:00:00,Carro On-Call],
[12/28/2019 0:00:00,12/29/2019 0:00:00,Sruthi On-Call],
[12/29/2019 0:00:00,12/30/2019 0:00:00,Tara On-Call]
]
**/
/**
Task 3) Do the work!
**/
for (x=0; x<signups.length; x++) {
var shift = signups[x];
var startTime = shift[0];
var endTime = shift[1];
var oncall = shift[2];
eventCal.createEvent(oncall, startTime, endTime);
}
}
/**
Task 4) Make it easy to ue.
**/
function onOpen(){
var ui = SpreadsheetApp.getUi();
ui.createMenu('Sync to Calendar')
.addItem('Schedule shifts now','scheduleShifts')
.addToUi();
}