I'm using SharePoint Online and I have a custom list with a date & time column. I want the system to send me an alert 1 month after the date specified in this column but I don't know how. Initially, I'd looked at alerts but they don't seem to have that sort of conditioning, I then looked at workflows but I'm a little lost. Can anyone assist me in creating this alert/workflow control?
Simply create a Calculated column (Lets call it Reminder) = 30 days + Your Date and Time column
In SharePoint Designer Workflow use List Workflow.
Action : Pause till Date > Here Use the Current Item: Reminder Date Filed.
Condition: If any value equal value: Current item field (Current Item: Reminder Date) is equal to Today
Action : Send an Email
Hope this helps.
You can make call from any page that you know is hit at least once every day to return all items with a date that equals Today minus 1 month and a flag is not set and if found, send an email and then set the flag so the email is only sent once. Make your list hidden and give everyone edit access.
Most users should only see a few milliseconds of delay and the unlucky person that actually gets a hit will only see about a 1/2 second delay. We have our site on a hosted service using old-style workflows (yuk!) and no compiled code is allowed by the provider, so I use our homepage to trigger scripts like a timer job and the users have never noticed a difference. Certainly not best practice, but it gets the job done...