Advertisement
retnet

google script insert cell advanced

Jan 7th, 2023
1,688
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function doGet(e) {
  2.     var op = e.parameter.action;
  3.     var ss = SpreadsheetApp.openById("isi_dengan_id_spreadsheet");
  4.     var sheet = ss.getSheetByName("Sheet1");
  5.     if (op == "insertitem")
  6.         return insert_value(e, sheet);
  7. }
  8. // script + ?action=insertitem&versi=versi&macnya=macnya&user=user&appversi=appversi
  9. function insert_value(request, sheet) {
  10.   var versi = request.parameter.versi;
  11.   var macnya = request.parameter.macnya;
  12.   var user = request.parameter.user;
  13.   var appversi = request.parameter.appversi;
  14.   var currentTime = new Date().toLocaleString();
  15.   var flag = 0;
  16.   var lr = sheet.getLastRow();
  17.   for (var i = 1; i <= lr; i++) {
  18.         //lihat macnya pada kolom ke dua
  19.         var rid = sheet.getRange(i, 2).getValue();
  20.         if (rid == macnya) {
  21.             // update tanggal pada kolom 5
  22.           sheet.getRange(i, 5).setValue(currentTime);
  23.           var result = "Lawas";
  24.           result = JSON.stringify({"Mac": result});
  25.           flag = 1;
  26.         }
  27.     }
  28.     if (flag == 0){
  29.         //tambah baris baru jika macnya pada kolom kedua tidak ada yg sama
  30.         sheet.appendRow([versi,macnya,user,appversi,currentTime]);
  31.         var result = "Anyar";
  32.         result = JSON.stringify({"Mac": result});
  33.     }
  34.     return ContentService
  35.         .createTextOutput(result)
  36.         .setMimeType(ContentService.MimeType.JAVASCRIPT);
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement