I want to find a duplicate on mobile number.
if phone_work = 9898989898 & phone_mobile =9898989898.
is there any sugarquery for finding a duplicate on any phone field.
Hi Bhavin Patel
What is the version of your SugarCRM instance?
You can create a custom validation for this purpose on versions 7.x.
Hello André Lopes
A version of Sugar is 6.x & 7.x both.
Not for validation, I want to find the duplicate records on mobile number from CRM.
if one number is phone_mobile field like 989898XX & same number is work_number in another record, so it's duplicate number for CRM.
How to I find using query.
Maybe we need some context about this required feature.
How would you like to do it (background/view/button etc)?
Would like to do it using VIEWS
Retrieving data ...