对多列范围排序脚本

Question

Here is a well working script which :
1- Drop a date tag in the cell H (8) for each modification in a row (I know there is something wrong in this command but it does what I am expecting...)
AND
2- Sort the whole sheet following this rule :
- column 1 : ascendent,
- column 2 : ascendent,
- column 3 : ascendent and
- column 8 ; descendent.

问题：
1- 如何将范围 (A2:K999) 添加到第二个顺序（排序）？
2- 如何向第二个命令（排序）添加触发器（按钮或菜单或其他）？

有人可以帮我吗？

function onEdit(e) {

var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh0 = ss.getSheets()[0];

  var row = e.range.getRow();
  e.source.getActiveSheet().getRange(row,8).setValue(new Date());


 
var sheet = SpreadsheetApp.getActiveSheet(); 
var dataRange = sheet.getDataRange(); 
dataRange.sort([ 
  {column: 1, ascending: true}, 
  {column: 2, ascending: true}, 
  {column: 3, ascending: true}, 
  {column: 8, ascending: false} ]);


  }

Answer 1

尝试：

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var range = sheet.getRange("A2:K999");

function onEdit(e)  {
range.sort([{column: 1, ascending: true}, {column: 2, ascending: true}, {column: 3, ascending: true}, {column: 8, ascending: false}]);
}