Delete ligne in google sheet with appinventor

eps_info-sport · August 20, 2023, 8:29am

"How can I use a script to delete a row on a Google Sheet using a delete button in App Inventor? The button should search for a name entered in a text box, matching the name in the 7th column of the sheet."
somone help me please;

function doPost(e) {

var nameToDelete = e.parameter.name;

var ss = SpreadsheetApp.openById('1GBmTs_qS2npHSODQWsJwWe8EtYIcENl_VGnG260OhD0'); // Remplacez par l'ID de votre feuille

var sheet = ss.getSheetByName('Feuille 1'); // Remplacez par le nom de votre feuille

var dataRange = sheet.getDataRange();

var values = dataRange.getValues();

for (var i = values.length - 1; i >= 0; i--) {

var name = values[i][6]; // 7ème colonne (indice basé sur 0)

if (name === nameToDelete) {

  sheet.deleteRow(i + 1); // L'indice de ligne est basé sur 1

  return ContentService.createTextOutput('Ligne supprimée avec succès');

}

}

return ContentService.createTextOutput('Nom non trouvé dans la feuille');

}

TIMAI2 · August 20, 2023, 8:37am

Show your relevant blocks.

Has your script been correctly deployed?

eps_info-sport · August 20, 2023, 8:39am

"How can I use a script to delete a row on a Google Sheet using a delete button in App Inventor? The button should search for a name entered in a text box, matching the name in the 7th column of the sheet."
somone help me please;
her is my blocs and script

function doPost(e) {

var nameToDelete = e.parameter.name;

var ss = SpreadsheetApp.openById('1GBmTs_qS2npHSODQWsJwWe8EtYIcENl_VGnG260OhD0'); // Remplacez par l'ID de votre feuille

var sheet = ss.getSheetByName('Feuille 1'); // Remplacez par le nom de votre feuille

var dataRange = sheet.getDataRange();

var values = dataRange.getValues();

for (var i = values.length - 1; i >= 0; i--) {

var name = values[i][6]; // 7ème colonne (indice basé sur 0)

if (name === nameToDelete) {

  sheet.deleteRow(i + 1); // L'indice de ligne est basé sur 1

  return ContentService.createTextOutput('Ligne supprimée avec succès');

}

}

return ContentService.createTextOutput('Nom non trouvé dans la feuille');

}

TIMAI2 · August 20, 2023, 8:56am

Please show your full URL as text. Should you have a ? instead of an & before name ?

eps_info-sport · August 20, 2023, 8:58am

https://script.google.com/macros/s/AKfycbxwBPSx6t6ARGftkiuHh1Ii5IzktHmo0Ds6kVJvEHUcRSu1reVvwN0ZJq6MOQOkc1ez/exec

URL About google sheet:
"https://docs.google.com/spreadsheets/d/1GBmTs_qS2npHSODQWsJwWe8EtYIcENl_VGnG260OhD0/edit#gid=0

TIMAI2 · August 20, 2023, 9:13am

Also, you have dopost in your script but you are making a get request.

Change doPost to doGet and redeploy your script as a new version

eps_info-sport · August 20, 2023, 9:19am

can you help me more

TIMAI2 · August 20, 2023, 11:42am

These blocks

This script

function doGet(e) {

var nameToDelete = e.parameter.name;

var ss = SpreadsheetApp.openById('1GBmTs_qS2npHSODQWsJwWe8EtYIcENl_VGnG260OhD0'); // Remplacez par l'ID de votre feuille
var sh = ss.getSheetByName('Feuille 1'); // Remplacez par le nom de votre feuille
var dataRange = sh.getDataRange();
var values = dataRange.getValues();
  for (var i = values.length - 1; i >= 0; i--) {
    var delVal = values[i][6]; // 7ème colonne (indice basé sur 0)
    if (delVal == nameToDelete) {
     sh.deleteRow(i + 1); // L'indice de ligne est basé sur 1
     return ContentService.createTextOutput('Ligne supprimée avec succès');
    }
  }

return ContentService.createTextOutput('Nom non trouvé dans la feuille');

}

Should be working. Check your Feuille 1 - is there are space between Feuille and 1 ?

eps_info-sport · August 21, 2023, 8:38am

he doesn't work

TIMAI2 · August 21, 2023, 9:39am

What doesn't work ?

Show your sheet, blocks, script and any outputs.

eps_info-sport · August 21, 2023, 10:07am

script:

function doGet(e) {

var nameToDelete = e.parameter.name;

var ss = SpreadsheetApp.openById('1GBmTs_qS2npHSODQWsJwWe8EtYIcENl_VGnG260OhD0'); // Remplacez par l'ID de votre feuille

var sh = ss.getSheetByName('doc'); // Remplacez par le nom de votre feuille

var dataRange = sh.getDataRange();

var values = dataRange.getValues();

  for (var i = values.length - 1; i >= 0; i--) {

    var delVal = values[i][6]; // 7ème colonne (indice basé sur 0)

    if (delVal == nameToDelete) {

     sh.deleteRow(i + 1); // L'indice de ligne est basé sur 1

     return ContentService.createTextOutput('Ligne supprimée avec succès');

    }

  }

return ContentService.createTextOutput('Nom non trouvé dans la feuille');

}

TIMAI2 · August 21, 2023, 10:09am

What do you see in the responseContent ?

eps_info-sport · August 21, 2023, 10:12am

nothing
just somthing lik html head link ......

TIMAI2 · August 21, 2023, 10:23am

Then it is "something" !!

Capture the responsContent to a label, copy the complete content of the label and post it back here as text. The reason is usually at the end of the text/html

[edit] - OK you have done that.

TIMAI2 · August 21, 2023, 10:29am

The script is not finding the sheet named 'doc'

Have you re-deployed your script to a new version?

eps_info-sport · August 21, 2023, 10:29am

my app

eps_info-sport · August 21, 2023, 10:41am

bod nech amolay
it doesn't work it make same problem

TIMAI2 · August 21, 2023, 10:56am

Hmmm

Check you script again for any errors

I am running the same script / blocks / sheet, and it works OK

eps_info-sport · August 21, 2023, 11:14am

ok thank you so much