這是我在這個論壇上提出的先前問題的延續。我通過添加 else 條件對代碼進行了一些更改。我想要解決的是在頁面加載時顯示當前狀態。當前代碼僅在單擊按鈕時顯示狀態。如何在頁面加載時顯示當前狀態，并在單擊按鈕時更新狀態。CODE.GSfunction doGet(e) { return HtmlService.createHtmlOutputFromFile('Index');}function checkStatus(notify) { var employee = "John Peter"; var ss = SpreadsheetApp.getActiveSpreadsheet(); var mainSheet = ss.getSheetByName("MAIN"); var data = mainSheet.getDataRange().getValues(); for (var j = 0; j < data.length; j++){ var row = data[j]; var mainSheet2 = row[4]; var mainSheet3 = row[0]; var status = (mainSheet2 =="IN" && mainSheet3 == employee) ; if (status == true){ var notify = employee +" You Are In" return notify; } else{ var status = (mainSheet2 =="OUT" && mainSheet3 == employee) ; if (status == true){ var notify2 = employee +" You Are Out" return notify2; }} }}索引.html<body> <div> <button onclick="onStatus()">Check Status</button> <font color='Green' id="status" onbeforeprint="onStatus" ></font> </div> <script> function onStatus() { google.script.run.withSuccessHandler(updateStatus) // Send the backend result to updateStatus() .checkStatus(); // Call the backend function } function updateStatus(notify) { document.getElementById('status').innerHTML= notify; } </script> </body>
如何保持狀態繼續出現在 JavaScript 函數到 HTML 上
慕桂英3389331
2023-09-21 17:03:48
