I'm trying to set up a reminder for users to review their documents annually. Using SharePoint 2013.
The basic idea is that if a document is uploaded on the 18th of January, then every year on the 18th of January the user who created the document is sent a reminder to review the document.
I've added the additional columns:
- Last Reviewed which is set to today's date on creation and
- Reminder Date which calculates Last Reviewed plus 1 year
Then on creation of the item we start a workflow
Pause until 'Current Item:Reminder Date'
then Email 'Current Item:Createdby'
then Update item in 'Current Item'
The update item sets Last Reviewed to the current date, this will then recalculate the Reminder Date to the current date plus 1 year.
This works fine, however I need the workflow to start again after the reminder has been sent - so that it will wait until the next reminder date and re-send.
While I can set the workflow to restart after the item has been edited, there is a chance that the user will review the document but not need to make any changes so the item won't be edited and the workflow won't be restarted.
I'd appreciate any light that can be shed on this one.
Thanks