How To Create A Message Box From Google App Script To Web App

user_13396456 0
Viewed 1682

I'm trying to create a message box from my .gs to my web app, I tried these but the message box couldn't show up:

var html = HtmlService.createHtmlOutputFromFile('View');
SpreadsheetApp.getUi().showModalDialog(html, 'Dialog title');

Browser.msgBox('Hello!', Browser.Buttons.OK);

HtmlService.createHtmlOutput("Hello!");

Are those methods the right way to do it? Your response will be appreciated :)

google-apps-script message arrays web-applications javascript
1 Answers

The methods you are trying to use are designed for use in the context of a Google Spreadsheet

  • You cannot use them within a WebApp, even if your WebApp is bound to a spreadsheet.
  • It would make little sense anyway, since when you deploy a WebApp, you interact with the WebApp interface, not with the spreadsheet UI.
  • Instead you need to use Javascript methods that are accessible from the clientside of your WebApp, see here.

Sample:

Code.js

function doGet() {
  return HtmlService.createHtmlOutputFromFile("index");
}


function called(){
  
  Logger.log("I was called");
  //the rest of your code
}

index.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
    <script>
    if (confirm("Please confirm, are you sure you want to continue?")) {
     alert( "google.script.run will be called");
     google.script.run.called();
   } else {
    alert( "You cancelled!");
   } 
    </script>
  </body>
</html>
user_115997890
Related