onOpen() function gets triggered on desktop but not on Android

1
votes
function onOpen() {  
Logger.log("start");  
Logger.log(SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getSheetName());  
}

The function gets triggered every time I open or refresh my spreadsheet on the desktop as expected but it doesn't get trigger when I open on Android sheets app. I tried clearing cache too but no help! The onEdit() function works as expected on the Android app.

I just want the onOpen() function to get triggered when any user with editing rights to the sheet opens the sheet on the Android app!

1
google-apps-scriptgoogle-sheets
Yeah the mobile apps leave a lot to be desired. I never use them. – Cooper
You should submit a feature request on the Google Apps Script issue tracker or if it already exists star it. For details see developers.google.com/apps-script/support – Rubén
I’m voting to close this question because it's a feature request for Google. – Rubén
What makes you think the onOpen is not running? Have you checked the Executions tab? – Iamblichus
Yesss obviously! – Aashit Garodia

1 Answers

1
votes

This might be a bug:

Sheets onOpen triggers (simple or installed) do not fire when the spreadsheet is opened in mobile.

Reported in Issue Tracker:

This has been previously reported in Issue Tracker, and already filed internally by Google:

I'd suggest you to subscribe to this issue by starring it in order to keep track and to help prioritizing it.