The CreatorCon Call for Content is officially open! Get started here.

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.