function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KeerthigeeKeerthigee 

Issue related to update field in case object using workflows

Hi All,

Create a custom field on case named "Old status" and If Status field(picklist) value is changed then the old value of Status is evaluated into "old Status" Field? How can do this without using Triggers?

Using Workflow, I wrote this

In Rule criteria: ispickval(Status,"ischanged(status)").

and in workflow action: update field--Oldstatus ,and value=Proirvalue(status).

But, I didn't get previous value of status in oldstatus field.

Kindly support and suggest.

Thank you
Best Answer chosen by Keerthigee
Ramu_SFDCRamu_SFDC
Use the below formula in field update

text(PRIORVALUE(status))

All Answers

Ramu_SFDCRamu_SFDC
Chhange the rule criteria to just 'ISCHANGED(status) and it will work.
KeerthigeeKeerthigee
Ramu,

Thank you  for immediate response,which is helpful

I had tried already.If we use ISCHANGED(status) in rule criteria, then it will throw error as "Function ISCHANGED may not be used in this type of formula".

Awaiting for your response.
Ramu_SFDCRamu_SFDC
This is expected. Try changing the evaluation criteria to 'created, and every time it’s edited'.
KeerthigeeKeerthigee
Ramu,

Thank You for immediate response.

I had changed evaluation criteria to "Created,and every time it's edited".

But, I didn't get previous value of status to old status field.

Awaiting for your response.
Ramu_SFDCRamu_SFDC
Use the below formula in field update

text(PRIORVALUE(status))
This was selected as the best answer
KeerthigeeKeerthigee
Ramu,

Its working now.

Thank you for helping me with this solution.