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. 
THANK YOU!
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!!! 
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. 
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.
2 Likes
I assume you were referring to:
1 Like