1

I have a Google Apps Script that I've published as a Web App.

It's all working fine - getting and updating data in a spreadsheet.

I'd like it so that if the spreadsheet is edited while the web app page is open in a browser it can reload the data (to get the changes.)

How can I call a client-side javascript function from the onEdit() event handler?

Or can I display a message to the user to tell them to reload the page. (Apparently I can't reload it for them: Google apps script location.reload in web app )

Would it need to be a simple event handler, or installed?

A hack-y way to do it would just be to reload the data every 20 minutes, but I'd like this to be used on mobile devices, so that might use up too much data!

Community
  • 1
  • 1
Redzarf
  • 2,578
  • 4
  • 30
  • 40

0 Answers0