Hi Guys, I have this working!! I have a special request if you have a moment… is there a way to have multiple results populate the text box (uniqueID) in a way where it would add all rows that were added to the spreadsheet later? In other words, can I add to the scrip so that it looks for and adds all rows in the sheet? Thanks in Advance!
If I understand you correctly then the answer is yes but no.
What I mean is yes it can be done but you would not generate new hype elements without cloning.
But for the idea of what you may need to do:
Code that polls and gets the sheet json every #minutes.
Code that iterates over the json.
Code that adds the entries.
In my case I avoid cloning and generate a table into an existing Hype element. The table cells will hold the new data.
This is subjectively involved codewise to go into here but I will be putting up a special events button shortly that will be more dynamic ( not set days). If I get a chance I may break out some of the code and post here but no promises and also no promise will go into a lot of detail or help further at the mo. And remember this type of coding is subjective to data, display. So one thing including the fetch code will not work for all.
Mark you are fantastic. However, please hold because I am one of those who won’t have the full mental capacity to reach the All-Aboard on your Thought Train! In the meantime (hack that I am), I found in Google Design Studio that I can use their data engine to populate into graphics for embed into my hype doc…including tables and more. Since I’m using a G-Sheet to collect, this maybe easier for me at this time. However I am excited that I could actually understand a bit of the logic you did here and thank you for that! You guys who get this stuff, I am very grateful and impressed.
I have tried to replicate this. I tried the script and followed MarkHunte but it doesn't work for me.
I tried both local and on a server.
The idea we have is that a number of people can add the status of a zoom call. Full, Empty etc. on the google doc and this will update the text next to the corresponding room button. So people don't have to blindly try rooms in vain.
I have a question... Can I specify which cell to show?