by urdhvatech

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.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#2453 - Multiple feilds

Closed General Question created by Paul Bonnallie 5 years ago

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

  1. urdhvatech member avatar

    urdhvatech Provider Affiliate

    5 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "I had a problem with the install which Team Urdhva fixed very quickly by changing some folder and file permissions. Now off to test the Timesheet modu..." - sugaroutfitters1

    Read More Reviews