Email Notification for Timesheet

user0719
Tera Contributor

Does anyone know how the following can be achieved?

 

1. Time Sheet Due --> Notification needs to be sent on Fridays to remind users to complete and submit the current timesheet by the end of the time sheet period.
2. Time Sheet Overdue --> Notification needs to be sent on Mondays to users who have not submitted a timesheet for the previous period; a notification is also need to be sent to the manager with a list of Time Sheets pending submission User.

7 REPLIES 7

Sandeep Rajput
Tera Patron
Tera Patron

@user0719 You can create scripted schedule jobs which will run on Friday and Mondays to send reminder notifications to the intended users. For more information please refer to https://developer.servicenow.com/dev.do#!/learn/courses/xanadu/app_store_learnv2_automatingapps_xana...

Mani A
Tera Guru

@user0719  write a scheduled job which runs weekly on friday + for monday

 

in script : check which timecards are not submitted , then send a notification by firing event from script using gs.eventQueue()

user0719
Tera Contributor

@Mani A @Sandeep Rajput 

Is there any way to do this without writing scripts if we are not familiar with coding?

@user0719 If you do not wish to write script to send email then you can simply create a flow which triggers on a schedule and send emails as follows.

 

Screenshot 2024-10-01 at 11.11.02 PM.png

Using these two simple steps you will be able to send reminders to your users without writing a single line of code.

 

Please mark my response helpful and accepted solution if it addresses your question.