Skip to main content
Larson Wimar (3M) ha fatto una domanda in #Data Management
HI All

 

I creaed a validation rule below and I am not sure why it is not working. Can you please advice why the syntax below is not working.

 

I would like fields: Customer_Account__c and Name are not editble for all profiles , except 1 profile: ETL_LOAD__C can able to edit these fields when the Data_Source__c has values that list in the rule below.

 

Thanks so much for your help.

 

Larson

 

AND (

 

CASE(Data_Source__c,

 

"ORACLE", 1,

 

"DB ASSET", 1,

 

"MAINFRAM", 1,

 

0) = 1,

 

OR (

 

ISCHANGED(Customer_Account__c),

 

ISCHANGED(Name),

 

NOT(CASESAFEID($Profile.Id)= $Setup.SystemSettings__c.ETL_LOAD__c))

 

)
5 risposte
  1. 25 giu 2020, 05:00
    Sorry :) 

     

    ​​​​​​AND (

    CASE(Data_Source__c,

    "ORACLE", 1,

    "DB ASSET", 1,

    "MAINFRAM", 1,

    0) = 1,

    NOT(CASESAFEID($

    Profile.Id

    )= $Setup.SystemSettings__c.ETL_LOAD__c), 

    OR (

    ISCHANGED(Customer_Account__c),

    ISCHANGED(Name)

    )

     

    ​​​​​​) 
0/9000