Making Data Validation and Record Creation Easier than Ever

Do you want to make data validation and record creation easier to help ensure data integrity in CRM while still allowing your business to operate effectively? If so, today's blog is for you!

It's not uncommon to have sources of data that are error-prone or unreliable, but we still want to be able to get the data into CRM as quickly as possible to take action. This data often comes from integrated sources such as a website, distributor, or other third-party source. CRM Administrators prefer that data is checked to ensure it is not duplicate data and that it is complete and correct BEFORE it ever makes it to CRM. However, that can sometimes lead to delays in the process. There is a configuration and workflow process you can use to aid in expediting this process, allowing the user to validate the data and take action on the request at the same time.

In this scenario, we have a third-party website where users can request product samples. Sample requests from the website are imported into CRM to a custom entity called Sample Requests and associated to an Account or Contact record. The challenge is that the request could come from either an existing customer or a new prospect. If a previous record doesn't exist, we want a CRM user to review it BEFORE a new Account and/or Contact is created to help prevent a duplicate record.

The process should be easy to do, all without having to re-enter information. We will use a workflow because we captured the contact data provided in fields on the custom Sample Request entity.

TIP: When creating the fields on the custom entity, it's easiest if you make them the same type and size as the Account and Contact fields you will be mapping to.

1. The Sample Request record is created through integration.

data validation

2. Create an on-demand, real-time workflow to allow users to easily create a new Account or Contact and then update the Sample Request with the newly created record.

data validation

Map the fields from the Sample Request record that are relevant to the Company (i.e. Company Name, Address fields, website, etc.).

Also map the fields from the Sample Request record which are relevant to the contact (i.e. First Name, Last Name, Address fields, Email Address, etc.). Let's also map the Company which was created in the prior workflow step.

data validation

If desired, you can also update the Primary Contact on the Account record as we did in our workflow.

data validation

The final item in this step is to update both the Account and the Contact on the Sample Request to associate with the newly created Account and Contact using values created in our previous workflow steps.

data validation

3. After validating the data and confirming that this should be a new Account or Contact, select and run the workflow.

The Account and Contact will be created. In our example, we also assigned the Contact as the Primary Contact for the account.

data validation

The Sample Request Company and Contact lookup fields will be updated.

data validation

Some additional things to consider that may improve usability or data integrity:

That's all for the blog today! After all that hard work, reward yourself with a new video on PO TV!

Happy CRM'ing!