Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Murali KrishnaMurali Krishna 

Regarding validation rule for testing numeric value for field

Hi everybody,

 

I am having field called Employee name in which I need to have only alphabets.

john23 is through throw an validation error. ISNUMERIC function is working for only if enter 123 in that field.is there anything I could add to" ISNUMBER( employee_name__c )" formula so that I can achieve my requirement.is there any other way to fulfill this requirement

Best Answer chosen by Admin (Salesforce Developers) 
Avidev9Avidev9

Try regex instead.

 

Something like

 

NOT(
REGEX(Employee_Name__c, "[A-Za-z]")
)

 

All Answers

Avidev9Avidev9

Try regex instead.

 

Something like

 

NOT(
REGEX(Employee_Name__c, "[A-Za-z]")
)

 

This was selected as the best answer
Murali KrishnaMurali Krishna

Thank You Adidev
Murali KrishnaMurali Krishna
Hi Adidev,

It is showing error for text like 'John' input,can u tell solution for that