It is necessary that, in the mobile version of the Google spreadsheet (on a mobile phone), the script scrolls / activates the bottom cell of the table.

In the desktop version of Google Spreadsheets It works!! :

var ss=SpreadsheetApp.getActiveSpreadsheet();
  ss.setActiveSelection('A' ss.getLastRow());
  SpreadsheetApp.flush();

But this script does not work in a mobile phone (maybe due to the reduced capabilities of the mobile version of the table).

But still I hope - Connoisseurs will prompt me something!

CodePudding user response：

This probably isn't an issue with your code but the fact that googles mobile apps don't support Google Script or their triggers, Try using the mobile browser view of google sheets that might work.

CodePudding user response：

Long story short, onOpen() triggers do not work on mobile (as stated by Ryan), nor is there an AppScript or Macro menu. One thing that does work, though, is onEdit() triggers.

From my experience, the only way to accomplish something like this would be to implement an onEdit() function with a checkbox. This method would not be automatic when opening the sheet, but upon opening the sheet on mobile, the user could then check off that box, and the script would run. Let me know if this is a method you would be interested in trying out, and I can edit this post to provide you with some code (I am not providing it initially since it doesn't really answer your question or truly solve your issue).