I have a new challenge. In my Quality Results Database, we are required to enter data at least once an hour. The sample time is entered into a field "Sample Time". I would like Filemaker to remind the user, when the 1 hour limit has been breached.
Example: Sample comes in at 1:00pm - User enters "Sample Time" - Timer starts
Sample comes in at 1:45pm - User enters "Sample Time" - Timer resets
No sample at 2:45pm - Alarm notifies user