Google Sheets Widget has content that disappears after a few minutes

  • 2
  • Problem
  • Updated 3 years ago
  • Solved
Presentation: http://preview.risevision.com/Viewer.html?type=presentation&id=cfb8390b-e947-4f5b-9b40-49851b253...

Load it up, wait a few minutes, scroll down to the last row.  16 will turn into 1.

Please help me.  Thanks.
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb

Posted 4 years ago

  • 2
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip,

I am taking a look at this, I will update in a little bit.  
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip,

I saw what you described when I was using Preview on your presentation, so I took a copy of the presentation and changed it to use the default layout, rather than the custom layout you are using.  I am not seeing the number at the bottom change now using the default layout.  Can you take a closer look at your custom layout for the cause?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Yes, default layout works, but I need the functionality of the custom layout.  There is nothing in my custom layout that I can see.  Is there a way I can send you the custom layout link privately?
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip,

Just a couple of questions:

Did you create the custom layout yourself?

Did you try not specifying a range in the widget, but the entire worksheet?  I'm curious if that makes a difference since the issue appears on the last line of the range you set.
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
I created the custom layout myself using the templates on github as a guide.  I am specifying a range in the widget.  

Perhaps this is a bug on your end?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Okay, it seems that the 16 is not changing to a 1, but rather row 16 is being replaced by row 1.
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip,

I am not sure that it's a bug since it works with our default layout.  If you think it could be a bug in the layout could you please point me to the template you used?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Is there a way I can send you the custom layout privately?
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip,

Thanks.  I don't want your custom layout actually because I won't be able to troubleshoot that, but just a link to the particular template you used to make sure the template itself is okay.  Would you be able to just send a link to that?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Reporting the issue on the github repository: https://github.com/Rise-Vision/widget-google-spreadsheet/issues/116
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Hi Philip,

I talked to one of our developers and he explained that the example layout is tied with the actual example data as well.  Unfortunately we would not be able to have a developer debug this issue with the customization since the default layout and the widget work properly.
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb

Perhaps the Google Widget is still in Beta and not ready for production use?

Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip, do you mean the Google Spreadsheet widget?  It seems to be working properly when I use it with your spreadsheet link and the default layout.
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Can I get a link to the default layout .html file for google sheets widget?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
NVM I found it.  I have been doing some experiments.  

I have conformed my custom layout to the default layout as much as possible, and the bug is still happening.  

I changed the update time from 5 minutes to 10 minutes.  Guess what?  The last row got replaced by the first row after 10 minutes, so the bug is triggered upon update.

I contend that nothing I can do in my custom layout could have affected the way the presentation is updated.  Therefore, the bug must exist somewhere in the update code.  Having the last row being replaced by the first row is likely the result of an "index off by one" error.  My custom layout is likely not the culprit of such an error.

Please, I ask you again to alert the developer of the widget of this issue.  
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Philip, I did talk to a developer when you first brought up the issue, and he made the suggestions off the top of his head that I passed on, but other than that, unfortunately I can't ask our developer to debug this issue.  
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
If I signed up for the premium support would a developer be able to debug this issue?
Photo of Philip Tseng

Philip Tseng

  • 258 Points 250 badge 2x thumb
Still trying to get a definitive answer on whether a developer would be able to help rid of this horrible bug if I signed up for the premium support package.
Photo of Alex Kolenoff

Alex Kolenoff

  • 3,506 Points 3k badge 2x thumb
Hi Philip, I don't think this is something that technical support can help you with, and the Premium Support doesn't include developer support.
Photo of Jeff S.

Jeff S.

  • 264 Points 250 badge 2x thumb
Photo of Blake Freeman

Blake Freeman, Official Rep

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

There is a bug logged for this issue here. Our development team is currently looking at options for displaying Spreadsheets. If you have any other problems or ideas, I would suggest you post a new thread using the idea thread. The more responses and likes it gets, the more likely it is that it's something we will implement!
Photo of Jeff S.

Jeff S.

  • 264 Points 250 badge 2x thumb
This reply was created from a merged topic originally titled Google Sheet Widget Last Row Shows First Row Content.

Initially it showed up correctly.


After a few minutes the screen was refreshed to this. Notice the last row is showing first row content.


I am using a custom layout. Here is the layout html file.
========================================================
<!DOCTYPE html><html>
<head lang="en">
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1" />
  <title>Google Spreadsheet Widget - List Example</title>
  
  <style>
* {
   margin: 0;
   padding: 0; 
}
body {
   background: transparent;
   user-select: none;
   -moz-user-select: none;
   -webkit-user-select: none;
   -khtml-user-select: none; 
}

#scrollContainer {
   height: 100%;
   overflow: hidden;
}

.menus {
   margin-bottom: 10px;
padding-top: 5px;
padding-bottom: 5px;
}

