[New Bot] Time sheet submit reminder

Summary: Time sheet submit reminder

What problem/s will this bot address? I would like a bot to alert my users if they have forgotten to submit their time sheets for the previous week.

Is there any report that you are using today to address this problem? yes

Where is the report located? My Time Sheets

When should this bot be triggered? If 8 AM Monday mornings, then send a message.

Where do you want to send the message? Teams - Specific User/s

Details of the message to be sent if the bot is triggered:

   What happened? Your time sheet for last week is awaiting submission

   What should the recipient be asked to do? Please go to my time sheets in manage and review last weeks time and submit your time sheet.

   Why should the recipient do it? Submitting your time sheets is required for billing to go out properly. Please make sure you get this done ASAP.

Suggest a name for this bot: Time Sheet Submission

Description of this bot: Bot to alert team if users that forgot to submit their time sheets.

Priority: Medium

@Scott_Hall , this should be easy to get it done since the rule is ver clear, I will check with our data analyst team to see what’s their capacity, then give you an ETA. Thanks!

@Scott_Hall , we created a new widget that you can access here: Widgets (mspbots.ai)

The question here is how do you know that a user didn’t submit the timesheets? Is there an indicator in the timesheets that tell you the user didn’t submit the timesheet on time yet? If you can attach a connectwise screenshot, that will be great! Thanks!

Should be audit trail that indicates when its been submitted to approver

We already have a dataset, it there is a status showing the timesheets. Should be able to create a bot easily just based on the dataset.

The rule can be: if the timesheets passed the deadline, yet are still in open status, send the alert. Is that make sense?