+ Start a Discussion
YashavantYashavant 

Facing problem in validation rule

Hi,

I applied one validation rule to custom object but facing some problem. That custom object contain two lookup fields LP_Field1 & LP_Field2.

Validation rule is as below:
Code:
Rule Name Agent_not_null Active Checked
Namespace Prefix airlines Error Location Agent
Error Condition Formula : ISNULL( VALUE( LP_Field1__c ) )
Error Message Agent Field cannot be null
Description
Created By Airlines psl, 1/16/2009 3:09 AM Modified By Airlines psl, 1/19/2009 8:26 PM

 When i didnt provide value for LP_Field1 then it showing the error message as 'Agent Field cannot be null', but when i provide the value then it showing error as
Validation Formula "Agent_not_null" Invalid (null)
Any pointer on this will be helpful.

Yash
 

 
Vijay RautVijay Raut
Yash,

Can you use following Error Condition Formula:

LEN( LP_Field1__c ) < 1

Cheers,
V.R.