我正在使用Google Web App来构建简单的HTML,该HTML将用户填写的一些信息插入到Google表格中(Apps脚本应用程序托管在Google Apps Enterprise帐户中)。我正在尝试通过使用Session.getEffectiveUser()。getEmail()方法在HTML页面上显示用户电子邮件。您能告诉我我该怎么做吗?
这是我的代码。gs:
function doGet(e) {
return HtmlService.createTemplateFromFile("page.html").evaluate();
}
function userClicked(userInfo){
var url ="path";
var ss = Spreadsheetapp.openByUrl(url);
var ws = ss.getSheetByName("BAZA");
var l_row = ws.getLastRow() + 1
ws.getRange(l_row,1).setvalue(userInfo.RANK)
这是HTML:
<!DOCTYPE html>
<html>
<head>
<base target="_top">
<meta name="viewport" content="width=device-width,initial-scale=1.0"/>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/css/materialize.min.css">
<?!= include("page-css.html"); ?>
</head>
<body>
<div class="row">
<div class="input-field col s2">
<select id="RANK">
<option value="" disabled selected>Wybierz rank </option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<label>Rank</label>
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0/js/materialize.min.js"></script>
<?!= include("page-js.html"); ?>
**HERE SHOULD BE USER ADDRESS EMAIL**
</body>
</html>
JavaScript代码:
<script>
document.addEventListener('DOMContentLoaded',function() {
var elems = document.querySelectorAll('select');
var instances = M.FormSelect.init(elems);
});
document.getElementById("btn").addEventListener("click",clickedBtn);
function clickedBtn(){
var responseInfo = {};
responseInfo.RANK = document.getElementById("RANK").value;
google.script.run.userClicked(responseInfo);
}
</script>