Appscript Google spread sheet
Budget: $10 – $30 USD
I want to split the data on column B with delimiter data to column C
For example
Column B = Name, 1234
SPLIT so output is
Column B= Name
Column C = 1234
Code im working on is
var ss = SpreadsheetApp.openById('1D_oE-3VRWNxwVZ08SLTIByTZ8k');
var sheet = ss.getSheetByName('Sheet1');
var timezone = "asia/qatar";
var hours = 3 ;
//
function doGet(e){
Logger.log( JSON.stringify(e) );
//----------------------------------------------------------------------------------
//write_google_sheet() function in esp32 sketch, is send data to this code block
//----------------------------------------------------------------------------------
//get gps data from ESP32
if (e.parameter == 'undefined') {
return ContentService.createTextOutput("Received data is undefined");
}
//----------------------------------------------------------------------------------
var Curr_Date =new Date(new Date().setHours(new Date().getHours() + hours));
var Curr_Time = Utilities.formatDate(Curr_Date, timezone, 'HH:mm:ss');
var name = stripQuotes(e.parameters.name);
Logger.log('name=' + name);
//----------------------------------------------------------------------------------
var nextRow = sheet.getLastRow() + 1;
sheet.getRange("A" + nextRow).setValue(Curr_Date);
sheet.getRange("B" + nextRow).setValue(name); // i want to split this to C
sheet.getRange("D" + nextRow).setValue(Curr_Time);
//----------------------------------------------------------------------------------
//returns response back to ESP32
return ContentService.createTextOutput("Card holder name is stored in column B");
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
function stripQuotes( value ) {
return value.toString().replace(/^["']|['"]$/g, "");
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
//Extra Function. Not used in this project.
//planning to use in future projects.
//this function is used to handle POST request
function doPost(e) {
var val = e.parameter.value;
if (e.parameter.value !== undefined){
var range = sheet.getRange('A2');
range.setValue(val);
}
}
For example
Column B = Name, 1234
SPLIT so output is
Column B= Name
Column C = 1234
Code im working on is
var ss = SpreadsheetApp.openById('1D_oE-3VRWNxwVZ08SLTIByTZ8k');
var sheet = ss.getSheetByName('Sheet1');
var timezone = "asia/qatar";
var hours = 3 ;
//
function doGet(e){
Logger.log( JSON.stringify(e) );
//----------------------------------------------------------------------------------
//write_google_sheet() function in esp32 sketch, is send data to this code block
//----------------------------------------------------------------------------------
//get gps data from ESP32
if (e.parameter == 'undefined') {
return ContentService.createTextOutput("Received data is undefined");
}
//----------------------------------------------------------------------------------
var Curr_Date =new Date(new Date().setHours(new Date().getHours() + hours));
var Curr_Time = Utilities.formatDate(Curr_Date, timezone, 'HH:mm:ss');
var name = stripQuotes(e.parameters.name);
Logger.log('name=' + name);
//----------------------------------------------------------------------------------
var nextRow = sheet.getLastRow() + 1;
sheet.getRange("A" + nextRow).setValue(Curr_Date);
sheet.getRange("B" + nextRow).setValue(name); // i want to split this to C
sheet.getRange("D" + nextRow).setValue(Curr_Time);
//----------------------------------------------------------------------------------
//returns response back to ESP32
return ContentService.createTextOutput("Card holder name is stored in column B");
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
function stripQuotes( value ) {
return value.toString().replace(/^["']|['"]$/g, "");
}
//MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
//Extra Function. Not used in this project.
//planning to use in future projects.
//this function is used to handle POST request
function doPost(e) {
var val = e.parameter.value;
if (e.parameter.value !== undefined){
var range = sheet.getRange('A2');
range.setValue(val);
}
}