The Question
Is there a way, either through a hack or an action I haven't noticed, to clear the value in a specific field of an item, using a workflow?
The Issue
All I want to do is clear the values in my Archived Date and Archived By fields (see The Setup,) but I can't find a Clear Field in Current Item
action, and I can't leave the Value
blank in a Set Field In Current Item
action.
For More Information:
The Setup
I am building my workflow in SP Designer
I have a document library, and I want to be able to Archive documents, rather than delete them. To this end I have added an extra value to the Status lookup I already have in place; Archived.
I have then set up a workflow that adds some data to the record to track who archived it, and when. I have the following fields:
- Archived Date [Date Content Type]
- Archived By [Person/Group Lookup Content Type]
- Archived Data Updated [Yes/No Content Type]
The Archived Data Updated field is used by the workflow to detect whether or not a document updated with the Status set to Archived has already had these values recorded; to stop it from overwriting.
The Requirement
So I want to enable users to "unarchive" a document, returning it to Live status. And when this happens I want to clear the Archived Data fields, and set the Archived Data Updated field back to No.
I have the logic laid out: