Issue with google sheet with custom design template

  • 1
  • Problem
  • Updated 4 years ago
  • In Progress
I created a simple google sheet with some data based on the tutorial here https://help.risevision.com/user/content/google-spreadsheet-widget

I'm basically trying to duplicate this first and get it working comletely then customize the formatting. I created a html page that is an exact copy of the document in that tutorial. https://github.com/Rise-Vision/widget-google-spreadsheet/blob/master/examples/list.md 

Everything works great the first time I load it, but after 5 minutes when it refreshes, it doesn't update the data, and continues to fill forever. 

Google Sheet:

Initial Load:

After 5 minutes when it does the refresh to get new data:


The last line of the sheet disappears (Food 6) and it fills the whole table over and over again with the first 5 entries. This happens no matter how many or few entries I put in the table. 
Photo of Engineered Glass IT

Engineered Glass IT

  • 686 Points 500 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Good morning!

I'm going to try to replicate this in house, once my research is complete, I'll get back to you either with a solution, or confirmation of an issue and bug logged.
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Could you provide a link to the presentation preview with this spreadsheet and layout in question?

Thanks!
Photo of Engineered Glass IT

Engineered Glass IT

  • 686 Points 500 badge 2x thumb
Photo of Nathan Neuschwander

Nathan Neuschwander

  • 350 Points 250 badge 2x thumb
Could it be the <ul> tag on line 89. It should be below <h3 class="A">
Photo of Engineered Glass IT

Engineered Glass IT

  • 686 Points 500 badge 2x thumb
You mean it should be above <h3 class="A"> ?

(either way i'm testing it right now ;) ) 
(Edited)
Photo of Engineered Glass IT

Engineered Glass IT

  • 686 Points 500 badge 2x thumb
Same behavior with the ul tag above <h3 class="A">
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Engineered Glass IT,

Are you still having this issue? I've just begun testing on your presentation/layout/spreadsheet and everything seems to be working normally here.