從htmlService執行GAS函式不會運行？-有解無憂

我試圖在 htmlService modalDialog 打開 5 秒后切換我的當前作業表。由于某種原因SwitchToSheet1()不起作用...

.gs

function openModal() {
  var ui = SpreadsheetApp.getUi();
  var html = HtmlService.createTemplateFromFile('BarcodeLoadingHTML')
  .evaluate()
  .setWidth(400)
  .setHeight(250);
  ui.showModalDialog(html, "?");
}

function SwitchToSheet1() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Bestandsliste'), true);
};

BarcodeLoadingHTML.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
    <?!= include('jQuery'); ?>
    <?!= include('Stylesheet'); ?>
    <?!= include('lottieplayer'); ?>
  </head>
  <body>
    <div id="loading">
        <lottie-player id="lottie-load" src="https://static.staticsave.com/lottie/cloudupload.json"  
          background="transparent"  
          speed="1" 
          loop 
          autoplay>
        </lottie-player>
        <lottie-player id="lottie-success" src="https://assets3.lottiefiles.com/private_files/lf30_qXYuJE.json"  
          background="transparent"  
          speed="1">
        </lottie-player>
        <p class="loadingtext" id="text">Bitte warten<span>.</span><span>.</span><span>.</span></p>
    </div>
    <script>
        $(window).ready(setTimeout (function() {
            $('#lottie-load').hide()
            $('#text').text('Upload Erfolgreich!')
            $('#lottie-success').fadeIn()
            $('#lottie-success').get(0).play();
        }, 2500));
        
        $(window).ready(setTimeout (function() {
            google.script.run.SwitchToSheet1();
            google.script.host.close();
        }, 5000));

    </script>
  </body>
</html>

uj5u.com熱心網友回復：

代替

google.script.run.SwitchToSheet1();
google.script.host.close();

經過

google.script.run
.withSuccessHandler(() => google.script.host.close())
.SwitchToSheet1();

上面的因為 google.script.host.close()是在之前執行的google.script.run.SwitchToSheet1()。發生這種情況是因為對服務器代碼的呼叫google.script.run是異步的。

uj5u.com熱心網友回復：

FWIW，假設我有一個包含兩張名為 Sheet1 和 Sheet2 的作業表的電子表格，并且 Sheet2 是活動的，以下代碼適用于我：

// Code.gs
function showDialog() {
  const html = HtmlService.createHtmlOutputFromFile('page')
   .setWidth(400)
   .setHeight(400);
  SpreadsheetApp.getUi().showModalDialog(html, 'My custom dialog'); 
}

function SwitchToSheet1() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sh = spreadsheet.getSheetByName('Sheet1');
  spreadsheet.setActiveSheet(sh, true);
};

和 HTML 頁面：

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>            
    <script>
      window.addEventListener('DOMContentLoaded', () => {
        setTimeout (function() {
            google.script.run.SwitchToSheet1();
            google.script.host.close();
        }, 5000)
      })
    </script>
  </body>
</html>

轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/506776.html

標籤：javascript 谷歌应用脚本谷歌表格

上一篇：提示無法在Javascript中的for回圈內部作業

下一篇：如何將陣列作為JavaScript物件中的鍵傳遞？