Pull data from a Google Spreadsheet to Hype

You're just missing jQuery:

<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

Add that to the 'head' of the document.

google link test.zip (12.3 KB)

O.M.G. :smiley:


It works. But...

If I make a change how do I get it to update automatically on the site?

And if I want a second value on row 03 room "PROD 01 ROOM 02" how do I do that in the java? Can I specify a specific cell?

There is a limit to how many posts I can add!!! :frowning:
So I have added to this one.

I have kind of solved my problems.
I use a mouseover (on the room button) to trigger the javascript so it updated just before you click to enter.
As for the google sheet it's just a matter of lots of columns. :slight_smile:
But a script to trigger the script every 5 seconds would be good, but I have not found out how yet. As you noticed I'm not a coder...

Stay tuned. I might have something yummy in the pipeline for this topic.


I assume you were referring to:

1 Like