Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function doGet(e) {
- var op = e.parameter.action;
- var ss = SpreadsheetApp.openById("isi_dengan_id_spreadsheet");
- var sheet = ss.getSheetByName("Sheet1");
- if (op == "insertitem")
- return insert_value(e, sheet);
- }
- // script + ?action=insertitem&versi=versi&macnya=macnya&user=user&appversi=appversi
- function insert_value(request, sheet) {
- var versi = request.parameter.versi;
- var macnya = request.parameter.macnya;
- var user = request.parameter.user;
- var appversi = request.parameter.appversi;
- var currentTime = new Date().toLocaleString();
- var flag = 0;
- var lr = sheet.getLastRow();
- for (var i = 1; i <= lr; i++) {
- //lihat macnya pada kolom ke dua
- var rid = sheet.getRange(i, 2).getValue();
- if (rid == macnya) {
- // update tanggal pada kolom 5
- sheet.getRange(i, 5).setValue(currentTime);
- var result = "Lawas";
- result = JSON.stringify({"Mac": result});
- flag = 1;
- }
- }
- if (flag == 0){
- //tambah baris baru jika macnya pada kolom kedua tidak ada yg sama
- sheet.appendRow([versi,macnya,user,appversi,currentTime]);
- var result = "Anyar";
- result = JSON.stringify({"Mac": result});
- }
- return ContentService
- .createTextOutput(result)
- .setMimeType(ContentService.MimeType.JAVASCRIPT);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement