Currently, I want to run my google app script at exact time. I have already do some reading about this problem and I decide to follow the solution in this post It's possible run Google Sheets script Exact Time Everyday?.
然而,每次时间触发器只工作一次.它将在第二次触发时显示错误.我在谷歌上搜索过这个问题,大多数人都说这是谷歌v8的错误.( https://issuetracker.google.com/issues/150756612).
所以,我决定把我的代码降到101,因为这是帖子(https://issuetracker.google.com/issues/150756612)中唯一的解决方案.但是,我面临一个将102改为101的问题
这是我的代码:
function runTrigger(hours,minutes) {
var today_D=new Date();
var year=today_D.getFullYear();
var month=today_D.getMonth();
var day=today_D.getDate();
day=day+1;
var pars=[year,month,day,hours,minutes];
var schedule_date=new Date(...pars);
var hours_reamain=Math.abs(schedule_date - today_D)/36e5;
ScriptApp.newTrigger("testFunction")
.timeBased()
.after(hours_reamain*60*60*1000)
.create()
}
function deleteTrigger() {
var triggers=ScriptApp.getProjectTriggers();
var ssId="1d5P4ohgSLtOzuInxq1IYQUsB4GybeYhth5Gj21RI3rA";
var ss=SpreadsheetApp.openById(ssId);
for(var i=0 ; i< triggers.length ; i++) {
ss.appendRow([new Date() ,JSON.stringify(triggers[i]), JSON.stringify(triggers[i].getHandlerFunction()) , JSON.stringify(triggers[i].getEventType()) , JSON.stringify(triggers[i].getTriggerSource())])
if(triggers[i].getHandlerFunction() === "testFunction") {
ScriptApp.deleteTrigger(triggers[i]);
}
}
}
function setTrigger() {
deleteTrigger();
runTrigger(1,35);
}
function testFunction() {
//some code at here
setTrigger();
}
有人能教我怎么把100换成101吗