Display & Auto Fill

Display & Auto Fill Settings will be used for the following three purposes:

1. To select the information (attributes) to be displayed in the Record Review Screen.
2. To apply the Group and Attribute Rules to be used in the Auto Fill process at the group and session level.
3. To select the information that will be checked for exact matching at the time of Auto Merge process at group and session level.

Navigation:

To access the Display & Auto Fill settings screen click the 'Settings' button, then navigate to the ‘Display & Auto Fill’ tile. You will be directed to the below screen:

Entity Selection

1. Entity Type:
   1. Single (Account/Contact or Lead)
   2. Cross (Lead to Contact or Lead to Account)

Please follow the following guides for the respective entity setup.

Once the 'Single Entity' option has been selected, you will be able to make the following selections:

Entity: Select the Entity from the drop down for which you want to set the ‘Display & Auto Fill’ settings. Select between 'Account/Contact or Lead.(Each display & autofill settings you set will be specific to each Entity).

Attribute Type: You will be able to filter the attributes by selecting from multiple data type categories.

Entity Reference: Allows you to display the Entity Reference Attributes in the ‘Review Screen’. You can select one of the following:

• Name (default): Displays the name of the attribute only. By default, ‘Name’ is selected.
• ID: Displays the ‘ID’ as the Attribute value.
• Both: Displays both the ‘Name’ and ‘ID’ as the Attribute values [Ex. For Owner Field: John Mirror (5cc85de1-22a9-49b7-24fe)]

Display Attributes By: You can toggle the list of attributes of the selected entity either by

• Display Name
• Schema Name (Underlying data name)

Entity Attributes:

• Attributes will appear on the left-hand side for each Entity selection, with the icons in ASC order. Hover the mouse on the icon and it will display the respective type of attribute.
• You can sort the attributes in ASC or DESC order.
• If Attributes are listed by ‘Display Name’, hover the mouse on the Attribute Name and you will able to see the ‘Schema Name’ for the respective attribute and vice-versa.
• You can search the required Attribute/Rule Option from the list by using Keyword Search feature. Please note - If the Attributes are listed by ‘Display Name’, you can search only by the keywords for ‘Display Name’ and not by the keywords for ‘Schema Name’ and vice-versa.
• You can drag and drop the attribute(s) under these section(s). Any attribute/field can be associated with single section.
• Attribute(s) associated with the section will be highlighted in different colour.

Display Group Configuration:

• Display Groups: Displays the list of all the sections you have added. Double click on the 'Section Name' to edit the section name. You can move section(s) as well as attribute(s) in upward and downward direction to change the display order in the DQ for Dynamics/Workbooks output screen.

• Clone Form Attributes: Select this function if you would like DQ to read all fields or attributes that currently exist within the chosen form from the entity. Utilising this function allows you the option to automatically populate your display and autofill settings with the existing attributes direct from your form.
• Expand All: Select the arrow on the top right selection of the page.
• New Display Group: Select the plus icon on the top right section of the page.
• Delete: Select the bin on the top right section of the page.
• Refresh: Refresh the settings to the last saved settings.
  

This functionality allows you to cross compare entities for duplicate records. There are a few small changes to be made in the setup, but the fundamental functions are the same as a single entity configuration.

Entity Type: For this, select 'Across Entity' from the drop-down.

Source Entity: Select 'Lead' Entity, as this will be the entity from which you will be checking for duplicates against the 'Target Entity'.

Target Entity: Select either 'Account' or 'Contact' for the entity which you want to use for checking against your 'Lead' source.

Entity Reference: There are three options:

• Name: Display the data from found duplicate.
• ID: Display the ID of the found duplicate.
• Both: Display both.

Now you will be able to select attributes for the Across Entity match.

Your pre-mapped fields will be shown on the left-hand side of the page. To alter the mapping for this match session, double click on the attribute name and you will get a list of dropdown values to select. This will look like this:

Drag and drop into a folder, the same way you would for a cross entity session.

These settings will be used to define the rules against any attribute section/group/field for the conditions below:

