Saturday, February 23, 2019

To extract the last 4 digits of Phone number

To extract the last 4 digits of Phone number.

One can use the formula below in a saved search, workflow or even in setting the default value for a custom field. You can extract values in a similar way for any other field depending on the requirement. In this scenario, a custom field will source the last 4 digit of the Main Phone field.

WF : Deployed on a Contact Record

Action : Set Field Value : Custom_Phone, Formula : SUBSTR({phone},-4,4) [ "phone" is the internal id for  "Main Phone" field on the contact record], Trigger on: After Record Submit

Eg: Phone= 6478630888

Custom_Phone = 0888

You can extract values from front as well depending on the requirement.


No comments:

Post a Comment