0

I have a following validation rule for "need to allow to create opportunities and be able to update opportunities as long as the deal stage is not funded. and do not allow them to change the stage to funded. "

Everything working fine except "they should not be able to edit an opportunity if it's stage is Funded"

AND( !ISNEW(), ISPICKVAL( StageName , "Funded"), $Profile.Name = "System Admin" )

1

One solution (tip of the hat to @sfdcfox) is to change the Opportunity.recordType upon stage=funded to 'FundedOpportunity'. Then create a new page layout where all the fields are read only and assign that page layout to Opportunities of recordtype ='FundedOpportunity'

Otherwise, you can brute force this by adding validation rules to every editable field checking for a change in value

Or...you can use an override of the Edit button with a VF page + page action controller that redirects to the View page if stage is funded, else to the edit page.

|improve this answer|||||
0

Formulas have to evaluate to true in order to fire. Therefore, the "profile name" check should be inverted:

AND(
    NOT(ISNEW()), 
    ISPICKVAL(StageName, "Funded"),
    $Profile.Name<>"System Admin"
)

As a side note, I'm pretty sure it's "System Administrator", not "System Admin", which would have made it ineffective for everybody.

|improve this answer|||||
0

The first part of OR will stop them from going to Funded as a non admin, and the 2nd part wl stop them from editing when it is.

AND(
OR(
ISPICKVAL(StageName, "Closed Won"),
AND(
ISCHANGED(StageName),
ISPICKVAL(StageName, "Funded"))),
$Profile.Name <> "System Administrator")
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.