CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-formstriggers
Billy Bilstad
Billy Bilstad

Reputation: 1

Form submission Delete row

I have been using the following code to move and delete row upon completion of line item,

I have now moved from manual entries to line entries via google form and have not been able to achieve the same results.

Any Ideas or help would be greatly appreciated.

I assume that the form submissions are behaving differently and I just have not found the right commands to make it work correctly 

function onEdit(event) {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var s = event.source.getActiveSheet();
    var r = event.source.getActiveRange();

  if(s.getName() == "Open Tickets" && r.getColumn() == 16 && r.getValue() == true) {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("Closed Tickets");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  } else if(s.getName() == "Closed Tickets" && r.getColumn() == 16 && r.getValue() == false) {
    var row = r.getRow();
    var numColumns = s.getLastColumn();
    var targetSheet = ss.getSheetByName("Open Tickets");
    var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
    s.getRange(row, 1, 1, numColumns).moveTo(target);
    s.deleteRow(row);
  }
}

Upvotes: 0

Views: 72

Answers (1)

Wicket
Wicket

Reputation: 38150

As you moved from manual entry to the use of a Google Form you can't use anymore an "on edit" trigger but you could use an form submit installable trigger.

Related

Reference

Upvotes: 1

Related Questions