Modal window issues

[Andrew Apell]

Hi guys.

Is there anyone having trouble displaying modal windows in Google Sheets?

Say, when someone clicks a menu item, it just displays the "loading" message but the window never appears.

What could be the cause?

[Andrew Roberts]

Disabling V8 is probably the first thing to try.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1b832772-2aff-4421-8b14-c6daaebb8a7bn%40googlegroups.com.

[Alan Wells]

The first thing you should always ask is:

"Did I just change something?"

If you did, then the probability is very high that it came from the code you just changed.

But, you didn't state whether anything was changed or not.

It could be:

- an authorization issue.

- server code parsed wrong

- client side code parsed wrong

If the menu was built, then I'm guessing that it was built from a "simple" onOpen() function.

A simple trigger doesn't require authorization.

Loading the dialog does require authorization for prompts and dialogs.

The authorization could have been lost somehow.

If the client side code was parsed incorrectly,

you should have an error in the browser developer tools console log when the code runs

that there was an uncaught error.

If there was a server code failure then you  might have a failed execution in your executions list.

Those are the basics.

We don't know if you did the basic work to try to find the problem yourself.

[Andrew Apell]

Thanks or the tips guys.

Turning off V8 is not an option for me; V8 has brought me some good benefits.

I didn't change anything in the code and this error is reported randomly... I guess I closer look at the error logs is what's left now.
As far as I know, there are no authorization issues that could be causing the conflict; the code is quite simple.

[Darren D'Mello]

It could also be due to Global variables issue. Do you use any libraries?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/03d33508-67d7-470c-81c7-d2a153b65c38n%40googlegroups.com.

--

Best,

Darren

[Andrew Apell]

I don't use any libraries but I have one global variable

[Alan Wells]

Use an Immediately Invoked Function Expression (IIFE) to define your global.

(function(){
  
  /*IMPORTANT -

    Do NOT use the "var" key word to define the variable name -

    If a variable is assigned a value without a var key word then it is put into the globlal scope -

    Global variables can cause a fatal error during the parsing of the JavaScript before the code is even run -
    If that happens then your code will never run -
    Globals can stop the add-on menu from being displayed -
    So setting the globals correctly is extremely important -
  */
 
  TEST_GLBL = "SOMTHING";
 
  //Logger.log('TEST_GLBL inside IIFE: ' + TEST_GLBL)

  
})();

[Andrew Apell]

.... interesting solution; thanks!

[Clark Lind]

Also make sure you are using an onSuccess handler. I think previously you could just call google.script.run.myfunction(), but I think you now must use 

google.script.run.onSuccessHandler(do something with the response in the html file).myfunction()

Not sure if this is your issue.. I know it fixed some of my code.

On Thursday, April 1, 2021 at 5:41:09 AM UTC-4 Andrew Apell wrote:

Guys, are the any back-end changes to Apps Script that would cause google.script.run or modal windows in general to fail?

[Faustino Rodriguez]

I am still able to call google.script.run.myfunction() without any handlers for Modeless dialog, haven't tried for Modal