google-apps-script - Google App Script - 日历更新触发器触发 4 次
问题描述
目标:当 G Suite 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="e48a0bmth3sn787dotb4n2rtjs@group.calendar.google.com"; // 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
解决方案
您可以通过Lock.hasLock()确定另一个脚本实例当前是否有锁。
请注意,此方法并不总是避免冲突的最佳方法,因为无法判断锁是在更新同一事件期间还是在另一个恰好同时触发触发器的事件期间获得的——如文档告诉我们,“触发器不会告诉你哪个事件发生了变化或它是如何变化的。 ”
您可能需要仔细研究Google 日历事件以确定如何同步日历。
或者,共享日历而不是尝试同步。
推荐阅读
- python - 训练停留在自定义数据集上的简单 Pytorch 模型上
- c# - T4 模板中的继承
- python - Python Matplotlib:向子图添加水印
- amazon-web-services - 如何创建在 appsync 中响应无效的“突变”?
- html - 如何在移动设备的导航栏中显示两个不同的图标
- powershell - 如何在 Powershell New-Alias 中传递所有标志?
- javascript - 在 MERN 堆栈中的两个反应组件之间传递数据
- laravel - Laravel 更改请求值
- java - Spring-boot 缓存中的批量缓存支持
- reactjs - 如何在材料 ui 版本 5 中使用 react-admin