I want to be flagged when duplicates are entered into my app from these fields 1. Date of Duty, 2 Type of Duty, 3. ForceNum, Also when dates and times are overlapped from two entries or more. 1. Date of Duty, 2. Time Commence, 3. Time ceased. some assistants are required here.
Please give examples.
this app allows users to fill in extra duties, flexi, private duty etc into from and submit them for payment.
- I want to prevent the user from entering the same data twice, and if he performs two duties on a particular date to prevent the time from overlapping for the two duties.
The user can have flexi and extra duty on the same day but no two duties can overlap.
I submit a screenshot of the data.
Search this forum for “prevent duplicates”.