I've built an app using the shinydashboard package that queries a database. The user selects the sql criteria to use (eg. age range, gender etc) and clicks a submit button. The returned table is then displayed along with some charts from the data. Sometimes when there is a connection error the app grays out and you have to reload the dashboard, select the filters again and re-submit.
To improve user experience, is there a way for the app/dashboard to automatically refresh on error so that it is usable and the query can be resubmitted by the user.