function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SV MSV M 

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