I have created a solution for my employees to submit vacation requests. When they submit new requests, it will send me an email and I can then approve or deny the vacation request from within the same solution.
I thought it would be a nice feature to email all employees each week and let them know who will be on vacation the following week.
I need an application that will run a process every day at a certain time to check for approved vacation requests and send the emails to the employees.
My Vacation Request solution is running on Filemaker Server so I was thinking I could install a copy of Filemaker on the server and have it running a solution that would open the Vacation Requests solution and check for vacations the next week. Is this the right approach?