I wonder if you can help me here.
I have a field on a Sharepoint list called 'Developer'. When the name in this field changes I want to store this into a field called 'Previous Developer'.
Ideally, I'd like this to be set using a workflow.
I've tried a variety of things on a workflow for instance storing the Developer field as a variable. However, it always sets the Previous Developer at the same time as the Developer value. I want the Previous Developer to be a historic value to only be populated when the Developer value changes.
eg:
if current item:Developer not equals current item:Previous Developer
set Previous Developer to Developer
The workflow is set to run on created & changed.
What's the best way to achieve this?
I've been staring at this for far too long, so I think I'm missing something obvious!