Skip to main content
Topics#SecurityPregunta de KasthuriRajan Murugesan
KasthuriRajan Murugesan (Salesforce) preguntó en #Security
17 ene 2021, 14:59

Hello all, I'm trying to do a validation rule but as you'll see i am struck with Error as Syntax error.

OR(

 

/* PHI utility changes until March 2015 */

 

AND(

 

OR(

 

TEXT(Service_UtilityPicklist__c) == "CONECT-DE - Delmarva Power",

 

TEXT(Service_UtilityPicklist__c) == "CONECT-MD - Delmarva Power",

 

TEXT(Service_UtilityPicklist__c) == "CONECT-NJ - Atlantic City Electric",

 

TEXT(Service_UtilityPicklist__c) == "PEPCO - Potomac Electric Power Company",

 

TEXT(Service_UtilityPicklist__c) == "PEPCO-DC - Potomac Electric Power Company"

 

),

 

LEN(Service_UtilityAccountNumber__c) > 22

 

),

 

/* END PHI utility changes until March 2015 */

 

AND(

 

TEXT(Service_UtilityPicklist__c) == "GSECO - Granite State Electric",

 

AND(LEN(UService_UtilityAccountNumber__c) != 10,LEN(Service_UtilityAccountNumber__c) != 16)

 

),

 

AND(

 

TEXT(Service_UtilityPicklist__c) != "PSNH - Public Service of New Hampshire",

 

TEXT(Service_UtilityPicklist__c) != "APS-PA - Allegheny Power",

 

TEXT(Service_UtilityPicklist__c) != "GSECO - Granite State Electric",

 

LEN(Service_UtilityAccountNumber__c) != VLOOKUP( $ObjectType.Account.Fields.Utility_UANLength__c,$ObjectType.Account.Fields.Name,TEXT(Service_UtilityPicklist__c))

 

)

 

)

 

/* AND(

 

TEXT(Service_UtilityPicklist__c) != "PSNH - Public Service of New Hampshire",

 

TEXT(Service_UtilityPicklist__c) != "APS-PA - Allegheny Power",

 

TEXT(Service_UtilityPicklist__c) != "GSECO - Granite State Electric",

 

LEN(Service_UtilityAccountNumber__c) != VLOOKUP( $ObjectType.Account.Fields.Utility_UANLength__c,

 

$ObjectType.Utility__c.Fields.Name,

 

TEXT(Service_UtilityPicklist__c))

 

)

 

*/
1 respuesta
  1. Parul Gupta (Acxiom)
    17 ene 2021, 16:00
    Hi

     

    You validation rule is something like below

     

    AND (

     

           OR(

     

          TEXT(Service_UtilityPicklist__c) == "CONECT-DE - Delmarva Power",

     

          TEXT(Service_UtilityPicklist__c) == "CONECT-MD - Delmarva Power",

     

          TEXT(Service_UtilityPicklist__c) == "CONECT-NJ - Atlantic City Electric",

     

           TEXT(Service_UtilityPicklist__c) == "PEPCO - Potomac Electric Power Company",

     

           TEXT(Service_UtilityPicklist__c) == "PEPCO-DC - Potomac Electric Power Company"

     

            ),

     

          LEN(Service_UtilityAccountNumber__c) > 22

     

    ) ,

     

    AND(

     

           TEXT(Service_UtilityPicklist__c) == "GSECO - Granite State Electric",

     

           AND(LEN(UService_UtilityAccountNumber__c) != 10,LEN(Service_UtilityAccountNumber__c) != 16)

     

    ),

     

    AND(

     

            TEXT(Service_UtilityPicklist__c) != "PSNH - Public Service of New Hampshire",

     

             TEXT(Service_UtilityPicklist__c) != "APS-PA - Allegheny Power",

     

             TEXT(Service_UtilityPicklist__c) != "GSECO - Granite State Electric",

     

             LEN(Service_UtilityAccountNumber__c) != VLOOKUP(       $ObjectType.Account.Fields.Utility_UANLength__c,$ObjectType.Account.Fields.Name,TEXT(Service_UtilityPicklist__c))

     

    ),

     

    )

     

    review your rule to add something

     

    OR(

     

    AND () ,

     

    AND(),

     

    AND()

     

    ) 

     

    Thanks

     

     
Escribir una respuesta...
0/9000