Auto Refresh

[jayjay]

I like to use this product to build dashboard, which means auto refresh function. Is their any way to set this so the data get refreshed every 5 sec for example ?

Jay

[Ben]

Hello,

Yes. I recommend writing a processing script that can run as an extension in the background. That processing script can contain a function to retrieve the data from a remote server and populate a local table, which you can then use to process your dashboard statistics.

Best,
Ben

[jayjay]

How do i call the refresh method , went through the API and could not find. I can pop up a alert() every 5 sec..but what i want to do is refresh another sheet

Jay