如何从Google App脚本中的“自定义对话框"窗口获取数据? [英] How to get data from Custom Dialog Window in Google App Script?
本文介绍了如何从Google App脚本中的“自定义对话框"窗口获取数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用Google App脚本在Google Spreadsheet中创建了自定义对话框窗口看起来像这样:
I created a Custom Dialog Window in Google Spreadsheet using Google App Script that looks like this:
如何从窗口将数据获取到电子表格.
How do I get the data from the window to my spreadsheet.
这是我的HTML代码:
Here is my HTML code:
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<form action="google.script.run.testing143()">
Task Number:<br>
<input type="text" name="taskNumber" value="">
<br><br>
Task Date:<br>
<input type="text" name="taskDate" value="">
<br><br>
Customer Name:<br>
<input type="text" name="customerName" value="">
<br><br>
Customer Site:<br>
<input type="text" name="customerSite" value="">
<br><br>
<select>
<option value="status">Status</option>
<option value="complete">Complete</option>
<option value="scheduled">Scheduled</option>
<option value="reschedule">Reschedule</option>
</select>
<br><br>
Status Date:<br>
<input type="text" name="statusDAte" value="">
<br><br>
Location:<br>
<input type="text" name="location" value="">
<br><br>
Description:<br>
<input type="text" name="description" value="">
<br><br>
<input type="submit" value="Submit">
</form>
<script>
function testing143(){
Logger.log('With Success') ///Doesn't work
var lmnt = document.getElementByName('usrname'); //Wrong
}
</script>
</body>
</html>
当我单击提交"时,将带我进入错误400页面. 我可以创建一个将数据作为参数的函数,例如:
When I click 'submit' it takes me to an error 400 page. I can create a function that takes the data as a parameter like:
function getNewTask(number,date,status...)
我可以使用document.getElement
吗?如果是这样,那怎么办?
Can I use document.getElement
? If so how is that done?
衷心感谢您的帮助!
推荐答案
我已将您的代码修改为可以使用.
I've taken your code and modified to work.
在Code.gs中
function testing143(obj) {
Logger.log(obj);
return "hello";
}
在HTML文件中
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<form id="myForm">
Task Number:<br>
<input type="text" name="taskNumber" value="">
<br><br>
Task Date:<br>
<input type="text" name="taskDate" value="">
<br><br>
Customer Name:<br>
<input type="text" name="customerName" value="">
<br><br>
Customer Site:<br>
<input type="text" name="customerSite" value="">
<br><br>
<select name="status">
<option value="status">Status</option>
<option value="complete">Complete</option>
<option value="scheduled">Scheduled</option>
<option value="reschedule">Reschedule</option>
</select>
<br><br>
Status Date:<br>
<input type="text" name="statusDate" value="">
<br><br>
Location:<br>
<input type="text" name="location" value="">
<br><br>
Description:<br>
<input type="text" name="description" value="">
<br><br>
<input type="button" value="Submit" onclick="testing143()">
</form>
<script>
function success(msg) {
alert(msg);
}
function testing143(){
var form = document.getElementById("myForm").elements;
var obj ={};
for(var i = 0 ; i < form.length ; i++){
var item = form.item(i);
obj[item.name] = item.value;
}
google.script.run.withSuccessHandler(success).testing143(obj);
}
</script>
</body>
</html>
这篇关于如何从Google App脚本中的“自定义对话框"窗口获取数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文