Browse by categories
-
All
-
Collaboration
-
Configuration & Data Management
-
CPQ and Billing
-
Customer Service & Support
-
Desktop Integration
-
Einstein Analytics
-
Email
-
Email Marketing
-
Journey Management
-
Mobile
-
Mobile Messaging
-
Packaging, Uploading & Installing Apps
-
Reports & Dashboards
-
Sales & Marketing
-
Security
-
Social Marketing
-
Trailhead Challenges
-
Additional Products
a validation rule, so that, only a specific profile can change a pick list value to "approved" on a custom object
I have been trying to make a VR work, so only a specific profile can change values in a picklist field to "approved"
open to ideas, i have tried that many now i'm starting to confuse myself, my last attempt is below, any help greatly appreciated :)
AND
(
ISCHANGED(Finance_Approval_Status__c),
NOT(ISPICKVAL( Finance_Approval_Status__c , "Approved")),
NOT(ISPICKVAL( Guarantee_Approval_Status__c , "Approved") ),
$Profile.Name = "HOT"
)
PS. Personally I would break this into 2 separate validation rules
1
2
All Answers
Try below Validation Formula ;
Thank you for the fast reply, how would the rule look if i was to split it out, to be 2 individual rules, so i can get the validation rule against each specific field :)
Thanks a lot
JR
Try Like this, Even you can add Muliple profile IN single Validation Rule,
PS. Personally I would break this into 2 separate validation rules
1
2
Once I seen who answered I knew that ticket was coming out of blocked haha :D
Perfect mate thanks, I’ll add it to my VR example list :P
I wanted to split it out as you suggested to get the individual errors above the fields, plus they can be approved at different times potentially, but unlikely,
Thanks again
JR