Tuesday, July 27, 2010

Creating reminder workflow in SharePoint designer

Hi All,

One common requirement in workflow is reminder workflow. Reminder can be anything. It can be a birthday, anniversary or it can be an important meeting.

You might want to send a reminder email to attendees, or want to send a reminder email to team members about the birthdays or anniversaries.

Well let us design such a workflow which sends a reminder email to particular people about upcoming birthday before 14 days.

First open the site and create one calendar list. Call it a birthday calendar.

Create one calculated column of type date and time and select format as date and time. Name that column “reminder”.

Just mae sure that your start time and end time should not end with 12:00: AM, otherwise workflow will trigger, however mail will not be sent. My advice, keep Start time and end time with the time ending with 12:05 AM, should be fine or any other time than 12:00 AM.

Now open SharePoint Designer and we will create a workflow from here for the birthday calendar list.

Create a new workflow, attach it with the birthday calendar list and select automatically start the workflow, when the new item is created.

We need to divide this workflow into two steps. First step will check the date and time and pause the workflow for the time and second step will send an email to a person.

Step 1 condition will be

And step2 will be

Change the email address to a list of people whom you want to send an email. While sending an email, you can use the fields of the item and decorate the mail body according to your need.

To test this, click on create new item and enter start date 14 days after today’s date and see you should get an email in a moment.

There you go; you have set up the reminder workflow. However this is not a recursive workflow, that every year you get an email. This is a onetime workflow and needs to be recreated every year. We are working on making this recursive, so that it actually works as a service. Although the same can be achieved through SP timer definition for sure.


Anonymous said...

Sharepoint workflows using WSeWSS is not covered anywhere, can you guys cover that topic too

SharePoint Kings said...

will try

Ann Marie Sexton said...

Hi, thanks for the post, should the second step be 'if reminder equals today' instead of 'not equals' ??

Ann Marie Sexton said...

Hi, thanks for the post, should the second step be 'if reminder equals today' instead of 'not equals' ??

SharePoint Kings said...


SharePoint Kings said...

Ann, it should be "not equals" as show in the post.
give it a try. and let us know.

ankit khandekar said...

Hi thanks for the post, I'll try this but can you help me for the recursive events so that there is not need to add items every year?


SharePoint Kings said...

Hi Ankit,
this is one time workflow as mentioned at bottom of the article.

you can create SharePoint timer job for the same

check below article

Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to sharepointkings@gmail.com with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to sharepointkings@gmail.com