+ Reply to Thread
Results 1 to 4 of 4

Show pop-up to all viewers upon opening Google Sheet on iPhone/Android

  1. #1
    Registered User
    Join Date
    04-30-2021
    Location
    Salem, MA
    MS-Off Ver
    Google sheets
    Posts
    2

    Show pop-up to all viewers upon opening Google Sheet on iPhone/Android

    Hi all,

    I would like to show a pop-up dialog box with a simple OK button to dismiss the box. I want every viewer (not just editors) of the sheet to see it each time s/he opens the Google Sheet on their phone. The script below works on desktop Google Sheets, but of course not on the phone app.

    function onOpen() {
    var result = SpreadsheetApp.getUi().alert("💡 Last updated by THM 4/30/21. Please remember to unfilter sheet when you are done. Bottom of your screen will show the other tabs for Land/Storage/Parking and Underground",SpreadsheetApp.getUi().ButtonSet.OK);
    }

    Anybody know of a way to do this on Android/iOS Google Sheets?

    Thanks!
    -Theresa

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,910

    Re: Show pop-up to all viewers upon opening Google Sheet on iPhone/Android

    This is an Excel forum - you may want to search out a forum specific to Google Sheet Scripting.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    04-30-2021
    Location
    Salem, MA
    MS-Off Ver
    Google sheets
    Posts
    2

    Re: Show pop-up to all viewers upon opening Google Sheet on iPhone/Android

    Thanks, Bernie. I'll try that. I was thinking that it was more of a Google Sheet thing, but I do see your point.

  4. #4
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Show pop-up to all viewers upon opening Google Sheet on iPhone/Android

    mobile devices have been unable to process the Class UI since about 2019.
    you will need to deploy the App Script as an API.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macros (VBA code) not firing after opening on Android.
    By kend0g187 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-21-2021, 07:47 PM
  2. Excel with VBA not opening on an iPad or iPhone
    By Ed_Collins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2017, 11:41 AM
  3. Is it possible to use the filter function in Google Docs through Android mobile phone?
    By otterandrews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-14-2014, 03:00 AM
  4. How can't view and use filter data function in Google spreadsheet thought my Android phone
    By otterandrews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-08-2014, 10:37 AM
  5. create macro in excel to move my iphone notes to android software
    By tceg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 05:04 PM
  6. create macro in excel to move my iphone notes to android software
    By tceg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 01:31 PM
  7. Tapatalk - iPhone and Android App for communicating in Forums
    By alansidman in forum The Water Cooler
    Replies: 2
    Last Post: 01-30-2012, 06:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1