Phone number search in global search

Question

We are integrating Genesys CTI with salesforce but we are facing one issue while searching the phone number in global search. From Genesys end we are passing 7 digit phone number to search 10 digit phone number and that searchable but the problem is that if any phone number contains ISD code then that is not searchable. Please find below example to understand the issue

Eg. Without isd code 9876543210 >>> If i enter 6543210 in global search it is searchable

With isd code +919876543210 >>> If i enter 6543210 in global search it is not searchable

Is there any way to search phone number with ISD code in a global search?

Answer 1

One solution I can offer is

1. Create a formula field with the formula RIGHT(Phone, 7) (7 or however many digits from the end you will be searching by).
2. Install my app Unleash Your Formula, which allows you to copy and sync a formula field to a non-formula field.
3. Create a (preferably indexed) static (non-formula) field and map the formula field to this new static field using the app.
4. Add the static field to the search layout.