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
Category: Alert Reminder Boost
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 […]
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 […]
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 […]