I want to use Google Spreadsheet as database-like. Normally, this is isn’t posibble at all. But not impossible. I coded a simple CRUD script for spreadsheet. You can use it for developing row-by-row logging apps.
Enjoy !
var belge=SpreadsheetApp.getActiveSpreadsheet();
var sayfa=belge.getSheets()[0];
function save(data1) {
var lr=sayfa.getLastRow();
var new_record_row=lr+1;
//generate id
var id=uid();
sayfa.getRange(new_record_row, 1).setValue(id)
sayfa.getRange(new_record_row, 2).setValue(data1)
return “Saved”;
}
function update(uid,new_value){
var lr=sayfa.getLastRow();
for(i=1;i
var okunan=sayfa.getRange(i,1);
var okunan_deger=okunan.getValue();
var snc=okunan_deger.indexOf(uid);
if(snc != -1){
var secili_satir=sayfa.getRange(i,2).setValue(new_value);
}
}
return “Updated”;
}
function remove_row(uid){
var lr=sayfa.getLastRow();
for(i=1;i
var okunan=sayfa.getRange(i,1);
var okunan_deger=okunan.getValue();
var snc=okunan_deger.indexOf(uid);
if(snc != -1){
sayfa.deleteRow(i);
}
}
return “Removed”;
}
function test(){
remove_row(“20125171339918788818”);
}
function uid(){
var dateObject = new Date();
var uniqueId =
dateObject.getFullYear() + “ +
dateObject.getMonth() + ” +
dateObject.getDate() + “ +
dateObject.getTime();
var uid=uniqueId.toString();
return uid;
}
function delete_record(uid){
var lr=sayfa.getLastRow();
for(i=1;i
var okunan=sayfa.getRange(i,1);
var okunan_deger=okunan.getValue();
var snc=okunan_deger.indexOf(uid);
if(snc != -1){
var secili_satir=sayfa.getRange(i,2).setValue(“deleted”);
}
}
}