Skip to main content
Topics#Data ManagementQuestion de Roger Lao
Roger Lao (Y. Hata & Co., Ltd.) a posé une question dans #Data Management
24 janv. 2018, 01:52

validation rule to not allow date field to be populated until picklist field is a specific value

Tring to create a validation rule that will not allow a user to populate a date field (Buyer_ETA__c) unless one of 3 picklist field values (Customer_Speical_Order_Approval__c, Customer_Internal_New_Stocking_Item_Appr__c, and Increase_Decrease_Demand_Approval__c) is = to "Approved".  This is what I have, and I can change the status and save, but when I set the status on any one of those picklist fields to "Approved" and try and set a date, I get my defined error message that I set in the validation rule.  

 

OR( 

 

NOT(ISPICKVAL( Customer_Special_Order_Approval__c, "Approved")), 

 

NOT(ISPICKVAL( Customer_Internal_New_Stocking_Item_Appr__c, "Approved" )), 

 

NOT(ISPICKVAL( Increase_Decrease_Demand_Approval__c, "Approved" )) 

 

) 

 

&& 

 

NOT(ISBLANK(Buyer_ETA__c))

 

 
5 réponses
  1. Roger Lao (Y. Hata & Co., Ltd.)
    26 janv. 2018, 01:43
    AND( 

     

    NOT(ISPICKVAL(Internal_New_Stocking_Item_Approval__c,"Approved")), 

     

    NOT(ISPICKVAL(Internal_Special_Order_Approval__c,"Approved")), 

     

    NOT(ISPICKVAL(Increase_Decrease_Demand_Approval__c,"Approved")), 

     

    NOT(ISBLANK( Buyer_ETA__c )) 

     

    )
Rédiger une réponse...
0/9000