.A {
   font-family: Trebuchet MS, Helvetica, sans-serif;
   color: #22324B;
   font-size: 18px;
background: #122570;
}
.unitname {
float: left;
margin-left: 100px;
width: 1300px;
height: 30px;    
border-radius: 20px;
border: 2px solid #FFFFFF;
background: #122570;
padding-left: 15px;
}

.unitnumber {
width: 200px;
height: 30px;
margin-left: 1480px;
border-radius: 20px;
border: 2px solid #FFFFFF;
background: #122570;
text-align: center;
}
  </style>
</head>
<body>
<div id="scrollContainer">
   <div id="menu" class="page">
<div class="repeat item menus">
   <div class="unitname">
<span class="A heading_font-style"></span>
</div>
   <div class="unitnumber">
<span class="B data_font-style"></span>
   </div>
</div>
   </div>
</div>

 <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

  <!-- Necessary source code for auto-scroll plugin -->
 <script src="//cdnjs.cloudflare.com/ajax/libs/gsap/1.11.7/TweenLite.min.js"></script>
 <script src="//cdnjs.cloudflare.com/ajax/libs/gsap/1.11.7/plugins/CSSPlugin.min.js"></script>
 <script src="//cdnjs.cloudflare.com/ajax/libs/gsap/1.11.7/utils/Draggable.min.js"></script>
 <script src="//cdnjs.cloudflare.com/ajax/libs/gsap/1.11.7/plugins/ScrollToPlugin.min.js"></script>

 <!-- Club GreenSock Members Only Plugin, subject to its own license: http://greensock.com/club/ -->
 <script src="//s3.amazonaws.com/rise-common/scripts/greensock/ThrowPropsPlugin.min.js"></script>

 <!-- Source code for google apis -->
 <script src="https://www.google.com/jsapi"></script>;

 <!-- Source code for gadgets api -->
 <script src="//rvashow2.appspot.com/gadgets/gadgets.min.js"></script>

 <!-- Source code for google spreadsheet widget -->
 <script src="//s3.amazonaws.com/widget-google-spreadsheet-test/0.1.0/dist/js/widget.min.js"></script>

</body>
</html>
Photo of Blake Freeman

Blake Freeman, Official Rep

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

Can you be specific and describe exactly the issue you are seeing? This may be a case of misconfiguration, or a possibly a different defect altogether. A link to a presentation preview displaying the issue would be great as well.

Thanks.
Photo of bcbowen

bcbowen

  • 70 Points
Same issue as described above. When I am using a custom template the last line in the list is replaced with the first line after the update. I modified the github example to meet my appearance requirements. I also tried the github example unmodified and the same thing happens. The preview link is: http://preview.risevision.com/Viewer.html?type=presentation&id=72915021-9c45-4757-ab97-104d9c4cf...
Photo of Kevin Reynolds

Kevin Reynolds

  • 310 Points 250 badge 2x thumb
It's not just the last line being replaced.  If your placeholder only has room for the expected rows, then you don't see that the bug is actually creating more rows.  In my example with 6 rows of data, on first load it correctly displays rows 1, 2, 3, 4, 5, 6.

When refreshed after 5 minutes, it then displays rows  1, 2, 3, 4, 5, 1, 1, 2, 3, 4, 5, 2, 1, 2, 3, 4, 5, 3, 1, 2, 3, 4, 5, 4, 1, 2, 3, 4, 5, 5, 1, 2, 3, 4, 5, 6.  The repeating pattern ends when the count reaches the last row.

This preview shows the repeating.
http://preview.risevision.com/?type=presentation&id=55ba54a4-8a9d-45b9-8198-23dfb4eea026



I am now testing a work around that looks like it will work for my use.  Hopefully it will be of use to others.

My data is in the range a2:e7.

I've added some filler text to f8 and f9.  The cells can't be empty, so just put in some text. 

I set the data range in the widget to be a2:f9

My layout still only renders the data from columns a:e so nothing from f gets on the display.  But the widget then includes an empty row on the display.  The empty row is enough to push the repeating rows off the bottom of my placeholder.  I'm not sure why it isn't including two empty rows, but one is enough for my needs.

This won't help, if the length of your list is dynamically changing.

This preview shows the work around in use.
http://preview.risevision.com/?type=presentation&id=72576274-7981-41ea-accd-bf8c43ce7fdb
Photo of Kevin Reynolds

Kevin Reynolds

  • 310 Points 250 badge 2x thumb
One place the work around doesn't work great is with scrolling text.  I set up one placeholder for a section of scrolling text pulled from a google sheet.

On initial load I see it scroll through to the empty row.  After the five minute refresh, it scrolls through to a second copy of the first row.  Then blinks as the first row comes to the top again.  Works, but not perfect.
Photo of Kevin Reynolds

Kevin Reynolds

  • 310 Points 250 badge 2x thumb
Follow up, my presentation has been locking up the player at about 20 minute intervals.  After about a minute the player relaunches.