How to set remind message to a user 7 days before his birthday every year?

I need to send remind message to a user 7 days before his birthday every year, how to set the conditions?​ Solution: Please set the conditions as following:​ (Day(AddDays([Today], 7)) == Day(GetDate([Start Time]))) && (Month(AddDays([Today], 7)) == Month(GetDate([Start Time]))) Applies for: SharePoint 2013, SharePoint 2010, SharePoint 2007

Read More

How to set up the values for column [Approval Status]

​When content approval feature is turned on in SharePoint list/library, there will be a default column [Approval Status] out there which contains three values: Pending, Rejected and Approved. How to set up the values for column [Approval Status] in Alert Reminder Boost condition?  Solution: ​Column [Approval Status] has corresponding values in below table: ​Status ​Internal Value ​Approved […]

Read More

How to terminate workflows which are "in progress"

​For Alert Reminider Boost 2.x, when an item is changed or created, the workflow will be "In Progress" forever, how to terminate those workflows? Solution: ​1. For the workflows which already sent out emails, please set "Exit Workflow Conditions" the same as "Conditions" in alert/reminder part. 2. For all of the workflows, Please use below […]

Read More

Database deadlocks caused by Alert Reminder workflows

​An application error event log can be found on the SharePoint WFEs related to database deadlocks many times per day. See the sample screenshot below: Solution: This issue is database deadlocks caused by Alert Reminder workflows, please refer to attached PDF article to solve it: Database deadlocks caused by Alert Reminder workflows Applies for: SharePoint […]

Read More