Scribd
Upload
26 views1 page

Spreadsheet Code

This document contains a Google Apps Script that interacts with a Google Sheet to store data. It defines functions to handle GET and POST requests, logging received parameters and storing a name along with the current date and time in specified columns. The script also includes a utility function to strip quotes from input values.

Uploaded by

Konrad Dela Cruz
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
26 views1 page

Spreadsheet Code

This document contains a Google Apps Script that interacts with a Google Sheet to store data. It defines functions to handle GET and POST requests, logging received parameters and storing a name along with the current date and time in specified columns. The script also includes a utility function to strip quotes from input values.

Uploaded by

Konrad Dela Cruz
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

var ss = SpreadsheetApp.

openById('Enter Sheet ID');


var sheet = [Link]('Sheet1');
var timezone = "Enter Time Zone of Your Country";

function doGet(e){
[Link]( [Link](e) );
if ([Link] == 'undefined') {
return [Link]("Received data is undefined");
}
var Curr_Date = new Date();
var Curr_Time = [Link](Curr_Date, timezone, 'HH:mm:ss');
var name = stripQuotes([Link]);
var nextRow = [Link]() + 1;
[Link]("A" + nextRow).setValue(name);
[Link]("B" + nextRow).setValue(Curr_Date);
[Link]("C" + nextRow).setValue(Curr_Time);

return [Link]("Card holder name is stored in column A");


}

function stripQuotes( value ) {


return [Link]().replace(/^["']|['"]$/g, "");
}

function doPost(e) {
var val = [Link];

if ([Link] !== undefined){


var range = [Link]('A2');
[Link](val);
}
}

You might also like