jQuery Check if button clicked True

Question

I have a container bound script which displays an HTML sidebar where the user enters an item ID to delete the row in which the ID is located.

Before the user deletes the item, I want to display a custom alert where the user has to confirm the deletion by pressing the confrimDelete button in the pop-up.

The Problem:
I need the confrimDelete button to run:
1

google.script.run.deleteItems(i);
$('#removeElectronicsFrom').trigger("reset");

And the cancelDelete button needs to run:
2

$('#alert').fadeOut(200)
$('#removeElectronicsFrom').trigger("reset");

I thought i could achieve this by using .data() but as you can see my current code dosen't work what so ever, i tried using the .click() method but this also dosen't work because google.script.run.deleteItems(i); has to be run inside the Form event Listener, i don't know why but it won't run outside it.

Flow
enter ID & submit ⇨ $('#alertwrapper').show(); ⇨ if confirmDelete == true run 1 ⇨ else if cancelDelete == true run 2.

GS

function getItemName(formObject) {
  const electronicsID = formObject.electronicsLocalID;
  const SHEET = getSheet();
  const RANGE = SHEET.getDataRange();
  const DELETE_VAL = electronicsID;
  const ITEMNAMECOL = 2;
  const LOCAL_ID = 1;
  const rangeVals = RANGE.getValues();
  for (var i = rangeVals.length - 1; i >= 0; i--) {
    if (rangeVals[i][LOCAL_ID] === DELETE_VAL) {
      return {
        i,
        itemName: rangeVals[i][ITEMNAMECOL],
      };
    }
  }
  return {i, itemName: "not found"};
}
function getSheet() {
  const SS = SpreadsheetApp.openById(
    '1GSzlzj7nHPIUt-RIJfsPFobtnLbuoXedtJk1x11BdT0'
  );
  const SHEET = SS.getSheetByName('ElektronikBestand');
  return SHEET;
}
function deleteItems(i) {
  getSheet().deleteRow(i + 1);
}

HTML




  
    
    
    
    
  
  
  
    
        
            
        Loading...
      
    
      
    
          
              
          
    
          
              
              Elektronik 
 Entfernen
          
    
          
    
          
              
              
                  
                      Lokale ID
                  
    
                  
              
    
              
                  
              
    
          
    
      
      
          
              
                  
              
              
                   Are you sure that you want to delete?

Column B	Column C
ID	itemName
--	--
MUCH00000001	Item1
MUCH00000002	Item2
MUCH00000003	Item3
MUCH00000004	Item4
MUCH00000005	Item5
MUCH00000006	Item6
MUCH00000007	Item7
MUCH00000008	Item8
MUCH00000009	Item9
MUCH00000010	Item10

user30hu · Answer

I would consider doing it this way:

function getItemName(obj) {
  const id = obj.ID;
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName("Sheet0");
  const rg = sh.getRange(2,1,sh.getLastRow() - 1,sh.getLastColumn());
  const vs = rg.getValues();
  vs.forEach((r,i)  => {}) {
    if(r[1] == id ) {
      let r = SpreadsheetApp.getUi().prompt("Confirm Delete",`Are you sure you wish to delete ${r[2]}`,SpreadsheetApp.getUi().ButtonSet.YES_NO);
      if(r.getSelectedButton() == SpreadsheetApp.getUi().Button.YES) {
        sh.deleteRow(i+2);
        return {del: true}
      } else {
        return {del: false}
      }
    }
  }
}

And simplifying your html as required

jQuery Check if button clicked True

1 Answers