Find Duplicates BEFORE You Save! Instead of waiting until after you enter a new record's information to know if it's a duplicate, know after the first field if you're working on a duplicate. Say NO to redundant data! Improve your SugarCRM data quality by being prompted of duplicate values while creating new records.
#2453 - Multiple feilds
I have just installed and I do not see how to configure if 2 separate fields need to match, example. I want to prevent a duplicate address and have to match both the address and the zip code in order to block saving. (example: there could exist more than one 123 main street, but not in the same zip code) How do I do this, when I enter more than one field into the admin section, it appears to operate on a OR parameter vs an AND parameter for the match. Please advise
8 years ago
Hello Paul,
Thank you for using our product. The duplicate check is done on each field marked to check for duplicates in admin wizard. That means if there are 2 fields marked to check duplicates, it will check individually per field, and not in combination with (AND/OR). We have understood your requirement, but in order to give it a general solution could affect some customization which people might have done. If your requirement is to validate certain fields in common for specific modules, We can give you a customized solution. You can get in touch with us on skype : urdhvatech
Thanks & Regards, Team Urdhva Tech