Skip to main content
If there would be any phone number which would be inserting from outside or it is being saved in salesforce  then it should be formatted automatically in that field. Like the unformatted phone numbers would be 303.875.7163  or (303)875-7163 or 3038757163 or +13038757163 . please help me with this.,
3 件の回答
  1. 2018年7月18日 11:04
      Hi Prema,

     

      try this formula its working fine

     

      NOT( 

     

     OR( 

     

      REGEX(Phone,"^((\\+1)\\s?\\d{10})?$"), 

     

      REGEX(Phone,"^(\\d{3}\\.\\s?\\d{3}\\.\\d{4})?$"), 

     

      REGEX(Phone,"^(\\s?\\(\\d{3}\\)\\s?\\d{3}\\-\\d{4})?$") 

     

     ) 

     

      )

     

      

     

      

     

      if you found this answer helpful then please mark it as best answer so it can help others.   

     

      

     

      Thanks 

     

      Akshay