We are using dashboard to track the response rate to a daily survey. This is dashboard is shared with the department heads who use it to track who has completed and who has not. What I have observed is that there is a lag between the completion and the dashboard updating. We resolve this by manually going to "Update all responses with current metadata" which seems to then update the dashboard to the most current status.

My question is, is there a script by which I can set the Update metadata to be executed regular intervals automatically, at say 30 mins so that the most updated response rate is shown in the dashboard. This is necessary as the survey is time bound and the dashboard is a critical way of communicating real time completion status to the department heads.

Or if there are any other solutions? Please help.