Fitur Delete on Table View Extension

[D20_121_Rahel_Naufal (D20_121_ Rahel Naufal Prihantoro)]

hello everyone, can you help me in creating a delete feature on table view extension from spreadsheet to kodular?

[D20_121_Rahel_Naufal (D20_121_ Rahel Naufal Prihantoro)]

This my blocs

[Taifun]

You have to write a function in your Google Apps Script and call that delete function similar as you are already doing it here

Apk to Spreadsheet

[IMG-20240603-WA0005]

To use the Delete method from the web component will not help

Taifun

[D20_121_Rahel_Naufal (D20_121_ Rahel Naufal Prihantoro)]

This my java script

// Ganti dengan URL spreadsheet Anda
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1q8SLZJ1us-lV8g36_cFmSdDG7feA38D_NHqhZ6hDOVE/edit?gid=559411322#gid=559411322");
var sheet = ss.getSheetByName("ADMIN");

function doPost(e) {
  Logger.log("Received POST request with data: " + JSON.stringify(e));

  // Memeriksa apakah ada data parameter yang dikirim
  if (!e || !e.parameter) {
    Logger.log("Error: Missing parameters");
    return ContentService.createTextOutput('Error: Missing parameters').setMimeType(ContentService.MimeType.TEXT);
  }

  var action = e.parameter.action;
  Logger.log("Action: " + action); // Tambahkan log ini untuk memeriksa nilai action

  // Menangani aksi berdasarkan permintaan POST
  if (action === "tambah") {
    return Tambah(e);
  } else if (action === "hapus") {
    return Hapus(e);
  } else {
    return ContentService.createTextOutput("Invalid action").setMimeType(ContentService.MimeType.TEXT);
  }
}

function Tambah(e) {
  var resi = e.parameter.no_resi;
  var jenis = e.parameter.jenis_pembayaran;

  // Memeriksa keberadaan parameter yang diperlukan
  if (!resi || !jenis) {
    return ContentService.createTextOutput('Missing parameters').setMimeType(ContentService.MimeType.TEXT);
  }

  var lr = sheet.getLastRow();
  var flag = false;
  var result = "Berhasil Input";

  // Memeriksa apakah no_resi sudah ada sebelumnya
  for (var i = 1; i <= lr; i++) {
    var resi1 = sheet.getRange(i, 1).getValue();
    if (resi1 == resi) {
      flag = true;
      result = "ID Sudah ada";
      break;
    }
  }

  // Jika no_resi belum ada, tambahkan data baru ke dalam spreadsheet
  if (!flag) {
    sheet.appendRow([resi, jenis]);
  }

  return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.TEXT);
}

function Hapus(e) {
  var resi = e.parameter.no_resi;

  // Memeriksa keberadaan parameter yang diperlukan
  if (!resi) {
    return ContentService.createTextOutput('Missing parameters').setMimeType(ContentService.MimeType.TEXT);
  }

  var lr = sheet.getLastRow();
  var flag = false;
  var result = "ID Tidak ditemukan";

  // Mencari dan menghapus baris dengan no_resi yang sesuai
  for (var i = 1; i <= lr; i++) {
    var resi1 = sheet.getRange(i, 1).getValue();
    if (resi1 == resi) {
      sheet.deleteRow(i);
      result = "Berhasil Dihapus";
      flag = true;
      break;
    }
  }

  if (!flag) {
    result = "ID Tidak ditemukan";
  }

  return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.TEXT);
}

i use this tableview extension [REBORN !] TableView Extension Versions 3&4 (pre nb191) and 5 by @Ken - Extensions - MIT App Inventor Community

[Taifun]

@D20_121_Rahel_Naufal

can you help me in creating a delete feature on table view extension from spreadsheet to kodular?

read the spreadsheet again and display the result in the tableview
Taifun

[D20_121_Rahel_Naufal (D20_121_ Rahel Naufal Prihantoro)]

I have succeeded in displaying data from a spreadsheet into a table view