Skip to main content
Formatting formula to make it easier to read
Source Link
Derek F
  • 64.1k
  • 15
  • 55
  • 104

I need help with my Validation Rule. In my scenario, I have one Custom Object and in the Custom Object, I have one "Record Owner" Field which is lookup through the User Object. I want only that user edit that record which is assigned to him and that record "Read Only" for others. Also, I have Some Profiles, Those Profiles have access to all the records which is assigned or not. Here's my Validation Rule:-

 IF(
    OR(
        CONTAINS( $User.ProfileId , 'ID'),
        CONTAINS( $User.ProfileId , 'ID'), 
        CONTAINS( $User.ProfileId , 'ID'),
        CONTAINS(  Record_Owner__r.Alias ,  $User.Alias ) 
 )   ), 
    false, 
    true 
)

From this Validation Rule, I got the error when the other Profile User trying to update that Record which has access for all the Records.

Thank you in advance

I need help with my Validation Rule. In my scenario, I have one Custom Object and in the Custom Object, I have one "Record Owner" Field which is lookup through the User Object. I want only that user edit that record which is assigned to him and that record "Read Only" for others. Also, I have Some Profiles, Those Profiles have access to all the records which is assigned or not. Here's my Validation Rule:-

 IF(  OR( CONTAINS( $User.ProfileId , 'ID'),
      CONTAINS( $User.ProfileId , 'ID'), 
       CONTAINS( $User.ProfileId , 'ID'),
    CONTAINS(  Record_Owner__r.Alias ,  $User.Alias ) ) , false, true)

From this Validation Rule, I got the error when the other Profile User trying to update that Record which has access for all the Records.

Thank you in advance

I need help with my Validation Rule. In my scenario, I have one Custom Object and in the Custom Object, I have one "Record Owner" Field which is lookup through the User Object. I want only that user edit that record which is assigned to him and that record "Read Only" for others. Also, I have Some Profiles, Those Profiles have access to all the records which is assigned or not. Here's my Validation Rule:-

IF(
    OR(
        CONTAINS( $User.ProfileId , 'ID'),
        CONTAINS( $User.ProfileId , 'ID'), 
        CONTAINS( $User.ProfileId , 'ID'),
        CONTAINS(  Record_Owner__r.Alias ,  $User.Alias ) 
    ), 
    false, 
    true 
)

From this Validation Rule, I got the error when the other Profile User trying to update that Record which has access for all the Records.

Thank you in advance

Source Link

Validation rule for edit the case for specific Profile

I need help with my Validation Rule. In my scenario, I have one Custom Object and in the Custom Object, I have one "Record Owner" Field which is lookup through the User Object. I want only that user edit that record which is assigned to him and that record "Read Only" for others. Also, I have Some Profiles, Those Profiles have access to all the records which is assigned or not. Here's my Validation Rule:-

 IF(  OR( CONTAINS( $User.ProfileId , 'ID'),
      CONTAINS( $User.ProfileId , 'ID'), 
       CONTAINS( $User.ProfileId , 'ID'),
    CONTAINS(  Record_Owner__r.Alias ,  $User.Alias ) ) , false, true)

From this Validation Rule, I got the error when the other Profile User trying to update that Record which has access for all the Records.

Thank you in advance