• View
• Edit
• History
• Print

Gscript-googleSheet

var sss = SpreadsheetApp.openById('1sWwME-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx');  //id spreadsheet
var sh1 = sss.getSheetByName('Sheet1');


function simpan01(cid,tid){
 var y = sh1.getLastRow()                       //cari baris paling bawah
  for(var i=1;i<y+1;i++){
    var value = sh1.getRange("A"+i).getValue(); //baca semua kolom A
    if(value == cid){                           //apakah item yg dicari ada di kolom A
      var cr = i;
      console.log("oke") 
    }
  }

  if(cr == undefined) {
    console.log("nooooooooooo");
  }else{
    var ex = sss.getRange("B"+cr).getValue();
    var sx = sss.getRange("C"+cr).getValue();
    var ha = "Kode "+cid+"\n"+ex+"\n\n"+sx
      sendText(tid,ha)
    return ha

  }  
  sendText(tid,"Maaf, Kode yang dimasukkan tidak dikenali...!!!")
  return
}///////


///cari 
function yebe(searchVal) {

//var searchVal = "GARUDA7PTRUZD7UPTP7E2VKN4Qxxxxxxxxxxxxx"
var sss = SpreadsheetApp.openById('1gA3LlMiIJL4rw0iQ3s5qGRNl4QAIinh7JW1m8UJ5U_M');
var sh1 = sss.getSheetByName('Sheet1');

  var data = sh1.getDataRange().getValues();
  var columnCount = sh1.getDataRange().getLastColumn();
  var i = data.flat().indexOf(searchVal); 
  var columnIndex = i % columnCount
  var rowIndex = ((i - columnIndex) / columnCount);

  var va = sh1.getRange("A"+(rowIndex+1)).getValue(); 
  var vb = sh1.getRange("B"+(rowIndex+1)).getValue(); 
  var cx = false

  if(rowIndex>0){
    console.log(va+"\n"+vb+" YBX")
    return va+"\n"+vb
  }

  if(cx==false){return "Not Found...!!!"}

  //return i >= 0 ? rowIndex + 1 : "searchVal not found";
}///

///////////////////////////////

function doGet(request) {

  var params = request.queryString

//return HtmlService.createHtmlOutput(params);

  if (params.split("pk=").length == 2){

  var pk = request.parameters.pk
  var rx = getStellarAccountInfo(pk)
  return ContentService.createTextOutput(JSON.stringify(rx))  
  .setMimeType(ContentService.MimeType.JSON);

  }
}
////////////////////////////////