Updating a calculation
I have made a "sign-in" database where firefighters sign in and sign out as they leave headquarters.
One of the admin pages I have shows the current members signed in, and how long they have been signed in for. I created a field called CurrentHours, and then used a calculation in the field to show the number of hours the member has been at headquarters:
Round ( (((Get(CurrentTimeStamp) - SignInTime))/3600) ; 1 )
However, when I visit the layout with the CurrentHours shown for the first time, it seems to calculate, but if I come back an hour later, the calculations don't update.
Is there a way to refresh the calculations (or auto-refresh every minute) so the CurrentHours field remains accurate?