how to refresh automatically a shiny page

[Chiara]

Hi everybody,

I hope somebody can help me. I have a shiny app which shows a table calculated with reactive functions from a sql server database. I'm done the table, and I put it in sidebarPanel.

Now, since the data in the sql server database vary continuously i'd like to automatically refresh the table every 5 minutes. Is it possible?

I tried also to put in a button for refresh the table, but it doesn't work, maybe because no input vary?

In summary, i'd like that the table in my page would be automatically recalculated every 5 minutes and also when the button is pressed.

Is there a way to do this? Every suggestion will be appreciated!
Thanks a lot,

Chiara

[Jonah]

Check out the invalidateLater and reactiveTimer functions. I haven't used them, but I think they could help you make this work. 

[Joe Cheng]

Put in an actionButton("refresh", "Refresh") in your UI, then as the first lines of your renderTable (or renderDataTable?) expression, put:

    input$refresh

    invalidateLater(1000 * 60 * 5, session)

--
You received this message because you are subscribed to the Google Groups "Shiny - Web Framework for R" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shiny-discus...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/shiny-discuss/d193bfb0-098b-4d4b-a6cc-56ae9411bf10%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Chiara]

Thank you very much guys, I appreciated a lot your help and I solved my issue.

[Pierrick KINIF]

Hi Chiara,

How did you solve your issue? I have the same.

Kind regards,