function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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"))