I want to send weekly mail to those employee who are not filling timesheet in days of week.
i can send mail to those who are not filling on current date
Hi Priya,
Create a Timer for this. Schedule it weekly. Inside the Timer, query the necessary Entities to determine which employees did not fill in their timesheets. Then either loop over the result and send the same e-mail to every employee in the list, or create a comma-seperated list and send the e-mail once (preferably use the comma-seperated list as BCC, you don't want employees knowing who also didn't fill in their sheet!).
Thankyou.
can you explain please step by step?. how to send mail to those employees who dnt fill timesheet on particular day at the end of week. Like someone who didnt fil timesheet on tuesday and friday.. a reminder mail with date of those days send via timer on saturday
What does your data model look like? How are the days stored?
Ho do you, functionally, determine whether an employee has filled in everything? Because the data model is missing information like working hours per day, and though there's a "OnLeave", someone could have less than one day absense. So overall, this makes it difficult.
That said, to get an overview, per employee, of the hours per day that are filled in, you need an Aggregate that groups by TimeSheetDate (assuming that's the date of a certain day) and sum the EffortHours, assuming you query per employee. The result can then be checked for completeness.
You can use a timer which run every week and inside logic if timer you can get date of week start and week end then get records which are empty for specific employee between these two dates.
You can use some Forge components for that like this one
Or you can calculate start of the week for example AddDays(CurrDate(),-6) if you will run timer into last day of the week
can you explain please step by step? . how to send mail to those employees who dnt fill timesheet on particular day at the end of week. Like someone who didnt fil timesheet on tuesday and friday.. a reminder mail with date of those days send via timer on saturday
Thankyou for reply
Please share structure of your database entities or database diagram or sample OML including your tables