Plausibility Check

When a new activity is created or an existing one is updated, the system should check whether the status ("Scheduled", "Completed" or "Missed") is consistent with the date.

Activities in the future are set to "Scheduled", activities in the past are changed from "Scheduled" to "Missed" and corresponding messages are displayed.

1. Define the following trigger:
   
   
   
2. Enable the Plausibility Check option.
3. Define the following condition for the first line: Date = Today's Date
4. Define the following condition for the second line: Status = Scheduled AND Date <= Today's Date.
5. Save the trigger.
6. Switch to the Rights info area.
7. Click in the Triggers cell for the Activities info area.
8. Define the following database event:

   

9. Save the access rights and assign them (to a station).

Each time an activity is added or edited, the Status is checked against the current date. Activities in the future have their status set to "Scheduled". Activities in the past not set to "Completed" have their status set to "Missed".