I am looking for a Document Extension that can toggle between all currently visible sheets in a application.
The use case is to have an application that runs as a dashboard on a TV in a public area, without any user interaction possibilities. The expectation is that the next sheet in is shown every 10 seconds.
I have not been able to locate any example extensions that could provide this functionality. Does anyone know where I could find one, or perhaps provide some quick guidance on how to approach the assignment?
What would be the best approach?
1. Alter a variable every ten seconds that toggles the sheet show condition
2. Make a selection every ten seconds that leads to change in calculated show condition
3. Simulate a click on sheet tab or button that triggers the next sheet to show