Someone knows why this caused. The script does not have permission to obtain the identity of the active user.
?
I do not have any function that requests the identity of the user. So I'm a little confused.
function onEdit1 (e) {
if (e.range.getA1Notation () == & # 39; D5 & # 39; || e.range.getA1Notation () == & # 39; E5 & # 39; || e.range.getA1Notation () == & # 39; F5 & # 39;) {
var range = e.range;
var now = new date ();
var time1 = Utilities.formatDate (new Date (now.getTime ()), "GMT-8", "E M / d / yy h: mm: ss a");
range.setNote (& # 39; Wait 15 seconds for the calculation to complete in Notes & # 39 ;. + String.fromCharCode (10) + String.fromCharCode (10) + & # 39; Last modification: & # 39; + String.fromCharCode (10) + time1 + & # 39; PST & # 39;);
var sheetUS = SpreadsheetApp.getActive (). getSheetByName (& # 39; US & # 39;);
beginning var = range.getValues ();
var rownum = sheetUS.getRange ("N1"). getValues ();
var term = sheetUS.getRange ("C7: C" + rownum) .getValues ();
if (e.range.getA1Notation () == & # 39; D5 & # 39;) {
var payment = sheetUS.getRange ("D7: D" + rownum) .getValues ();
for (var i = 0; i <term.length; i ++) {
total var = term[i] * payment[i];
var totalinterest = term[i] * payment[i] - beginning
sheetUS.getRange (i + 7, 4) .setNote (
& # 39; Interest on total loan: $ & # 39; + comma (totalinterest.toFixed (2)) + String.fromCharCode (10) + String.fromCharCode (10) +
& # 39; Total payment: $ & # 39; + comma (total.toFixed (2))
);
}
}
}