个人中心
gpt4 book ai didi

javascript - GAS withSuccessHandler 适用于某些功能，但不适用于其他功能

转载 作者：行者123 更新时间：2023-11-28 04:12:37 24 4
gpt4 key购买 nike

我将此项目附加到电子表格中:

HTML.html:

<!DOCTYPE html>
<html>
  <head>
  <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
   <script>
function script2() {
    google.script.run.doSomething();
}
function RunUpdateYearsManual() {
google.script.run.withSuccessHandler(script2).resetIndicatorsUpdateYears();
}
   </script>
  </head>
  <body>
 <input type="button" value="Update" onClick="RunUpdateYearsManual();" />
 <br><p></p>

  </body>
</html>

代码.gs:

function doSomething() {
  Logger.log('I was called! CALLED');
}

function resetIndicatorsUpdateYears() {
var newD = new Date();
var hour = newD.getHours();
var minute = newD.getMinutes();
var second = newD.getSeconds();
var s3 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Intro")
s3.getRange("F29").setNote("Started last update cycle on: "+ newD);
s3.getRange("F31:F46").setValue("Skipped").clearFormat();
s3.getRange("F30").setValue("Waiting").clearFormat();
s3.getRange("F30").setNote("Waiting for Year and English Lists Update.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F31").setNote("Skipped Company Lists Update 0001-0350.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F32").setNote("Skipped Company Lists Update 0351-0700.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F33").setNote("Skipped Company Lists Update 0701-1050.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F34").setNote("Skipped Company Lists Update 1051-1400.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F35").setNote("Skipped Company Lists Update 1401-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F36").setNote("Skipped Bundled Games In Year and English Lists Update.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F37").setNote("Skipped Bundled Games In Company Lists Removal 0001-0600.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F38").setNote("Skipped Bundled Games In Company Lists Removal 0601-1200.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F39").setNote("Skipped Bundled Games In Company Lists Removal 1201-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F40").setNote("Skipped Empty Rows Sorting 0001-0400.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F41").setNote("Skipped Empty Rows Sorting 0401-0800.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F42").setNote("Skipped Empty Rows Sorting 0801-1200.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F43").setNote("Skipped Empty Rows Sorting 1201-1600.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F44").setNote("Skipped Empty Rows Sorting 1601-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F45").setNote("Skipped Empty Rows Removal 0001-0900.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
s3.getRange("F46").setNote("Skipped Empty Rows Removal 0900-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second); 
deleteFormulas();
  Logger.log('I was called! TEST');
}
但这似乎不起作用，我运行 RunUpdateYearsManual ，它所做的只是执行第一个函数，而不启动第二个函数，记录器只会返回“我被调用!测试”，没有失败，并且使用 withFailureHandler 不会帮助。

但是这里有一个奇怪的部分，如果我删除代码中编辑 F30:F46 的那些行并将其设置为如下所示:

代码.gs:

function doSomething() {
  Logger.log('I was called! CALLED');
}

function resetIndicatorsUpdateYears() {
var newD = new Date();
var hour = newD.getHours();
var minute = newD.getMinutes();
var second = newD.getSeconds();
var s3 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Intro")
s3.getRange("F29").setNote("Started last update cycle on: "+ newD);
  Logger.log('I was called! TEST');
}

现在可以了，我在记录器中看到“我被调用了!被调用”。

所以我完全迷失在这里。我想这可能是原始脚本更长的某种限制？但这需要不到 20 秒的时间来运行，而且我能找到的唯一接近的文档是自定义函数运行时，它的执行时间限制为 30 秒，但不要认为这里是这种情况。

如有任何帮助，我们将不胜感激。

最佳答案

下面的修改怎么样？在此修改后的脚本中，我尝试使用 setNotes() 来缩短 resetIndicatorsUpdateYears() 的处理时间。请尝试这个修改后的示例。

setNotes()的详细信息是here .

修改后的脚本:

function resetIndicatorsUpdateYears() {
  var newD = new Date();
  var hour = newD.getHours();
  var minute = newD.getMinutes();
  var second = newD.getSeconds();
  var s3 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Intro")
  s3.getRange("F29").setNote("Started last update cycle on: "+ newD);
  s3.getRange("F31:F46").setValue("Skipped").clearFormat();
  s3.getRange("F30").setValue("Waiting").clearFormat();
  var data = [["Waiting for Year and English Lists Update.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Company Lists Update 0001-0350.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Company Lists Update 0351-0700.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Company Lists Update 0701-1050.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Company Lists Update 1051-1400.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Company Lists Update 1401-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Bundled Games In Year and English Lists Update.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Bundled Games In Company Lists Removal 0001-0600.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Bundled Games In Company Lists Removal 0601-1200.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Bundled Games In Company Lists Removal 1201-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Sorting 0001-0400.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Sorting 0401-0800.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Sorting 0801-1200.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Sorting 1201-1600.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Sorting 1601-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Removal 0001-0900.\n\n\n"+"Started at: "+hour+":"+minute+":"+second],
  ["Skipped Empty Rows Removal 0900-XXXX.\n\n\n"+"Started at: "+hour+":"+minute+":"+second]];
  s3.getRange("F30:F46").setNotes(data);
  // deleteFormulas();
  Logger.log('I was called! TEST');
}

关于javascript - GAS withSuccessHandler 适用于某些功能，但不适用于其他功能，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/46136509/

24 4 0
文章推荐： javascript - 尝试将自定义属性传递到React Router(使用v4)
文章推荐： Javascript使文本逐个字母淡入淡出然后消失
文章推荐： javascript - 在文档中间刷新时，jQuery 高度错误
文章推荐： javascript - 如何检测 JavaScript 中的链式函数调用？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com