AnsweredAssumed Answered

Updating a calculation

Question asked by AndrewClarkson on Nov 15, 2010
Latest reply on Nov 15, 2010 by LaRetta_1

Title

Updating a calculation

Post

Hi,

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?

Thanks!

Outcomes