I have a SharePoint list with a column (Migration Update Notes) that contains multiple lines of text (with the ability to append changes/versioning). Is there a way to initiate a workflow when someone appends new changes? I am trying to create a workflow that will send an email to the following names in Column OCR PM, BSC, Pri DBA, Sec DBA and Tech Mgr; if someone appends changes/text to the Migration Updates Notes.
Create a temp field to store the previous state of the textbox.
Create a workflow that fires every time there's a change.
if the temp field is Not equal to current perform your changes, the last action in the if condition has to be temp = current
If you're using Sharepoint 2010, use the 'Wait for field to not equal value. Where value will equal a previous copy of your Migrate Update Notes in a different, new column.