title: Finding Row Number of a change made via changetype = other
body: <p>I need to be able to call the row number where a change was made, when <code>changeType == &quot;OTHER&quot;</code>. Below is a test script (with runNotify triggered via on change) that should email me the row number of the row where the change was made, however it only ever returns &quot;1&quot; as the row number. What am I missing that keeps it from returning the row number of the changed row?</p>
  <pre><code>function notify(request) {
      MailApp.sendEmail(&quot;youremailhere.com&quot;, &quot;Row Added&quot;, request.editedRow);
  }
  
  function runNotify(e) {
    var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(&quot;Y:Y&quot;);
      if (e.changeType == &quot;OTHER&quot;) {
      var request = findRow(e);
      notify(request);
      }
  }
  
  function findRow(e) {
    var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(&quot;Y:Y&quot;);
      if (e.changeType == &quot;OTHER&quot;) {
      this.editedRow = range.getRow();
      return this;
    }
  }
  </code></pre>
  <p>Working code that will call the row being edited following a change made in App Script when used with onChange trigger:</p>
  <pre><code>function notify(request) {
      MailApp.sendEmail(&quot;youremail@gmail.com&quot;, &quot;Row Added&quot;, request.activeRow);
  }
  
  function runNotify(e) {
      if (e.changeType == &quot;EDIT&quot;) {
        var request = findTheRow(e);
        notify(request);
      }   else {
        return;
        }
  }
  
  function findTheRow(e) {
    var sSht = e.source;
    var sht = sSht.getActiveSheet();
    var activeRng = sht.getActiveRange();
    this.activeRow = activeRng.getRow();
    return this;
  }
  
  </code></pre>