Buttons don't work on iPad with Google Sheets - the onEdit(e) workaround isn't working. Suggestions?

Question

I have a button that works with the function Yeah_Go(), but only when using it on a browser on a laptop. When I try to press the button on an iPad Google Sheets mobile app, it doesn't work. Instead, the drawing is selected and moveable. Not my intention, eh?

Yeah_Go() works properly when you call it directly from the imported macros list, basically, a verify alert Okay_Cancel that leads to another function.

Apparently, button nonfunction is a known challenge on iPads.

It has been suggested to try the onEdit(e) function thus:

function onEdit(e) {
  console.log("Function triggered");
  var sheet = SpreadsheetApp.getActiveSheet();
  var r  = sheet.getRange("J17").getValue();
  if (r == "TRUE") {
    Yeah_Go();
  }
}

When I check the checkbox in J17, nothing happens. Similarly, when I run the macro from the list of imported macros, nothing happens. Not even a happy note in the console...

How can I improve this so it actually works?

Answer 1

Event object fields are text strings, but if you use .getRange().getValue() to get the real value in a cell, the possible values of a checkbox cell with default settings are the Booleans true and false rather than the text strings 'TRUE' and 'FALSE'.

To make your script work, take advantage of the event object, like this:

function onEdit(e) {
  if (e.value === 'TRUE' && e.range.getA1Notation() === 'J17') {
    Yeah_Go();
  }
}