在Google Apps脚本中提交HTML表单时,如何与输入一起发送地理位置信息 [英] How to send geolocation along with inputs when submiting HTML form in Google Apps Script
问题描述
我有一个使用Google Apps脚本制作的HTML表单,该表单会将估算的数据发送到Google表格中.这是项目中的文件:
I have a HTML form made with Google Apps Script that sends the data imputed into a Google Sheet. Here are the files in the project:
Code.gs
function doGet(request) {
return HtmlService.createTemplateFromFile('Index').evaluate();
}
/* @Include JavaScript and CSS Files */
function include(filename) {
return HtmlService.createHtmlOutputFromFile(filename)
.getContent();
}
/* @Process Form */
function processForm(formObject) {
var url = "URL OF GOOGLE SHEET";
var ss = SpreadsheetApp.openByUrl(url);
var ws = ss.getSheetByName("Data");
ws.appendRow([formObject.local,
formObject.direcao,
formObject.carro,
formObject.quilometragem,
formObject.observacao,
Utilities.formatDate(new Date(), "GMT-3", "dd/MM/yyyy HH:mm:ss")
]);
}
Index.html
<!DOCTYPE html>
<html>
<script type="text/javascript">
function showPosition() {
navigator.geolocation.getCurrentPosition(showMap);
}
function showMap(position) {
// Get location data
var latlong = position.coords.latitude + ", " + position.coords.longitude;
}
</script>
<head>
<base target="_top">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<?!= include('JavaScript'); ?>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-6">
<form id="myForm" onsubmit="handleFormSubmit(this)">
<p class="h4 mb-4 text-left">Uso Frota</p>
<div class="form-group">
<label for="local">Local</label>
<input type="text" class="form-control" id="local" name="local">
</div>
<div class="form-group">
<label for="direcao">Direcao</label>
<select class="form-control" id="direcao" name="direcao">
<option selected disabled hidden style='display: none' value=''></option>
<option value="Chegada">Chegada</option>
<option value="Saida">Saida</option>
<option value="Chegada/Saida">Chegada/Saida</option>
</select>
</div>
<div class="form-group">
<label for="carro">Carro</label>
<select class="form-control" id="carro" name="carro">
<option selected disabled hidden style='display: none' value=''></option>
<option value="Opt1">Opt1</option>
<option value="Opt2">Opt2</option>
<option value="Opt3">Opt3</option>
</select>
</div>
<div class="form-group">
<label for="quilometragem">Quilometragem</label>
<input type="text" class="form-control" id="quilometragem" name="quilometragem">
</div>
<div class="form-group">
<label for="observacao">Observacao</label>
<input type="text" class="form-control" id="observacao" name="observacao">
</div>
<button type="submit" class="btn btn-primary btn-block">Enviar</button>
</form>
<div id="output"></div>
</div>
</div>
</div>
</body>
</html>
JavaScript.html
<script>
// Prevent forms from submitting.
function preventFormSubmit() {
var forms = document.querySelectorAll('form');
for (var i = 0; i < forms.length; i++) {
forms[i].addEventListener('submit', function(event) {
event.preventDefault();
});
}
}
window.addEventListener('load', preventFormSubmit);
function handleFormSubmit(formObject) {
google.script.run.processForm(formObject);
document.getElementById("myForm").reset();
}
</script>
一切正常.但是,我试图添加要与表单中的输入一起提交的用户地理位置.我不希望用户做任何事情,它需要在用户单击提交"按钮时提交.我已经尝试了所有方法,包括添加可以在Index.html文件中找到的showPosition()和showMap()函数.但是,我不知道如何处理它,因为它获得了地理位置,但是我不知道如何使它与表单一起提交.感谢您的帮助.
Everything works fine. However, I'm trying to add the user geolocation to be submitted alongside the inputs in the form. I don't want the user to do anything, it needs to be submitted as the user clicks the submit button. I have tried everything, including adding the showPosition() and showMap() functions that you can find in the Index.html file. However, I don't know what to do with it, as it gets the geolocation but I don't know how to make get it to be submitted with the form. Any help is appreciated.
提前谢谢!
推荐答案
在这里-
- Code.gs
只需添加 formObject.lat &将 formObject.long 组件添加到processForm
函数.
Just added the formObject.lat & formObject.long components to the processForm
function.
function doGet(request) {
return HtmlService.createTemplateFromFile('Index').evaluate();
}
/* @Include JavaScript and CSS Files */
function include(filename) {
return HtmlService.createHtmlOutputFromFile(filename)
.getContent();
}
/* @Process Form */
function processForm(formObject) {
var url = "URL OF GOOGLE SHEET";
var ss = SpreadsheetApp.openByUrl(url);
var ws = ss.getSheetByName("Data");
ws.appendRow(
[
formObject.local,
formObject.direcao,
formObject.carro,
formObject.quilometragem,
formObject.observacao,
Utilities.formatDate(new Date(), "GMT-3", "dd/MM/yyyy HH:mm:ss"),
formObject.lat,
formObject.long
]
);
}
- Index.html
在这里做了以下事情-
- 将所有脚本组件移至 JavaScript.html
- 在表单中添加了2个隐藏的输入组件(纬度和经度)
<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<?!= include('JavaScript'); ?>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-6">
<form id="myForm" onsubmit="handleFormSubmit(this);">
<p class="h4 mb-4 text-left">Uso Frota</p>
<div class="form-group">
<label for="local">Local</label>
<input type="text" class="form-control" id="local" name="local">
</div>
<div class="form-group">
<label for="direcao">Direcao</label>
<select class="form-control" id="direcao" name="direcao">
<option selected disabled hidden style='display: none' value=''></option>
<option value="Chegada">Chegada</option>
<option value="Saida">Saida</option>
<option value="Chegada/Saida">Chegada/Saida</option>
</select>
</div>
<div class="form-group">
<label for="carro">Carro</label>
<select class="form-control" id="carro" name="carro">
<option selected disabled hidden style='display: none' value=''></option>
<option value="Opt1">Opt1</option>
<option value="Opt2">Opt2</option>
<option value="Opt3">Opt3</option>
</select>
</div>
<div class="form-group">
<label for="quilometragem">Quilometragem</label>
<input type="text" class="form-control" id="quilometragem" name="quilometragem">
</div>
<div class="form-group">
<label for="observacao">Observacao</label>
<input type="text" class="form-control" id="observacao" name="observacao">
</div>
<div class="form-group">
<input type="hidden" class="form-control" id="lat" name="lat">
<input type="hidden" class="form-control" id="long" name="long">
</div>
<button type="submit" class="btn btn-primary btn-block">Enviar</button>
</form>
<div id="output"></div>
</div>
</div>
</div>
</body>
</html>
- JavaScript.html
修改了以下内容-
- 中断
showMap
函数以lat&长 - 添加了事件监听器,可在加载时运行
showPosition
- 将值从
showMap
函数分配给lat& long的相应html隐藏表单元素
- broke the
showMap
function to lat & long - added event listener to run
showPosition
on load - assigned values from
showMap
function to lat & long's corresponding html hidden form elements
<script>
function showPosition() {
navigator.geolocation.getCurrentPosition(showMap);
}
function showMap(position) {
// Get location data
var lat = position.coords.latitude;
var geo1 = document.getElementById("lat");
geo1.value = lat;
var long = position.coords.longitude;
var geo2 = document.getElementById("long");
geo2.value = long;
}
// Prevent forms from submitting.
function preventFormSubmit() {
var forms = document.querySelectorAll('form');
for (var i = 0; i < forms.length; i++) {
forms[i].addEventListener('submit', function(event) {
event.preventDefault();
});
}
}
window.addEventListener('load', preventFormSubmit);
window.addEventListener('load', showPosition);
function handleFormSubmit(formObject) {
google.script.run.processForm(formObject);
document.getElementById("myForm").reset();
}
</script>
在我的设置上对此进行了测试,并且效果很好.如果您可能还需要其他帮助,请告诉我!
Tested this on my setup and it worked perfectly. Let me know in case you may require any further assistance too!
这篇关于在Google Apps脚本中提交HTML表单时,如何与输入一起发送地理位置信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!