//for Ai2
function doPost(e) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName(e.parameters.sheet);
var rng = sh.getRange(e.parameters.range);
rng.setValue(e.parameters.newValue);
return ContentService.createTextOutput('Cell ' + e.parameters.range + ' updated');
}

//for testing in a computer browser e.g.
//https://script.google.com/macros/s/AKfycbyiOc-CINlYKOOetq6VGI7MHTTcf92ZiE3A8HJ9o-Jh-L6myQ/exec?sheet=Sheet1&range=B7&newValue=AI2
function doGet(e) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName(e.parameters.sheet);
var rng = sh.getRange(e.parameters.range);
rng.setValue(e.parameters.newValue);
return ContentService.createTextOutput('Cell ' + e.parameters.range + ' updated');
} 

function doGet(e) { 
  var ss = SpreadsheetApp.openByUrl("docs.google.com/spreadsheets/d/1cY0TM842BLdZgXc3rYAzI5nmyG5ysnzv5HiN6dBmPGw/edit#gid=351458939");
  var sheet = ss.getSheetByName("dbconsum"); 
  
  addUser(e,sheet);
}
 
function doPost(e) { 
  var ss = SpreadsheetApp.openByUrl("docs.google.com/spreadsheets/d/1cY0TM842BLdZgXc3rYAzI5nmyG5ysnzv5HiN6dBmPGw/edit#gid=3514589");
  var sheet = ss.getSheetByName("dbconsum"); 
  
  addUser(e,sheet);
}
  

function addUser(e,sheet) {
  var kdbrg = e.parameter.kdbrg ;
  var tgl = e.parameter.tgl ;
  var nmbrg = e.parameter.nmbrg ;
  var satuan = e.parameter.satuan ;
  var asetawal = e.parameter.asetawal ;
  
  sheet.appendRow([kdbrg,tgl,nmbrg,satuan,asetawal]);
}


function myFunction() {
  
}