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
indoberto lerma 10indoberto lerma 10 

Once case statua has value of in progress i need to limit the options moving forward.

HI i have a requirement to do the following

Once Case Owner is changed from queue to user, Case Status should automatically change to In Progress
• Once status is In Progress, user can only update this field to either Closed, Duplicate, or Escalated

Any idea how to acomplished this ?
AnkaiahAnkaiah (Salesforce Developers) 
Hi Indoberto,

1st scenario, you can achieve by using workflow/flow/trigger.
workflow rule:
criteria:
ISCHANGED(Owner) AND ownerId != 'queueId'
field update:
status= inprogerss
2nd scenario, write a validation rule. 
AND(ISCHANGED(Status), Text(Status) !='Inprogress' ,OR(Text(Status) ='Closed',Text(Status) ='Duplicate',Escalated))

If this helps, Please mark it as best answer.

Please let me know if any help required.

Thanks!!
 
CharuDuttCharuDutt
Hii Lerma
Try Below Validation 
AND(ISCHANGED( Status ),
ISPICKVAL(PRIORVALUE( Status ),"Inprogress")
    OR(
       NOT(ISPICKVAL(Status ,"Closed")),
       NOT(ISPICKVAL(Status ,"Duplicate")),
       NOT(ISPICKVAL(Status ,"Escalated"))
     )
)
Please Mark It As Best Answer If it Helps
Thank You!