You need to sign in to do that
Don't have an account?
Colette Osborne
validation rule - if two critera are TRUE then record won't save
Hi, I have been doing fairly simple validation rules but am having a Friday problem!
Essentially I am trying to create a validation rule on a custom object:
If a scheme name is set to a specific text string AND a picklist value is a certain value THEN display the error message - you cant save the record - the scheme name should be something other than CAP VG PH12.
AND( if ( CS_Scheme__r.Name," CAP VG PH12 "), AND( ISPICKVAL(Status__c , "filled"),null )
I know the above is not right but really would value some pointers.
thanks
Essentially I am trying to create a validation rule on a custom object:
If a scheme name is set to a specific text string AND a picklist value is a certain value THEN display the error message - you cant save the record - the scheme name should be something other than CAP VG PH12.
AND( if ( CS_Scheme__r.Name," CAP VG PH12 "), AND( ISPICKVAL(Status__c , "filled"),null )
I know the above is not right but really would value some pointers.
thanks
AND(
CS_Scheme__r.Name = " CAP VG PH12 ",
ISPICKVAL(Status__c , "filled")
)
CS_Scheme__r.Name = "CAP VG PH12",
ISPICKVAL(Status__c, "Filled")
)
If both the conditiona are true then AND evaluates to true. Please chech for minor syntactical error.
Thanks,
Kaustav
AND(
CS_Scheme__r.Name = "CAP VG PH12",
ISPICKVAL(Status__c , "filled")
)
AND(
CS_Scheme__r.Name = TEXT("CAP VG PH12"),
ISPICKVAL(Status__c , "filled")
)