I'm interested in some type of function that would alert certain users of new database entries. Can anyone suggest a simple method of doing this?
As an example, I'm creating an attendance management system. One function would be for administrators to track attendance of employees in their department & approve/deny their requests for time off. Obviously, the other function would allow the employees to track their attendance history
I'd like an employee's manager to receive an email notification when someone in their department makes a timeoff request, and likewise I'd like the employee to receive an email when their request is approved/denied.
Any feedback and suggestions would be much appreciated.
