I need some help creating a valadation rule. I have a custom number field Order_Quantity__c that I would like to create a rule for. Basically there are many instances that this field may be blank (when it is not filled out it is blank, does not have a 0 in it). However the rule I would like to add it that if this value is ever filled out and saved with a value in it, it can not be re-saved with as 0 or blank. So the field can be edited with a new value as long as it is greater then 0.
5 respuestas
Here you go:
AND(
NOT(ISBLANK(PRIORVALUE(Order_Quantity__c))),
PRIORVALUE(Order_Quantity__c) <> 0,
ISCHANGED(Order_Quantity__c),
OR(
Order_Quantity__c = 0,
ISBLANK(Order_Quantity__c)
)
)
