Quick Search
  • 24 Mar 2023
  • 3 Minutes to read
  • PDF

Quick Search

  • PDF

Article Summary

Overview

Cloudingo is designed to find and eliminate duplicates in bulk using Dedupe Filters and Rules. However, there may be times when a need arises to search for one-off groups of records to merge or convert.

Maybe duplicates have been manually identified in the Salesforce org and there are no common field values to match. Or there may be a quick need to merge records and taking time to search through filters to find the group to merge is not feasible. The Quick Search feature will find the records using minimal matching criteria (even just the record IDs if that is all that has been provided) preventing the necessity to use a dedupe filter.




Choose the ‘Tools’ → ‘Quick Search’ option from the left-hand-side navigation window.



Step 1: Select an object



  1. Choose an object to perform the search against.
    1. Options include Lead, Contact, Account, Person Account, or any custom object enabled for merge.


Step 2: Select conditions for searching


  1. Cloudingo will pre-set fields and conditions to give users a recommended starting point for filtering criteria.
    1. To delete a condition, choose the ‘x’ option to the far right for the field to be removed.
    2. To edit a condition, choose the existing drop box options and select the desired settings.
    3. Add Field: Choose the ‘Add Field’ option to add additional fields and criteria to locate the records.
  2. Field: Choose a standard or custom field from the field drop box.
  3. Condition: Choose a condition for searching (such as ‘Equal’, ‘Contains’, ‘Has No Value’, etc.).
    1. When using ‘Equal’, ‘Not Equal’, ‘Contains’, ‘Does not Contain’, ‘Starts With’, or ‘Ends With’, multiple values can be specified.
      1. Separate multiple values using a comma and no spaces.
    2. When using ‘Equal’ or ‘Not Equal’, the values must be entered exactly as they appear in Salesforce.
  4. Value: Specify a value if applicable. Not all conditions require a value to be set.
  5. Choose 'Search' to begin the search.


Step 3: Results

  1. If no matches are detected, revise the search conditions, and try again.
  2. If matches are detected, the number of matches detected will display.
    1. Choose the ‘View Results’ option to get into the merge preview page.



  3. Change Rule: Make sure that the desired rule is applied to the results. Use the ‘Change Rule’ option to choose another rule.



  4. Check Results for Accuracy: If only the desired records are pulled into the results, the records are ready to merge or convert.
    1. Choose the ‘Merge’ or ‘Convert’ option at the bottom of the page to manually merge/convert.


    2. Choose the checkbox next to each group of records to be merged and choose the ‘Mass Merge’ option.
      1. Choose the Select All checkbox to select all groups.



        ii. Mass Merge will not retain any manual changes made on the page. If making manual edits before merging, use the manual 'Merge' option at the bottom of the page.

  5. If too many records are pulling into the results, choose the ‘Back to Wizard’ option to add additional matching criteria.
    1. For the quickest search, identify the desired records in the preview. Obtain the record IDs and use the record IDs for matching criteria.
  6. Merge Preview Settings: The merge preview settings at the top right are the same as a dedupe merge preview. See the Merge Preview – Accuracy Check help article for more detailed information on the settings below.

    1. Field Ordering and Style: Rearrange, bold, or hide/enable fields for viewing.
    2. Sort: Choose the display sort setting (oldest to newest or newest to oldest modified).
    3. Options: Set options to control how data is displayed or how rules get re-applied when deselecting records for merge.


Step 4: Match Criteria (Optional)

If the ‘Back to Wizard’ option gets chosen after performing the scan and viewing results, an additional step is provided to help users further limit records using matching criteria.


  1. Use existing filter to populate match criteria: Choose an existing dedupe filter to build the matching criteria (which pulls from Step 2 of the filter’s configuration).
  2. Matching criteria:
    1. Add a Scan: Choose this option to begin building the matching criteria.
      1. Field: Choose a standard or custom field from the field drop box.
      2. Matching Condition: Choose a matching condition (such as ‘Exact’, ‘Company Clean’, or ‘Fuzzy’).
      3. Options: Choose desired option settings (such as ‘Ignore Case’ or ‘Synonym Matching’)
    2. Add Match Condition: Choose this option to add additional matching criteria.
      1. Matching criteria uses ‘and’ logic and all records must meet the criteria to be identified.
  3. Choose ‘Add Another Scan’ to set up additional criteria to perform multiple scans using different matching conditions and repeat the steps above.
  4. Choose ‘Search’ to start the new search and follow the instructions described earlier in Step 3.

 


Was this article helpful?

What's Next