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
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)