Executing Google Apps Script Functions from Mobile App

by

The following work with the mobile versions of Google sheets:

  • Custom functions
  • onEdit simple/installed trigger
  • onChange trigger
  • onSelectionEvent trigger(Works partially, if sheets is also open in desktop)

Notes:

  • Avoid calls to get active: getActive() sheet, range or cell. These don’t work in mobile or they return a default value like A1 in the first sheet for range.

  • Avoid calls to ui: getUi(). These have no meaning in the context of mobile app and won’t work. This includes calls to alerts/prompts. More than likely, You’ll hit execution timeout because alerts will wait for user input and this won’t show up in mobile. If you do want to show some message, Here is a excellent workaround using images to do the same.

    • Avoid calls to HtmlService. Sidebars/Modal dialogs are not supported in mobile versions.

    • Buttons/Menu items don’t work.

  • The best way to support apps script is mobile apps is to chain onEdit calls to a checkbox. Click here for a sample.

More Related Contents:

  1. Best practice to create chat application with private rooms
  2. Is it possible for an app to POST to a web browser?
  3. Which solution i can use for guaranteed notifications (it is not about push notification)? [closed]
  4. Simple cross platform trivia game for mobile
  5. HTML file input control with capture and accept attributes works wrong?
  6. Restrict API requests to only my own mobile app
  7. Flutter Keyboard makes textfield hide
  8. scale fit mobile web content using viewport meta tag
  9. Twitter Bootstrap modal on mobile devices
  10. Android apps on ios
  11. HTML5 element on Android
  12. Background image jumps when address bar hides iOS/Android/Mobile Chrome
  13. Creating an Android Service with Phonegap? (Have phonegap app run even when closed)
  14. What are my options for storing data when using React Native? (iOS and Android) [closed]
  15. Xamarin.Forms ListView: Set the highlight color of a tapped item
  16. react-native: command not found
  17. Phonegap – navigator.app.backHistory() not working on HTML back button
  18. screen styling when virtual keyboard is active
  19. Playing local sound in phonegap
  20. Failed to launch emulator: Error: Emulator didn’t connect within 60 seconds
  21. Clarify the Firebase connections
  22. My App was rejected by Instagram Basic Display API review due to invalid reasons
  23. Official “Boost library” Support for Android and iOS? [closed]
  24. How to set build and version number of Flutter app
  25. How to handle app lifecycle with Flutter (on Android and iOS)?
  26. This request is missing a valid app identifier, meaning that neither safetyNet checks nor reCAPTCHA checks succeeded
  27. ADB is not recognizing my device
  28. How to disable font scaling in React Native for IOS And Android app?
  29. Audio format for iOS and Android
  30. Does the Android Emulator support OpenGL ES 2.0?

Leave a Comment