2

I have tried the following:

  1. Create a menu item
    -> the menu cannot be found in android google drive app.

  2. Draw a button and assign function
    -> android google drive app cannot show the button.

  3. Add function to onOpen()
    -> when I open spreadsheet from android google drive app, the function doesn't be executed.

So, how to do it?

Mogsdad
  • 44,709
  • 21
  • 151
  • 275
Fisher Wei
  • 23
  • 1
  • 5

2 Answers2

1

The only way I have found to run scripts from within the Google Sheets app is to use the onEdit() trigger. You devise a code that will never be entered as real data. When you enter the code onEdit() can run the script function as if you ran it from the menu or Script Editor. It sounds hokey but it actually works pretty well.

Mayank Patel
  • 3,868
  • 10
  • 36
  • 59
Bruce Christie
  • 11
  • 1
1

FYI. Now, with latest app update you can at least see drawings in Android Google Sheets App, but the "assigned script" (assigned from script editor in desktop version, that is) doesn't seem to fire.

quanglewangle
  • 581
  • 1
  • 5
  • 14