Ssurg3
commented
6 years ago my theory didn't hold up when I tried duplicating and event and syncing to the sheet. i got a unique event from the original...... maybe this is an old google calendar event?????? any help will be great. i'll be sure to update everyone on this.
Hi Dave, amazing scripting. easy to understand.
Pulling from the calendar works perfect the first time. but i've notice when there are several events with the same ID number. those rows will be deleted as if they do not exist on the calendar, when do they do exist. I believe it is in the script to search for event IDs that do not exist on the calendar and then delete. somehow... (if i'm correct).... the spreadsheet is not able to see events with the same ID when you run the script a second time or somehow not able to understand the events are the same, but on different dates..... basically a copy/paste event from a previous date?
example, I five events. I'll pull the data from the "syncfromcalendar" function. i will have 5 events on my spreadsheet. three of the five will have the same event ID number. when i run the "syncfrom calendar" function a second time. two the three events with the same ID will be deleted. leaving three event rows on the spreadsheet and two deleted (with the same ID). Those 3 events will have different event ids.
hope that makes sense. but i've been trying to figure out to prevent events with the same IDs from being deleted form the spreadsheet.