+ Start a Discussion
Vishal GuptaVishal Gupta 

Number field should start with 5

I have a number field.  I wana put a validation that this field should start with 5 else error is given.  How to accomplish it

harsha__charsha__c

This will make out you the solution

 

NOT( BEGINS( Field Name , '5'))

 

Vishal GuptaVishal Gupta

m getting the error

 

error-incorrect parameter type for BEGINS()...expected text

 

harsha__charsha__c

Try this once

 

NOT( BEGINS( TEXT(Field Name) , '5'))

 

sivaextsivaext

Hi

 

validation rule :

NOT( BEGINS( AccountNumber , Text(5)) )