[SalesForce] Account Validation Rule That Exempts Specific Profile IDs

I'm hoping to create a validation rule so that Once a Ship To ID (custom field on account) exists that starts with "6" or "7" users cannot change the Account Name with the exception of if you are a users with a system admin or a datamigration profile (profile IDs listed below).

I have created this but it is not working–

AND (
    LEFT (Ship_To_ID__c, 1) = "6" || LEFT (Ship_To_ID__c, 1) ="7",
    ISCHANGED ( Name ), 
    $Profile.Id <> "00eC00000012E4i"|| $Profile.Id <> "00e800000017STg"
 )

Can someone help me?

Best Answer

You're using an OR to check the profile, which means that if it is one, it won't be the other (it will always be true). What you meant to do was to use AND, meaning it must not be one AND not be the other. You can also make the first part more efficient by using CONTAINS.

AND(
    CONTAINS("67", LEFT(Ship_To_ID__c,1),
    ISCHANGED(Name),
    AND($Profile.Id <> "00eC00000012E4i",$Profile.Id <> "00e800000017STg")
)

Related Solutions

[SalesForce] Validation Rule with multiple profiles

Your rule is written to only throw an error when the $Profile.Name concurrently matches two distinct values. This case is impossible. Use OR instead.

AND(
    NOT(OR(
        ISPICKVAL(...),
        ISPICKVAL(...)
    )),
    OR(
        $Profile.Name = "Direct Sale",
        $Profile.Name = "New Contract"
    )
)

[SalesForce] Validation rule exempting user and profile

no user cannot edit other fields except one user integration_user@sf.com and 3 profile(system admin, system admin1, system admin2)

So, between user and profile comparison, you need to put AND instead of OR

AND(
    NOT(ISBLANK(Sequence_ID__c)),
    $User.Username <> 'integration_user@sf.com',
    NOT( $Profile.Name = "system admin1"),
    NOT( $Profile.Name = "system admin2"),
    NOT( $Profile.Name = "system admin3")
)

You can use like this way too

NOT(ISBLANK(Sequence_ID__c) 
&& ($User.Username <> 'integration_user@sf.com' 
    && ($Profile.Name <> "system admin1" 
    && $Profile.Name <> "system admin2"
    && $Profile.Name <> "system admin3"
    )
)

Best Answer

Related Solutions

[SalesForce] Validation Rule with multiple profiles

[SalesForce] Validation rule exempting user and profile

Related Topic