We have a custom object with a phone field. The field type is "Phone". I would like this field to automatically be formatted to (xxx) xxx-xxxx, just like it does with the standard objects. However people are able to enter in whatever they want. These are coming in via manual entry, upload, or from our website, so I don't really want to create a validation rule. Is there a way to do this?
Thanks!
6 Antworten
Katie,
You can use Jim's suggestion from the following thread.
https://developer.salesforce.com/forums/?id=906F00000009FN3IAM
You will basically have to create a workflow rule with the criteria and field update formula mentioned by Jim. Once you have activated the rule, the phone number will be appropriately formatted to the correct format everytime a record is created or edited.I have provided the
solutionhere with a record - triggered flow along with the screenshots
Hope that would be helpful too
