Scenario
There is a duplication of the customer’s Address results on their Customer-saved search. This happens if the Address fields, together with a Custom field, were both exposed on the saved search results.
Solution
There are two options to achieve a single-row result for addresses:
1. Use Joined fields on the Results tab of the search. Please refer to the sample fields below:
– Name
– Address: Internal ID
– Address: Address
– Address : (any Custom field)
2. User may also use the Standard non-joined fields, but has to add a Formula on the search criteria to eliminate the duplicate address records on the results:
On the Results tab > Add these fields:
– Name
– City
– State/Province Display Name
– Zip Code
– Address: Is Primary (Custom)
On the Criteria tab > Add these fields:
* Formula (Numeric)
* Formula = Case When {address} = {address.address} Then 1 else 0 End
* Value = Equal to 1