Hello all,
I want to create an alert when I create an event based on a google spreadsheet.
The code is
Code
// Δημιουργία Μενού
function onOpen(){
const ss = SpreadsheetApp.getActive();
const menuEntries = [];
menuEntries.push({name: 'Εισαγωγή σε Ημερολόγιο', functionName: 'scheduleShifts'});
ss.addMenu('Carousel', menuEntries);
}
// Δημιουργία Event
function scheduleShifts() {
var spreadsheet = SpreadsheetApp.getActiveSheet();
var calendarID = spreadsheet.getRange("B2").getValue();
var eventCal = CalendarApp.getCalendarById(calendarID);
const signups = spreadsheet.getRange("A4:D110")
.getValues()
.filter(row => row.every(String));
for (x=0; x<signups.length;x++)
{
var shift = signups[x];
var startTime = shift[0];
var action= shift[2];
var description= shift[1];
var endTime= shift[3];
eventCal.createEvent(action, startTime, endTime, { description: shift[1] } ).setColor(4)
}
}
Display More
And the sample is here
Thank you in advance,
Makis