Auto-Refresh Custom URL

  • 1
  • Question
  • Updated 3 years ago
I have a basic Custom URL that is simply displaying a shared Google Sheet (which is set to update every 5 minutes), but the Custom URL doesn't appear to be auto-refreshing.
Photo of Kyle

Kyle

  • 708 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Ray Durkin

Ray Durkin

  • 3,480 Points 3k badge 2x thumb
Hi - is there any reason you don't want to use the Google spreadsheet widget for this?  Unless there is some good reason, you would have better results that way.  The URL doesn't have an update setting - the Google spreadsheet widget does - you can set it up to update at almost any interval you want.
Photo of Ray Durkin

Ray Durkin

  • 3,480 Points 3k badge 2x thumb
Kyle,

No problem.  When you use the Google spreadsheet widget, you have to do 2 things to your spreadsheet.
1 - make sure it is public.  Click on the Share button in the upper right of the spreadsheet and make sure the sharing is set to 'anyone with the link can view'
2 - publish the spreadsheet.  Under File, select Publish to Web.  This gives you a pop up - click on the Publish button.
Give it a minute to propagate and you should be set.
Photo of Kyle

Kyle

  • 708 Points 500 badge 2x thumb
Excellent! One last question, is there any way to have the widget show the spreadsheet exactly how it looks on Google Sheets?
Photo of Ray Durkin

Ray Durkin

  • 3,480 Points 3k badge 2x thumb
well that would have to be done in your design - the configuration of the widget with the fonts - to make it looks as much like it as you can.  The formatting isn't carried over from the spreadsheet.
Photo of Kyle

Kyle

  • 708 Points 500 badge 2x thumb
Hm, now the widget doesn't appear to be showing anything at all. I've already confirmed the Google Sheet has been published to the web, and also have it set as public.
Photo of Ray Durkin

Ray Durkin

  • 3,480 Points 3k badge 2x thumb
Hi Kyle - I just asked you in another thread but I'll post here too - can you send an email to support@risevision.com with a link to your presentation?