Scenario: Be able to do a quick find wild card search using out of box CRM quick find box on whole number field.

Ideal Solution: You must be wondering that it is as simple as configuring a Add Quick Find column in quick find and it will be working.

Reality: Even when we configure Quick find view for whole number fields, it only enables full number matches, not partial matches. For eg, if I want to search on number of employees in out of box account entity, I can only do full matches like 1000, I will not be able to get a result on 100*

ZERO CODE DEVELOPMENT SOLUTION:

I think the scenario is already clear by now.

So, since the example is referring to Dynamics CRM 2015, let us have a practical example on Calculated Fields.

Wait a minute, how are Calculated fields going to be useful here?

Well, we will need to store a hidden calculated field for our whole number field , which will be used in Quick find search.

Step 1: Please create a hidden Calculated Field like this:

Step 2: Click Edit and configure like below:

Step 3:

Configure this field in Account Quick find view (Remember in Step 1 field is marked as searchable as well):

Step 4: Publish all customizations.

What about mapping historical data to the new field. Well, calculated fields do not need that.

So, the final test!

Hope it helps!