HOWTO? Google spreadsheet custom layout

  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am trying to use a custom layout on my google spreadsheet widget, but I'm not able to get it to work. All I am seeing is a blank white page.

I used the example code on github [https://github.com/Rise-Vision/widget-google-spreadsheet/blob/master/examples/list.md]
Posted the code on a html page on my webserver, put the link to it in the google spreadsheet widget preferences, but nope, not working.

Anybody that can help me with a small HOWTO? What am I doing wrong?

Thank you in advance!
Photo of Jelle Scheyving

Jelle Scheyving

  • 254 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Jelle,

First thing I would look into is does everything work without the custom layout. If it does, at least you know it's the custom layout that is the issue.
Photo of Jelle Scheyving

Jelle Scheyving

  • 254 Points 250 badge 2x thumb
Robb,
Without the custom layout it displays just fine. Today I looked back at the preview and the custom layout did show. Could it be that there is some time of a delay before the custom layout is applied?
When I change the layout, the changes do not apply directly.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Jelle,

I'm not aware of any delay, but to be honest I haven't tested the time it takes for a custom layout to be applied after changes are made to it.

Do I understand you correctly that everything is now working as expected, there is just some delay in it showing on the Display?
Photo of Jelle Scheyving

Jelle Scheyving

  • 254 Points 250 badge 2x thumb
Robb,
indeed it is working as expected. With the known bug when using div instead of table layout. (where data duplicates after refresh). Going to use the table layout. 
Thank you for your fast response!
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Glad to hear it Jelle!
Photo of Jelle Scheyving

Jelle Scheyving

  • 254 Points 250 badge 2x thumb
Hi Robb,
I have one more question. When the data refreshes after 5 minutes, the css styling does not apply to the table. Is this a known bug?

Thank you.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Jelle,

One of our dev's informed me that we have a known issue regarding refreshes with custom layouts. We are currently working on a new version of the Spreadsheet Widget, and at this time it will not support custom layouts.

My recommendation would be to use the Google Sheets web component, which you can see all details about here, including a demo of how the whole thing works!

Let me know how you make out. Thanks!