Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
IF($User.Id = OwnerId , False, IF($User.Id = A__c , False, IF($Profile.Name = 'An Admin', False, IF($Profile.Name = 'System Administrator, False, True))
Hi, this validation rule says only if A__C which is a lookup to user and Owner of record they can only edit the record except system admin. I need to add one more profile let's say B who can also edit. how it can be amended here?
You don't need any of those IF statements.
AND(
$User.Id != OwnerId,
$User.Id != A__c,
$Profile.Name != 'Profile B',
$Profile.Name != 'An Admin',
$Profile.Name != 'System Administrator'
)
Hi not able to fully get you, still what I understood : if user is not owner Id, and not in look up field, and also not having, one of those profiles(including system admin), then throw an Validation Error
As per that, this should be your validation rule.
($User.Id <> OwnerId ) && ($User.Id <> A__c ) &&
( $Profile.Name <> 'System Administrator || $Profile.Name <> 'New Profile Name')
