[SalesForce] Validation rule for picklist value

I am new to saleforce, I want to create a syntax for picklist field role_c is not 'PCG' value then rise message you are not allow to update add to client field.

ISPICKVAL(Share_With_User__r.WM_role_c, 'PCG')

This syntax for role = 'PCG',

How do you do not equals?

Best Answer

NOT(ISPICKVAL(Share_With_User__r.WM_role_c, 'PCG'))

worflow

On the right side you can see all the functions and you can see how they can be used. Double-click on them and they will be inserted into the rule criteria for you to modify them.

Check this link as well for more examples on how to build workflow rules. Also explanation and examples of all functions can be found here

Related Solutions

[SalesForce] How to compare a formula field with a picklist in a Validation Rule

I think this should do it for you:

TEXT(Picklist_Field__c) <> Formula_Field__c

[SalesForce] Validation Rule IF A Specific Picklist Value is Selected

If you want to return a validation error on a record that does not comply with your rules then you should wrap it inside an IF clause like this.

IF(
AND( 
$UserRole.Name == 'Career Advisor - Inbound', 
$Profile.Name == 'Acquire Sales Admin - Inbound',
AND(
ISPICKVAL(Lead_Sources_for_Career_Advisor__c, 'Career One'),
ISBLANK(Lead_Source_Referral__c)
)
), false, true)

This will give an error when this formula is not met.

Best Answer

Related Solutions

[SalesForce] How to compare a formula field with a picklist in a Validation Rule

[SalesForce] Validation Rule IF A Specific Picklist Value is Selected

Related Topic