CODEWITHSUNDEEP
androidgoogle-apps-scriptgoogle-sheets
Fisher Wei
Fisher Wei

Reputation: 23

How to run a script which in the google spreadsheet from the Android Google Drive App?

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?

Upvotes: 2

Views: 1845

Answers (2)

quanglewangle
quanglewangle

Reputation: 601

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.

Upvotes: 1

Bruce Christie
Bruce Christie

Reputation: 11

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.

Upvotes: 1

Related Questions