Scribd
Upload
125 views2 pages

Code Gs

This function gets location data from a Google Form response sheet. It checks if the sheet already contains geo-related columns, and if not, it adds them. It then takes latitude and longitude values, performs a reverse geocode to get the address, and inserts the geo stamp, code and address into the appropriate columns on the sheet. It handles inserting the data into empty rows or pushing existing data down if rows are already filled.

Uploaded by

Failasuf wibisono
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
125 views2 pages

Code Gs

This function gets location data from a Google Form response sheet. It checks if the sheet already contains geo-related columns, and if not, it adds them. It then takes latitude and longitude values, performs a reverse geocode to get the address, and inserts the geo stamp, code and address into the appropriate columns on the sheet. It handles inserting the data into empty rows or pushing existing data down if rows are already filled.

Uploaded by

Failasuf wibisono
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

function doGet() {

return [Link]('Index');
}
function getLoc(value) {
var destId = [Link]().getDestinationId() ;
var ss = [Link](destId) ;
var respSheet = [Link]()[0] ;
var data = [Link]().getValues() ;
var headers = data[0] ;
var numColumns = [Link] ;
var numResponses = [Link];
var c=value[0];
var d=value[1];
var e=c + "," + d ;
[Link](e);

if ([Link](1,numColumns).getValue()=="GeoAddress") {
if ([Link](numResponses,numColumns-2).getValue()=="" &&
[Link](numResponses-1,numColumns-2).getValue()!="" ){
[Link](numResponses,numColumns-2).setValue([Link](new
Date(), "GMT+8", "MM/dd/yyyy HH:mm:ss"));
[Link](numResponses,numColumns-1).setValue(e);
var response = [Link]().reverseGeocode(value[0], value[1]);
f= [Link][0].formatted_address;
[Link](numResponses,numColumns).setValue(f);
}

else if ([Link](numResponses,numColumns-2).getValue()=="" &&


[Link](numResponses-1,numColumns-2).getValue()=="" ){
[Link](numResponses,numColumns-2).setValue([Link](new
Date(), "GMT+8", "MM/dd/yyyy HH:mm:ss")).setFontColor("red");
[Link](numResponses,numColumns-1).setValue(e).setFontColor("red");
var response = [Link]().reverseGeocode(value[0], value[1]);
f= [Link][0].formatted_address;
[Link](numResponses,numColumns).setValue(f).setFontColor("red");
}

else if ([Link](numResponses,numColumns-2).getValue()!=""){

for (i = 0; i < numResponses; i++) {


if ([Link](numResponses-i,numColumns-2).getValue()=="") {
[Link](numResponses-i,numColumns-2).setValue([Link](new
Date(), "GMT+8", "MM/dd/yyyy HH:mm:ss")).setFontColor("red");
[Link](numResponses-i,numColumns-1).setValue(e).setFontColor("red");
var response = [Link]().reverseGeocode(value[0], value[1]);
f= [Link][0].formatted_address;
[Link](numResponses-i,numColumns).setValue(f).setFontColor("red");
break; }
}
}
}

else if ([Link](1,numColumns).getValue()!="GeoAddress") {
[Link](1,numColumns+1).setValue("GeoStamp");
[Link](1,numColumns+2).setValue("GeoCode");
[Link](1,numColumns+3).setValue("GeoAddress");

if (numResponses==2) {
[Link](numResponses,numColumns+1).setValue([Link](new
Date(), "GMT+8", "MM/dd/yyyy HH:mm:ss"));
[Link](numResponses,numColumns+2).setValue(e);
var response = [Link]().reverseGeocode(value[0], value[1]);
f= [Link][0].formatted_address;
[Link](numResponses,numColumns+3).setValue(f);
}

else if (numResponses > 2){


[Link](numResponses,numColumns+1).setValue([Link](new
Date(), "GMT+8", "MM/dd/yyyy HH:mm:ss")).setFontColor("red");
[Link](numResponses,numColumns+2).setValue(e).setFontColor("red");
var response = [Link]().reverseGeocode(value[0], value[1]);
f= [Link][0].formatted_address;
[Link](numResponses,numColumns+3).setValue(f).setFontColor("red");
}
}

You might also like