Google Sheet AppScript Dynamic Notes

So I’m trying to create a spreadsheet with dynamic tooltips using setNote() in AppScript. The user makes a selection from a dropdown and depending on the selection, it will display differing tooltips. Some of them works just fine… The others do not! And I cannot figure it out! Below are the ones that do not work…

function onEdit() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var asheet = ss.getActiveSheet();
  var aname = asheet.getName();
  var arange = ss.getActiveRange().getA1Notation();

  var space = sheet.getRange("Database!$A$1").getDisplayValue();

  var disc = sheet.getRange("Sheet!$CK$121:$CK$124");
  var tilt = sheet.getRange("Sheet!$BC$184:$BC$188");

  // Discipline Notes
  var discdesc1 = sheet.getRange("Database!$BZ$6").getDisplayValue();
  var discby1 = sheet.getRange("Database!$CA$6").getDisplayValue();
  var disc1 = "Used By: " + discby1 + space + discdesc1;

  var discdesc2 = sheet.getRange("Database!$BZ$7").getDisplayValue();
  var discby2 = sheet.getRange("Database!$CA$7").getDisplayValue();
  var disc2 = "Used By: " + discby2 + space + discdesc2;

  const discnotes = [
    [disc1],
    [""],
    [""],
    [disc2]
  ];

  var tiltdesc1 = sheet.getRange("Database!$CO$6").getDisplayValue();
  var tiltpg1 = sheet.getRange("Database!$CP$6").getDisplayValue();
  var tilt1 = tiltdesc1 + space + tiltpg1;

  var tiltdesc2 = sheet.getRange("Database!$CO$7").getDisplayValue();
  var tiltpg2 = sheet.getRange("Database!$CP$7").getDisplayValue();
  var tilt2 = tiltdesc2 + space + tiltpg2;

  var tiltdesc3 = sheet.getRange("Database!$CO$8").getDisplayValue();
  var tiltpg3 = sheet.getRange("Database!$CP$8").getDisplayValue();
  var tilt3 = tiltdesc3 + space + tiltpg3;

  const tiltnotes = [
    [tilt1],
    [""],
    [tilt2],
    [""],
    [tilt3],
    [""]
  ];

  if (aname == 'Sheet' && (arange == 'BC121' || 'BC124')){

    disc.setNotes(discnotes);

  };

  if (aname == 'Sheet' && (arange == 'BC184' || 'BC186' || 'BC188')){

    tilt.setNotes(tiltnotes);

  };
}

I tried this:

  if (aname == 'Sheet' && (arange == 'BC121' || 'BC124')){

    disc.setNotes(discnotes);

  } else if (aname == 'Sheet' && (arange == 'BC184' || 'BC186' || 'BC188')){

    tilt.setNotes(tiltnotes);

  };

Also tried this:

  if (aname == 'Sheet' && (arange == 'BC121' || arange == 'BC124')){

    disc.setNotes(discnotes);

  } else if (aname == 'Sheet' && (arange == 'BC184' || arange == 'BC186' || arange == 'BC188')){

    tilt.setNotes(tiltnotes);

  };

And even tried this!

  if (aname == 'Sheet'){
    if (arange == 'BC121'){

      var disc = sheet.getRange("Sheet!$CK$121");
      var discdesc1 = sheet.getRange("Database!$BZ$6").getDisplayValue();
      var discby1 = sheet.getRange("Database!$CA$6").getDisplayValue();
      var discnotes = "Used By: " + discby1 + space + discdesc1;

      disc.setNote(discnotes);

    } else if (arange == 'BA124'){

      var disc = sheet.getRange("Sheet!$CK$124");
      var discdesc2 = sheet.getRange("Database!$BZ$7").getDisplayValue();
      var discby2 = sheet.getRange("Database!$CA$7").getDisplayValue();
      var discnotes = "Used By: " + discby2 + space + discdesc2;

      disc.setNote(discnotes);

    }
  }

};

I am expecting The “desc” and “by” to get pulled from the Database sheet, which will then join together in discnotes like:

Used By: (by’s answer)

(desc’s answer)

And that will post as a Note into the range CK121 and CK124. Same goes for tiltnotes. But they’re just not happening. Either the notes don’t update or they disappear altogether. And as I’ve said above, the others work just fine and are copies of the first example I posted. Only difference with those are that they’re not arrays, which is why I tried the 3rd attempt. Did not work.

PS: The reason I’m not using onEdit(e) is because I cannot for the life of me, figure out how to use the event objects…