Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
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..
1 answer
  1. Feb 4, 2020, 3:54 PM

    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

0/9000