0

In a Google Apps Script web app (doGet()), I want to refresh display once a certain spreadsheet changes. I was thinking about polling the spreadsheet every ten seconds or so. However, there seems to be no timer, only an ugly workaround (though, smart it is).

Any idea how to realize an automatic refresh?

feklee
  • 7,555
  • 9
  • 54
  • 72
  • Related [How do I make a Sidebar display values from cells?](https://stackoverflow.com/q/30628894/1595451) – Rubén May 16 '19 at 13:20

1 Answers1

2

If you use HtmlServices to build your app, then you'll have javascript regular setTimeout function where you can configure your timer easily. On UiApp though, I think you're restricted to the very smart workaround you linked.

Henrique G. Abreu
  • 17,406
  • 3
  • 56
  • 65
  • Thanks for the suggestion to use HtmlServices! I didn't think about that, and I believe it is an option for the app in question. – feklee Aug 27 '12 at 20:31