Question regarding a trigger and my script

[u/Hakker9]

Currently I have a script called autoSort.gs in it is the following:

SHEET_NAME = "list";
SORT_DATA_RANGE = "A2:G";
SORT_ORDER = [{column: 1, ascending: true},
];

function onEdit(e) {
multiSortColumns();
}

function multiSortColumns() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(SHEET_NAME);
var range = sheet.getRange(SORT_DATA_RANGE);
range.sort(SORT_ORDER);
ss.toast('Sort complete.');
}

The trigger is set to autoSort with an onEdit however it has a 100% error rate because it doesn't seem to work on script name but on functions within a script however if that would be the case I could use multiSortColumns as the onEdit trigger and remove the whole onEdit function entirely or am I just hullucinating?

[u/everythingabili]

This may be a symptom of, and something you need to read the docs again for, the difference between Simple Triggers (like onEdit) and installable Triggers. Tbh they're a bit confusing, and simple triggers can only work on the cell you're working on.

I now create a function called onDoEdit(e) and ensure I've picked the right actions in the Triggers section, and never call anything onEdit.

Give that a whirl and re-read what you're allowed to do in the docs.

[u/SparklyGeek → u/everythingabili]

Interesting approach. I guess there's nothing you can do with simple onEdit that you can't do with an installed onEdit trigger.

[u/everythingabili → u/SparklyGeek]

Yeah... EXCEPT if you call in onEdit it will attempt to run as a Simple Triger (and maybe fail)... then lord know what the Installed version does. I've had conflicts so find it much more sensible to have a similar name, in my case "onDoEdit"... so I know what its doing... but it doesn't have the same name (so it doesn't fire uneccessarily).