Skip to main content
Luke Chuter ha preguntado en #Formulas

Hi all. I'm looking for some help with a validation rule so that only profile 'Sports Team' can edit fields if checkbox 'Athlete' is true, no other profiles.  So far I have :

 

AND ( $Profile.Name <> 'Sport Team', 

               Athlete__c = TRUE,

               !ISCHANGED (Athelete__c),

              OR  (ISCHANGED (email) , ISCHANGED (phone)

         )

 

I'm getting a syntax error : Extra ')' ... or another error 'Field Athlete__c does not exist'  - however, this is it's API name under fields and relationships.

 but not sure how to fix this. Thanks in advance for any help anyone can provide, still getting the hang of all of this!

2 respuestas
  1. 27 nov 2022, 12:57

    hi @Luke Chuter

    AND(

    $Profile.Name <> 'Sport Team',

    Athlete__c,

    NOT(ISCHANGED(Athelete__c)),

    OR(

    ISCHANGED(email),

    ISCHANGED(phone)

    )

    )

0/9000