我有以下.gs:
function doGet(e) {
return HtmlService.createHtmlOutputFromFile('index')
}
function goToMaster() {
const ss = SpreadsheetApp.getActiveSpreadsheet()
const sheet = ss.getSheetByName('Master Projects')
sheet.activate()
}
goToMaster() 函式激活一個名為“Master Projects”的作業表
單獨運行該功能時,它可以正常作業。但是,我創建了一個 index.html ui 來通過單擊 div 來觸發此功能:
<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="icon" href="/images/favicon.svg" />
<script src="https://kit.fontawesome.com/abd2f5db30.js" crossorigin="anonymous"></script>
</head>
<body>
<div class="card card--1" id="master-projects">
<div class="container">
<h2>Master Projects</h2>
<i class="fa-solid fa-diagram-project"></i>
</div>
<script>
const masterProjects = document.getElementById('master-projects');
masterProjects.addEventListener('click', doStuff);
function doStuff() {
google.script.run.goToMaster();
}
</script>
</body>
</html>
單擊 div 時,沒有任何反應!我到處尋找解決方案,但到目前為止沒有任何效果。
知道可能是什么原因造成的嗎?
uj5u.com熱心網友回復:
像這樣試試
html:
<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="icon" href="/images/favicon.svg" />
<script src="https://kit.fontawesome.com/abd2f5db30.js" crossorigin="anonymous"></script>
</head>
<body>
<div class="card card--1">
<div class="container">
<h2>Master Projects</h2>
<i class="fa-solid fa-diagram-project" id="master-projects"></i>
</div>
<script>
window.onload = function() {
const masterProjects = document.getElementById('master-projects');
masterProjects.addEventListener('click', doStuff);
}
function doStuff() {
google.script.run.goToMaster();
}
</script>
</body>
</html>
GS:
function goToMaster() {
const ss = SpreadsheetApp.getActiveSpreadsheet()
const sheet = ss.getSheetByName('Master Sheet')
sheet.activate()
}
function launchadialog() {
const ui = SpreadsheetApp.getUi();
ui.showModelessDialog(HtmlService.createHtmlOutputFromFile("ah2"),"Title")
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/481060.html
標籤:javascript html 谷歌应用脚本 谷歌表格
