+ Start a Discussion
ANITHA BEEMUANITHA BEEMU 

Hi can anyone help on validation Rule:i have a field sales order number which is text,i want that field to be numeric and when an RMA_outcome value is picked as credit only,sales order number cannot be Null

Hi can anyone help on validation Rule:i have a field sales order number which is text,i want that field to be numeric  and when an RMA_outcome value is picked as credit only,sales order number cannot be Null:

i tired following,its not working..any help pls:
AND(OR(ISBLANK(Sales_Order_Number__c),
NOT(REGEX( Sales_Order_Number__c,"^[a-z A-Z]*$")))
&&

ISPICKVAL(  RMA_Outcome__c , "Credit Only") &&
ISBLANK( Sales_Order_Number__c )
)
Zachary SingerZachary Singer
Hi Anitha,
Try this:
NOT(REGEX(Sales_Order_Number__c, "[0-9]+"))
&&
(NOT(ISBLANK(Sales_Order_Number__c)) ||
ISPICKVAL(RMA_Outcome__c, "Credit Only"))