2

I want to change the standard phone field of salesforce according to indian phone format i.e. it should be a 10 digit number without any space,brackets and hyphens. Ex-9898765456 and not (982) 008-8498 which comes by default. Can it be done without coding?? I don't want to use + sign. I want when a client saves a phone number it should be saved by default to a 10 digit number without any spaces

0

3 Answers 3

0

You can create a workflow with this formula evaluation :

BEGINS(Phone,'+')

And create a workflow action of type field update with formula like below:

RIGHT( Phone,10)

I hope this will help.

Ask me for more help.

5
  • No,it is not working.
    – d.dub
    Jan 22, 2016 at 6:07
  • I tried it by myself in my org and it worked. do you want any screencast of workflow creation for help Jan 22, 2016 at 6:08
  • yes please.Not working in my org.
    – d.dub
    Jan 22, 2016 at 6:15
  • get screencast from this link youtu.be/rE5zjZ1BR3A Jan 22, 2016 at 6:42
  • did it work for you? Jan 22, 2016 at 7:40
0

I faced the same challenge. Create a WF with rule criteria which evaluates whenever the Phone field is Not Null or as per the requirement. Update the phone field by field update WF action and use below formula in field update formula editor. (It is only for 10 digit number.) Let me know if this helps or not.

RIGHT(LEFT(LEFT(Phone, 5),4),3) & MID(Phone, 7, 3) & RIGHT(Phone, 4)

0
0

Create a workflow on any object like Contact .

Then create an immediate workflow field update action on Phone Field .

And put that formula in formula Editor.

RIGHT( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( Phone ,"-","") , " ", "") , ")","") ,"(",""),10)

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.