Find duplicates within a calendar VBA

[pantakos]

Hello all,

I have the below code and I want if it possible to check if the event at the calendar already exists. If yes then dont make a duplicate event. If not create it.

// Δημιουργία Μενού

function onOpen(){
  const ss = SpreadsheetApp.getActive();
  const menuEntries = [];
  menuEntries.push({name: 'Εισαγωγή σε Ημερολόγιο', functionName: 'scheduleShifts'});
  ss.addMenu('Carousel', menuEntries);
}

//

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)
}
}

Here is the shared example sheet

Thank you in advance

 

[6StringJazzer]

Please note: This is not VBA. This is a Google Sheets file using Google Apps Script.

 

[pantakos]

You are correct , please admin delete this one. I have created a new one.
Thank you

 

[Fluff]

Duplicate to: Find duplicates within a calendar Google Apps Script

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.