• A ‘Group Rules’ hyperlink will appear against the section/group and an ‘Attribute Rules’ hyperlink will appear against the field/attribute.
• If no rules have been assigned at Group level, the 'Group Rules' icon will appear in a light green colour. When a rule is applied the icon will portray a dark green colour.
• If no rules have been assigned to an Attribute, the 'Attribute Rules' icon will appear in a light blue colour. When a rule is applied the icon will portray a dark blue colour.
• If you define a rule at group level, then all attribute based rules will be overridden and the ‘Attribute Rules’ hyperlink will be greyed out against these fields.
• Session level Display and AutoFill settings will override the Global Level Display and AutoFill Settings. Also note, Users cannot drop the same rule more than once.
• If you want to apply specific rules against fields/attributes where a group rule has been applied, then the group rules will need to be removed via the ‘Group Rules’ hyperlink. When the Group Rules have been removed, then the ‘Attribute Rules’ hyperlink will be enabled allowing you to define the attribute rules. A prompt will be shown to you while updating/modifying the rules configuration.

When clicking on the ‘Group Rules’ hyperlink, the below pop-up window will appear:

• Currently, there are three rules that can be applied to a group of attributes. They are as follows:

Group Completeness - Select the group that contains the most/least values within this specific group.

Modified On - Selects the group which has the Newest/Oldest modified date. (This is decided by analysing the default ModifiedOn attribute value).

Created On - Selects the group which has the Newest/Oldest created on date. (This is decided by analysing the default CreatedOn attribute value).

Related Attribute (NEW) - Group selection is decided upon another 'Related' attribute value.

Attribute rules can be applied to select the best data in a particular field. The rules vary dependant upon the data type to provide you with the functionality you need to automate the re-allocation of data in an automated process.

Rather than go through each data type individually, here is a description of all the AutoFill rules. Some rules are specific to each data type, whereas some are generic.

Once you click on the 'Attribute Rules' Icon, you will receive a pop-up like this:

You will then be able to drag and drop specific rules and build up your Attribute level auto fill rules. They are as follow:

• Occurrence: Most or Least Occurring Value
• Length: Longest/Shortest Value
• String Value: Set to 'No/N/0/-1' or 'Yes/Y/1'
• Unique value populates an empty field: Any value will populate this field on the master record
• Related Attribute: Field value selection is made upon the criteria of another field value
• Modified On: Newest/Oldest date
• Default Value: Set a Default
• Equal: Select if value equals the value defined
• Contains: Select field value if it contains 'x'
• Begins With: Select field value if it begins with 'x'
• Ends With: Select field value if it ends with 'x'
• Contains Data: Select value if it contains data and the master does not
• Hierarchy of Values: Define winning values by selecting and ordering a hierarchy of values
• Default Value if Null: Set to 'x' if null
• Regular Expression: Analyse a string pattern and format accordingly
• Boolean: True/False
• Date: Newest/Oldest Value
• Number: Highest/Lowest Value
• Merge and Dedupe Multi-Select Values: Merge Multiselect values and then deduplicate values
• Retain Master Values: Only retain master record values on a multi select option set when merged
• Image: No Auto-Fill Rules Available

The toggle buttons to the right (see below) are the final configuration steps needed to finalise.

Show on DQ for Dynamics/Workbooks: This setting will be used to determine the attributes to be displayed in the DQ for Dynamics/Workbooks Review Screen. By default, the toggle will be 'ON' against a section/group as well as its field attributes. If required, you can toggle 'OFF' to hide the attribute from DQ for Dynamics/Workbooks Review Screen. You can also toggle the display 'ON' or 'OFF' against a section/group, and the entire section/group and it's attributes will be hidden from the DQ for Dynamics Review Screen.

Exclude Update: Toggle this option 'ON' to restrict the attributes so that they cannot be updated on DQ for Dynamics/Workbooks Review Screen using ‘Manual Fill’ or ‘Auto Fill’ Process.(Default set to 'OFF')

Use for Auto Exact & Merge: Toggle this option 'ON' to consider the attributes for the Auto Exact & Merge process on the DQ for Dynamics/Workbooks Review Screen. If all the checked attributes are exactly the same as the Master Record, all associate duplicates are “Auto Accepted” and “Auto Merged” with The Master Record and De-activated in the Auto Exact & Merge Process.(Default set to 'ON').

Ignore Nulls for Auto Exact & Merge: This option is selected by default and ignores null matches while processing ‘Auto Exact & Merge’. If you want to consider null fields as exact matches, toggle the option 'OFF' for the respective fields, provided the field is used for ‘Auto Exact & Merge’.