0

I can't pass data from JavaScript function to Apps Script (code.gs) function.

Code.gs code worked when I set rowId variable manually.

I have also CL JavaScript function (When I clicked on button I get 24 in Console)

Code.gs

function deleteUserAdminData(tableObject) {
const url = "#";
const ss = SpreadsheetApp.openByUrl(url);
const ws = ss.getSheetByName("Admin");
const lastRow = ws.getLastRow();
const range = ws.getRange("A2:A" + lastRow);
const idData = range.getValues();
const rowId = tableObject; // Mistake here? (Function work when I set variable manually. 

for (let i = 0; i < idData.length; i++) { 
    if (idData[i][0] === rowId) {  
        let selectedRow = Number([i]) + 2;  
        ws.deleteRow(selectedRow); 
    }
}

Javascript

function deleteAdminTableRow(tableObject) {
    google.script.run.deleteUserAdminData(tableObject);
    alert("Data deleted!")
}

HTML

<button class="delete" value"24" type="submit" name="id" onclick="deleteAdminTableRow(24)">DELETE</button>
Rubén
  • 34,714
  • 9
  • 70
  • 166
Goci
  • 1

0 Answers0