Hello again, 

I have another question for my fire dept database.  

We have an EVENT REPORT layout and table that stores all the data from our fire calls.  Linked to our ATTENDANCE table via a "kp" are attendance records for each firefighter. 

The chief of the department wants a time delay on their ability to sign in.  Sign in was usually allowed as soon as the call was created and until the chief clicks the CLOSE REPORT button on the EVENT REPORT layout which changes a REPORTSTATUS field to "0".  Then the attendance add button doesn't work for some users anymore.  

My question is how to I add in some script elements that would also not allow the members to sing in to a fire call for the first 15 mins after the report was created.   I do have a field with the creation time already, i just get hung up with the double validation on the closed report status and then also the time delay.  

here is what I use now... 

Any ideas or guidance would be great.  

Thanks

Chris

 

Create a boolean calc field  that is set to true when the current time is 15 minutes greater than the creation time. You could make that boolean field 'enable sign in' and have it set to false when the chief stops signing in. Then you only have to consider the one field for allowing firefighters to login.

Thank you very much.  I added these elements and things are working great.  Thanks for the ideas!

Chris