目標：當 Google Workspace 1 中的輔助日歷活動更新（新建、編輯、洗掉）時，更新 Google Workspace 1 中的主日歷以添加新活動、編輯現有活動或洗掉現有活動。
注意：Google Workspace 1 中的輔助日歷是從 Google Workspace 2 共享的。因此，對事件的實際更新發生在 Google Workspace 2 的輔助日歷中，但幾乎立即反映為 Google Workspace 1 輔助日歷中的更新。
結果：這在手動運行時按預期作業。
問題：當手動添加在日歷更新時運行的觸發器（不是基于時間的）時，觸發器會觸發腳本的四個并發執行。這會在 Google Workspace 1 的輔助日歷上復制四次日歷活動。
嘗試解決：我設定了一個鎖定服務。這確實可以防止日歷事件重復。但是，這會導致四個執行中的三個失敗。這導致向我發送 3 封電子郵件，每次腳本失敗時發送一封電子郵件。
問題：我怎樣才能只允許這個腳本運行一次？我認為簡單的答案是只需放入一個 if/else 如果鎖定，則終止腳本。我已經查看并找不到如何編碼的示例。
請參閱下面的代碼和螢屏截圖。
function calEventUpdate(){
var lock = LockService.getScriptLock();
lock.waitLock(15000);
//code here
var id="[email protected]"; // CHANGE - id of the secondary calendar to pull events from (Anduin Out)
var today=new Date();
var enddate=new Date();
enddate.setDate(today.getDate() 7); // how many days in advance to monitor and block off time
var secondaryCal=CalendarApp.getCalendarById(id);
var secondaryEvents=secondaryCal.getEvents(today,enddate);
var primaryCal=CalendarApp.getDefaultCalendar();
var primaryEvents=primaryCal.getEvents(today,enddate); // all primary calendar events
var primaryEventTitle="Busy"; // update this to the text you'd like to appear in the new events created in primary calendar
var stat=1;
var evi, existingEvent;
var primaryEventsFiltered = []; // to contain primary calendar events that were previously created from secondary calendar
var primaryEventsUpdated = []; // to contain primary calendar events that were updated from secondary calendar
var primaryEventsCreated = []; // to contain primary calendar events that were created from secondary calendar
var primaryEventsDeleted = []; // to contain primary calendar events previously created that have been deleted from secondary calendar
Logger.log('Number of primaryEvents: ' primaryEvents.length);
Logger.log('Number of secondaryEvents: ' secondaryEvents.length);
// create filtered list of existing primary calendar events that were previously created from the secondary calendar
for (pev in primaryEvents)
{
var pEvent = primaryEvents[pev];
if (pEvent.getTitle() == primaryEventTitle)
{ primaryEventsFiltered.push(pEvent); }
}
// process all events in secondary calendar
for (sev in secondaryEvents)
{
stat=1;
evi=secondaryEvents[sev];
Utilities.sleep(1000); // added to prevent "too many updates" error on a busy calendar
// if the secondary event has already been blocked in the primary calendar, update it
for (existingEvent in primaryEventsFiltered)
{
var pEvent = primaryEventsFiltered[existingEvent];
var secondaryTitle = evi.getTitle();
var secondaryDesc = evi.getDescription();
if ((pEvent.getStartTime().getTime()==evi.getStartTime().getTime()) && (pEvent.getEndTime().getTime()==evi.getEndTime().getTime()))
{
stat=0;
pEvent.setTitle(primaryEventTitle);
//pEvent.setDescription(secondaryTitle '\n\n' secondaryDesc);
// event.setDescription(evi.getTitle() '\n\n' evi.getDescription());
pEvent.setVisibility(CalendarApp.Visibility.PRIVATE); // set blocked time as private appointments in work calendar
pEvent.setColor('9');
primaryEventsUpdated.push(pEvent.getId());
Logger.log('PRIMARY EVENT UPDATED'
'\nprimaryId: ' pEvent.getId() ' \nprimaryTitle: ' pEvent.getTitle() ' \nprimaryDesc: ' pEvent.getDescription());
}
}
if (stat==0) continue;
var d = evi.getStartTime();
var n = d.getDay();
if (evi.isAllDayEvent())
{
continue; // Do nothing if the event is an all-day or multi-day event. This script only syncs hour-based events
}
else if (n==1 || n==2 || n==3 || n==4 || n==5) // skip weekends. Delete this if you want to include weekends
// if the secondary event does not exist in the primary calendar, create it
{
var newEvent = primaryCal.createEvent(primaryEventTitle,evi.getStartTime(),evi.getEndTime()); // change the Booked text to whatever you would like your merged event titles to be
// alternative version below that copies the exact secondary event information into the primary calendar event
// var newEvent = primaryCal.createEvent(evi.getTitle(),evi.getStartTime(),evi.getEndTime(), {location: evi.getLocation(), description: evi.getDescription()});
//newEvent.setDescription(evi.getTitle() '\n\n' evi.getDescription());
newEvent.setVisibility(CalendarApp.Visibility.PRIVATE); // set blocked time as private appointments in work calendar
newEvent.setColor('9');
newEvent.removeAllReminders(); // so you don't get double notifications. Delete this if you want to keep the default reminders for your newly created primary calendar events
primaryEventsCreated.push(newEvent.getId());
Logger.log('PRIMARY EVENT CREATED'
'\nprimaryId: ' newEvent.getId() '\nprimaryTitle: ' newEvent.getTitle() '\nprimaryDesc ' newEvent.getDescription() '\n');
}
}
// if a primary event previously created no longer exists in the secondary calendar, delete it
for (pev in primaryEventsFiltered)
{
var pevIsUpdatedIndex = primaryEventsUpdated.indexOf(primaryEventsFiltered[pev].getId());
if (pevIsUpdatedIndex == -1)
{
var pevIdToDelete = primaryEventsFiltered[pev].getId();
Logger.log(pevIdToDelete ' deleted');
primaryEventsDeleted.push(pevIdToDelete);
primaryEventsFiltered[pev].deleteEvent();
}
}
Logger.log('Primary events previously created: ' primaryEventsFiltered.length);
Logger.log('Primary events updated: ' primaryEventsUpdated.length);
Logger.log('Primary events deleted: ' primaryEventsDeleted.length);
Logger.log('Primary events created: ' primaryEventsCreated.length);
lock.releaseLock();
}```
[Simultaneous script executions][1]
[Trigger][2]
[Trigger Settings][3]
[1]: https://i.stack.imgur.com/AcbJU.png
[2]: https://i.stack.imgur.com/u6giq.png
[3]: https://i.stack.imgur.com/hG93W.png
uj5u.com熱心網友回復：
您可以通過Lock.hasLock()確定另一個腳本實體當前是否有鎖。
請注意，此方法并不總是避免沖突的最佳方法，因為無法判斷鎖是在更新同一事件期間獲取的還是在同一時間觸發觸發器的另一個事件期間獲取的- 如檔案說，“觸發器不會告訴你哪個事件發生了變化或它是如何變化的。 ”
您可能需要仔細研究Google 日歷事件以確定如何同步日歷。
或者，共享日歷而不是嘗試同步。
uj5u.com熱心網友回復：
出于檔案目的發布此內容。
這可能是一個錯誤：
您所描述的行為（EventUpdateTrigger - 以及多次觸發EventOpenTrigger）可能是一個錯誤，目前正在 Google 問題跟蹤器上進行調查：
- 嘗試添加訪客時，會多次觸發 EventOpenTrigger。
請考慮為參考的問題加注星標，以便對其進行跟蹤并幫助確定其優先級。
解決方法：
正如doubleunary 所提到的，使用Lock.hasLock()來避免連續觸發執行導致事件重復多次。
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/339411.html
上一篇：如何將Materialize.min.js從GoogleDrive鏈接到GoogleAppsScript
下一篇：查找并洗掉空行