Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google apps script location.reload in web app

I am using a GAS web app that needs to refresh its contents when a user takes certain actions (like clicking on a particular div).

On the clientside, I have this script that gets called from onclick

google.script.run.withSuccessHandler(refreshCallback).myServersideFunction();

function refreshCallback(roomsPlus) {
    var statusDiv = document.getElementById("status");
    statusDiv.innerHTML = "Reloading...";
    window.location.reload(true);
};

The status div changes to "Reloading..." so I know the callback gets called,but then it never reloads the page. Does Caja or google apps script disable page refreshing? Is there another way to refresh the page?

like image 530
perpetual Avatar asked Feb 03 '13 16:02

perpetual


People also ask

How do I Deploy a Google script to the Web app?

At the top right of the script project, click Deploy > Test deployments. Next to "Select type," click Enable deployment types settings > Web app. Under the web app URL, click Copy. Paste the URL in your browser and test your web app.

Where are Google script files stored?

Google Apps Script projects are now included in the docs list in Google Drive. - Your projects are now stored in Google Drive and can be shared just like any other file.


2 Answers

All you need to do is use:

window.open("https://script.google.com/macros/s/web_app_ID/dev",'_top');

My original answer below works, but is un-needed:

There is a programmatic "Work Around" to reload/refresh the page in an Apps Script Web App. It is based on the capability of an html link tag to reload the page, and the ability of JavaScript to invoke the click event on that tag. You can hide the link if you want.

  • Add a link tag to your HTML
  • Hide the link tag if you wish
  • Add client side code in a script tag to invoke the click event on the link tag
  • Run the code however you want

Test Button:

<button onmouseup="reloadTheWebApp()">Trigger the Link Tag</button>

Link:

<a id="testLink" style="display:none" 
   href="https://script.google.com/macros/s/script_ID/exec">Reload the Web App</a>

Script:

<script>

  window.reloadTheWebApp = function() {
    console.log('reloadTheWebApp ran');

    var linkTag = document.getElementById('testLink');

    linkTag.click();
  }

</script>

It may be preferable to implement a simple page navigation system:

Page Navigation Web App - Apps Script

like image 173
Alan Wells Avatar answered Oct 12 '22 15:10

Alan Wells


EDIT

Caja was removed July 16, 2016 from Web App HtmlService.

Native Sandbox Mode

An Update to HTML Service

End of edit

Unfortunately the Caja sanitization engine used by HtmlService restricts access to the window object, preventing you from programatically reloading the page. This is a known restriction of the service and we are working to better document it.

like image 43
Eric Koleda Avatar answered Oct 12 '22 14:10

Eric Koleda