Attendance Form | GEO Tag | Location Capture

In this blog we will tell you Attendance Form | GEO Tag | Location Capture so read the complete blog carefully and learn Attendance Form | GEO Tag | Location Capture according to given guidelines.

Google Sheet Copy :- Click to Google Sheet Copy With Source Code

Google Sheet Data See :- See Data

Practical -

Click to Practical

Step 1 :- Create 2 file Name Given Below

Code.gs
index.html

Step 2 :- Copy of Code.gs Code Given Below

function doGet(e) {
  return HtmlService.createHtmlOutputFromFile('index');
}

function saveCoordinates(latitude,longitude, locationpin){
  var latlongcol, pinlocationcol;
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses");
  var lastrow= sheet.getLastRow();
  var header = sheet.getRange(1, 1, 1,sheet.getLastColumn()).getValues();
  header=header.flat();
  for(var i=1;i<=header.length;i++){
    
    if(header[i]=="LatLong")
    {
      latlongcol=i+1;
    }
    
    if(header[i]=="GeoLocation"){
    
      pinlocationcol=i+1;
    }
  
  }
  if(sheet.getRange(lastrow, 1).getValue()!="" && sheet.getRange(lastrow, latlongcol).getValue()==""  &&  sheet.getRange(lastrow, pinlocationcol).getValue()==""){
  sheet.getRange(lastrow, latlongcol).setValue(latitude +" , "+ longitude);
  sheet.getRange(lastrow, pinlocationcol).setValue(locationpin);
  }
}

Step 3 :- Copy of Index.html Code Given Below

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body onload="geoFindMe()">
    
    
    <script>
      function geoFindMe() {

       
      
        var mapLink="";
       
      
       if(navigator.geolocation){
       
      
           navigator.geolocation.getCurrentPosition(showPosition);
          
           function showPosition(position){
           
           
            const latitude=position.coords.latitude;
            const  longitude=position.coords.longitude;
            mapLink = 'https://www.openstreetmap.org/?mlat=' + latitude + '&mlon='+longitude+'#map=18/' + `${latitude}\/${longitude}`;
           
            
            google.script.run.saveCoordinates(latitude,longitude, mapLink);
           }
    
         
        
        }
        
    
      }
      
      

     
    </script>
    
    <p>Form Submitted Successfully</p>
    
  </body>
</html>

Attendance Form | GEO Tag | Location Capture

Attendance Form | GEO Tag | Location Capture

In this blog we will tell you Attendance Form | GEO Tag | Location Capture so read the complete blog carefully and learn Attendance Form | GEO Tag | Location Capture according to given guidelines.

Google Sheet Copy :- Click to Google Sheet Copy With Source Code

Google Sheet Data See :- See Data

Practical -

Click to Practical

Step 1 :- Create 2 file Name Given Below

Code.gs
index.html

Step 2 :- Copy of Code.gs Code Given Below

Step 7 :- Click here to >> Deploy >> New Deployment >>

More Detail See Video :-

Post a Comment

Donation and Support

Contact Form

Attendance Form | GEO Tag | Location Capture

Attendance Form | GEO Tag | Location Capture

In this blog we will tell you Attendance Form | GEO Tag | Location Capture so read the complete blog carefully and learn Attendance Form | GEO Tag | Location Capture according to given guidelines.

Google Sheet Copy :- Click to Google Sheet Copy With Source Code

Google Sheet Data See :- See Data

Practical -

Step 1 :- Create 2 file Name Given Below

Code.gsindex.htmlStep 2 :- Copy of Code.gs Code Given Below

Step 7 :- Click here to >> Deploy >> New Deployment >>

More Detail See Video :-

Post a Comment

Contact Form

Code.gs
index.html

Step 2 :- Copy of Code.gs Code Given Below