Spreadsheet refresh time.

  • 1
  • Question
  • Updated 3 years ago
  • Answered
Hi,

Is there any information about the possibility of changing the refresh time for the spreadsheet to less than 5 minutes in the future?

Thank you!
Photo of TDI CANARIAS

TDI CANARIAS

  • 192 Points 100 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
TDI,

We have an open issue with google here, about a bug that causes undesirable re-rendering of data when a refresh rate is set to less than 5 minutes.


When google addresses our bug, we will be able to update our widget accordingly.
Photo of TDI CANARIAS

TDI CANARIAS

  • 192 Points 100 badge 2x thumb
Thank you very much!!

We hope to hear good news soon.
Photo of Shragi Leitner

Shragi Leitner

  • 70 Points
Hi.

Any updates on this? I've created a nifty combination of Twilio, Google Apps and Risevision that I would like to use for a fundraising drive at a charity Gala however I need the updates to come onto screen almost instantly otherwise it will not work.

See here for preview of screen, you can test it by texting your pledge in the format shown to the number on the screen (UK) but you will need to refresh the page manually to see your text scroll up from the bottom. (Also the chart takes a few minutes to refresh, this is embedded via HTML). Any advise would be appreciated.

Thanks
SL
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Shagri, I shot you an email that may solve your issue. Let me know if that helps!
Photo of Shragi Leitner

Shragi Leitner

  • 70 Points
Can anyone at all recommend a way to overcome this issue to get the Google Sheet data on screen live (seconds not minutes). Any developers here that can perhaps write some custom code for us, the event is just weeks away. Please get in touch. Thanks. SL