SharePoint 2013 email notifications for monthly overdue items

%3CLINGO-SUB%20id%3D%22lingo-sub-360198%22%20slang%3D%22en-US%22%3ESharePoint%202013%20email%20notifications%20for%20monthly%20overdue%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360198%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20new%20%2F%20novice%20SharePoint%202013%20user%2C%20and%20have%20been%20asked%20to%20create%20an%20environment%20for%205%20different%20users%20to%20enter%20monthly%20updates%20with%20data%20for%20multiple%20records%20(1%20user%20is%20required%20to%20submit%20monthly%20updates%20for%203%20items%2C%20another%20for%209%20items%2C%20another%20for%205%20items%2C%20etc.%20-%20but%20each%20user's%20required%20updates%20are%20the%20same%20each%20month).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20SharePoint%20list%20to%20contain%20the%20submissions%2C%20and%20a%20form%20to%20facilitate%20data%20entry.%26nbsp%3B%20What%20I%20have%20been%20asked%20to%20do%20now%20is%20to%20provide%20past%20due%20reminders%20to%20prompt%20users%20to%20enter%20and%20submit%20data%20if%20they've%20missed%20the%20due%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20questions%20are%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20how%20do%20I%20create%20past%20due%20reminders%20within%20SharePoint%202013%3F%26nbsp%3B%20Since%20the%20data%20is%20supposed%20to%20reflect%20the%20prior%20month-end%2C%20the%20users%20are%20expected%20to%20enter%20data%20by%20the%2010th%20of%20the%20following%20month%20(i.e.%20March%2010%20would%20be%20the%20due%20date%20for%20February%20month-end%2C%20April%2010th%20the%20due%20date%20for%20March%20month-end%2C%20and%20so%20on%20each%20month).%26nbsp%3B%20Can%20such%20reminders%20be%20generated%20directly%20from%20the%20list%20that%20holds%20the%20data%20or%20do%20I%20need%20to%20set%20up%20tasks%20and%2For%20workflows%3F%26nbsp%3B%20If%20yes%2C%20do%20I%20need%20additional%20columns%20in%20my%20list%3F%26nbsp%3B%20The%20only%20date%20column%20I%20currently%20have%20in%20my%20list%20is%20an%20%22as%20of%20date%22%2C%20which%20the%20user%20is%20requested%20to%20set%20to%20prior%20month-end%20when%20entering%20data%2C%20and%20no%20default%20value%2C%20since%20the%20list%20is%20intended%20to%20be%20updated%20monthly.%26nbsp%3B%20Can%20the%20routine%20for%20sending%20monthly%20past%20due%20emails%20be%20dynamic%20like%20a%20recurring%20Outlook%20appointment%20(i.e.%20in%20Outlook%2C%20you%20can%20have%20a%20recurring%20event%20the%203rd%20Tuesday%20of%20each%20month%2C%20or%20the%2010th%20of%20each%20month%20-%20can%20SharePoint%20do%20something%20similar%20rather%20than%20having%20to%20specify%2C%20and%20then%20update%2C%20every%20month%20-%20April%2010%2C%20May%2010%2C%20June%2010)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20can%20the%20reminders%20be%20tailored%20to%20trigger%20if%20any%20data%20from%20a%20particular%20user%20is%20missing%3F%26nbsp%3B%20For%20example%2C%20if%20user%20X%20is%20responsible%20to%20submit%20data%20for%205%20items%20every%20month%2C%20if%20they%20only%20submit%204%20out%20of%20the%205%20in%20one%20month%2C%20can%20the%20past%20due%20reminder%20e-mail%20be%20triggered%20that%20one%20submission%20is%20still%20missing%20for%20the%20month%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEmail%20Notifications%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epast%20due%20notifications%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%202013%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

 

I am a new / novice SharePoint 2013 user, and have been asked to create an environment for 5 different users to enter monthly updates with data for multiple records (1 user is required to submit monthly updates for 3 items, another for 9 items, another for 5 items, etc. - but each user's required updates are the same each month).

 

I've created a SharePoint list to contain the submissions, and a form to facilitate data entry.  What I have been asked to do now is to provide past due reminders to prompt users to enter and submit data if they've missed the due date.

 

My questions are:

 

1) how do I create past due reminders within SharePoint 2013?  Since the data is supposed to reflect the prior month-end, the users are expected to enter data by the 10th of the following month (i.e. March 10 would be the due date for February month-end, April 10th the due date for March month-end, and so on each month).  Can such reminders be generated directly from the list that holds the data or do I need to set up tasks and/or workflows?  If yes, do I need additional columns in my list?  The only date column I currently have in my list is an "as of date", which the user is requested to set to prior month-end when entering data, and no default value, since the list is intended to be updated monthly.  Can the routine for sending monthly past due emails be dynamic like a recurring Outlook appointment (i.e. in Outlook, you can have a recurring event the 3rd Tuesday of each month, or the 10th of each month - can SharePoint do something similar rather than having to specify, and then update, every month - April 10, May 10, June 10)?

 

2) can the reminders be tailored to trigger if any data from a particular user is missing?  For example, if user X is responsible to submit data for 5 items every month, if they only submit 4 out of the 5 in one month, can the past due reminder e-mail be triggered that one submission is still missing for the month?

 

Thanks for your help.

0 Replies