'How to move row to another sheet base on typed by user id? Google Script, HTML
When user clicks button "delete",I want to selected row is moving to another sheet
HTML
function Dialo() {
let a_id_form ={}
a_id_form.input = document.getElementById("id").value
google.script.run.withSuccessHandler(a => {
if (confirm("Do you wanna delete?")) {
alert("Deleted");
} else {
alert("Not Deleted");
}
}).moveToArchive(a_id_form);
}
GOOGLE SCRIPT
function moveToArchiwum(Dialo){
let nR = searchId(Dialo.input);
let copyToArch = {};
copyToArch.id = sheet_spis.getRange(nR, column_id).copyTo(sheet_archive.getRange(lastRow, archive_column_id), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
return copyToArch;
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
