+ Start a Discussion
Sai Vineeth MaddulaSai Vineeth Maddula 

Validate text filed

I want to input mobile number in Text field after saving the record the mobile number should display in (999) 999-9999 format..

I've tried creating a formula field of text and gave the below formula
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE( Phone__c ,
 '.', NULL),
 ' ', NULL), 
'-', NULL), 
')', NULL),
 '(', NULL)

But it doesn't worked for me.Can anyone help me doing this..
SRKSRK

i will suggent that you can write a validation rule on text field and using regex check the format of input and force user to enter phone number in required formate