admin管理员组

文章数量:1333710

I have a Google Form where I want to get the user geolocation along with the inputs. Currently, I'm able to get it by making the user click on a url after he submits the answers. This is the code in Google Script that does it:

function doGet() {
    return HtmlService.createHtmlOutputFromFile("Index");
}


function getLoc(value) {
  var destId = FormApp.getActiveForm().getDestinationId() ;
  var ss = SpreadsheetApp.openById(destId) ;
  var respSheet = ss.getSheets()[0] ;
  var data = respSheet.getDataRange().getValues() ;
  var headers = data[0] ;
  var numColumns = headers.length ;
  var numResponses = data.length;
  var c=value[0]; var d=value[1];
  var e=c + "," + d ;
   if (respSheet.getRange(1, numColumns).getValue()=="GeoAddress") {    
       respSheet.getRange(numResponses,numColumns-2).setValue(Utilities.formatDate(new Date(), "GMT-3", "dd/MM/yyyy HH:mm:ss"));
       respSheet.getRange(numResponses,numColumns-1).setValue(e);
       var response = Maps.newGeocoder().reverseGeocode(value[0], value[1]);
       f= response.results[0].formatted_address;
       respSheet.getRange(numResponses,numColumns).setValue(f);
     }
   else if (respSheet.getRange(1,numColumns).getValue()!="GeoAddress") {
       respSheet.getRange(1,numColumns+1).setValue("GeoStamp");
       respSheet.getRange(1,numColumns+2).setValue("GeoCode");
       respSheet.getRange(1,numColumns+3).setValue("GeoAddress");
  }
}

And the Index.html file:

<!DOCTYPE html>
<html>
<script>
(function getLocation() {
    if (navigator.geolocation) {
      navigator.geolocation.getCurrentPosition(showPosition);
      }
})()      
function showPosition(position){
 var a= position.coords.latitude;
 var b= position.coords.longitude;
 var c=[a,b]
 getPos(c)
 function getPos(value){
 google.script.run.getLoc(value);
 }
}
</script>
</html>

Instead of making the user click on a url, I want the geolocation to be automatically inputed into the response sheet as the user submits the form. I'm able to make the getLoc function run on a submit trigger, however the html function doesn't run. I believe it might be because the doGet function is already a trigger, but it requires a browser page to be opened in order to run. If that's the case, the ideal solution would be to redirect the browser to the Google Script url after the user submits it, but I can't seem to find a way to do it. Is this the correct approach and how can I make it work?

Thanks in advance!

I have a Google Form where I want to get the user geolocation along with the inputs. Currently, I'm able to get it by making the user click on a url after he submits the answers. This is the code in Google Script that does it:

function doGet() {
    return HtmlService.createHtmlOutputFromFile("Index");
}


function getLoc(value) {
  var destId = FormApp.getActiveForm().getDestinationId() ;
  var ss = SpreadsheetApp.openById(destId) ;
  var respSheet = ss.getSheets()[0] ;
  var data = respSheet.getDataRange().getValues() ;
  var headers = data[0] ;
  var numColumns = headers.length ;
  var numResponses = data.length;
  var c=value[0]; var d=value[1];
  var e=c + "," + d ;
   if (respSheet.getRange(1, numColumns).getValue()=="GeoAddress") {    
       respSheet.getRange(numResponses,numColumns-2).setValue(Utilities.formatDate(new Date(), "GMT-3", "dd/MM/yyyy HH:mm:ss"));
       respSheet.getRange(numResponses,numColumns-1).setValue(e);
       var response = Maps.newGeocoder().reverseGeocode(value[0], value[1]);
       f= response.results[0].formatted_address;
       respSheet.getRange(numResponses,numColumns).setValue(f);
     }
   else if (respSheet.getRange(1,numColumns).getValue()!="GeoAddress") {
       respSheet.getRange(1,numColumns+1).setValue("GeoStamp");
       respSheet.getRange(1,numColumns+2).setValue("GeoCode");
       respSheet.getRange(1,numColumns+3).setValue("GeoAddress");
  }
}

And the Index.html file:

<!DOCTYPE html>
<html>
<script>
(function getLocation() {
    if (navigator.geolocation) {
      navigator.geolocation.getCurrentPosition(showPosition);
      }
})()      
function showPosition(position){
 var a= position.coords.latitude;
 var b= position.coords.longitude;
 var c=[a,b]
 getPos(c)
 function getPos(value){
 google.script.run.getLoc(value);
 }
}
</script>
</html>

Instead of making the user click on a url, I want the geolocation to be automatically inputed into the response sheet as the user submits the form. I'm able to make the getLoc function run on a submit trigger, however the html function doesn't run. I believe it might be because the doGet function is already a trigger, but it requires a browser page to be opened in order to run. If that's the case, the ideal solution would be to redirect the browser to the Google Script url after the user submits it, but I can't seem to find a way to do it. Is this the correct approach and how can I make it work?

Thanks in advance!

  • javascript
  • html
  • google-apps-script
  • google-forms
Share asked Nov 25, 2019 at 13:37 prolifebelprolifebel 1031 gold badge2 silver badges6 bronze badges 3
  • If you create a WebApp form and in that way, you could get the geolocation values and then pass them with the form data submitted to the server-side Apps Script code. Do you like that approach? – alberto vielma Commented Nov 25, 2019 at 16:40
  • Does this answer your question? How to send geolocation along with inputs when submiting HTML form in Google Apps Script – Sourabh Choraria Commented Dec 1, 2019 at 13:08
  • why is geolocation ing incorrect – Zesty Dragon Commented Oct 4, 2020 at 20:38
Add a ment  | 

1 Answer 1

Reset to default 1

Maybe this works: https://www.youtube./watch?v=J93uww0vMFY

Tutorial on Geotagging (Geo-stamp and Time-stamp) google forms. Add info on Latitude, Longitude, and Address (Street name and number, city, state, zip code, and country) of a device submitting google forms. Linking user’s location within google forms. Google forms integration with google maps.

Links to download the scripts are given below:

  1. Code.gs : https://www.youtube./redirect?v=J93uww0vMFY&event=video_description&q=https%3A%2F%2Fdrive.google.%2Fopen%3Fid%3D1D4vTzUGZAf3_ZDVMeW760i1KoZCn37un&redir_token=VQ2rLeQvyQea-mq9_kGhh_Kxihd8MTU5MTgxOTM2OEAxNTkxNzMyOTY4

  2. Index.html : https://www.youtube./redirect?v=J93uww0vMFY&event=video_description&q=https%3A%2F%2Fdrive.google.%2Fopen%3Fid%3D1mYZGYNrXNOxUD8DlDmRdBajy1nc3FKtw&redir_token=VQ2rLeQvyQea-mq9_kGhh_Kxihd8MTU5MTgxOTM2OEAxNTkxNzMyOTY4

本文标签： javascriptGet geolocation on submit in Google Forms using Google ScriptStack Overflow

版权声明：本文标题：javascript - Get geolocation on submit in Google Forms using Google Script - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1742261288a2442561.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。