Why is Data Quality Helper better than default Salesforce functionality?
Data Quality Helper offers more customization, flexibility, and better usability. It also provides tools that assist with cleanup for historic records. Simply put, this solution meets the needs for any type of organization. See the Data Quality Helper Overview Page for more information.
How are Data Quality Helper’s validation rules different from what is offered out of the box by Salesforce?
Data Quality Helper validation rules are different in a couple ways:
- Standard Salesforce validation rules are known as “hard” validation rules. This means the user may not save a record until a validation warning is not encountered. With Data Quality Helper, the Admin may configure a “hard” or a “soft” validation rule. Soft validation rules allow users to continue with the save after the warning message is displayed, allowing them to decide they have a valid reason to do so.
- Data Quality Helper validation rules also have highly customizable warning message formatting. This allows the Admin to change font style, font size, font color, and background color, as well as include merge field values in the warnings displayed to a user. Unfortunately, standard Salesforce validation rule warning formatting may not be changed and do not allow merge field values in their warnings.
How are Data Quality Helper’s duplicate rules different from what is offered out of the box by Salesforce?
Data Quality Helper duplicate rules are different in a few ways:
- Data Quality Helper duplicate rules may be created for any object type, while Salesforce duplicate rules may not be created on every standard object type.
- Data Quality Helper duplicate rules also allow Admins to define and adjust how similar a field value has to be for a record to be flagged as a duplicate.
- Users are given the chance to view and compare two different fields when checking if their values truly are the same.
- Users also are given more control over what field values are used when records are merged.
How are Data Quality Helper’s data cleanup rules different from what is offered out of the box by Salesforce?
Data Quality Helper data cleanup rules are different in a few ways:
- Standard Salesforce deletion functions have limitations that are addressed by Data Quality Helper’s data cleanup rules. Users can preview records before deletion will occur. Email notifications are sent prior to when recycle jobs will run, and also if there are errors during the run.
- Data Quality Helper data cleanup rules allow for the mass deletion of records. Admins define which records will be deleted based on criteria in the data cleanup rule setting. (For example, the criteria could be Cases: Closed = True and Closed Date <= 365 days.) An unlimited number of data cleanup jobs can be configured on a schedule, run after Salesforce Data Export, or manually run.
- Deleted records are sent to the Recycle Bin where they will remain until you purge them or for 15 days, whichever is sooner. More information: Salesforce Recycling Bin. It is also possible to choose to hard delete records, and those records will not be sent to the Recycle Bin.
- Data Quality Helper data cleanup rules also show the current data usage calculation, which is updated hourly (so there may be a lag in the final calculation). Further, Admins are sent a notification when the org is nearing its Salesforce Storage limit. Select the percentage of storage usage that triggers the notification and Data Quality Helper sends an email when the org reaches the threshold.
Does Data Quality Helper have a free version?
Yes. The free version allows for the configuration of two validation rules and one duplicate rule as well as the deletion of 20,000 Salesforce records each month. The premium version allows for unlimited rules of either type and an unlimited number of records for deletion.
Can Data Quality Helper create validation rules, duplicate rules, and data cleanup rules on any object type?
Yes. There are no limitations—rules can be created for any type of object.
Does Data Quality Helper allow users to save records even if a validation rule or duplicate records are detected for a record?
Yes, if the Admin determines it is allowed when configuring the rule.
Can users prevent warning messages from displaying in the future if they confirm the data they have entered for the record is valid?
Yes. Admins may decide which validation rules can be ignored. If the Admin decides a rule is very important and should not be ignored, they may do that as well.
Does a user have to create/edit a record in order to see validation or duplicate warning messages?
No. Data Quality Helper has two Lightning Web Components that may be used to display warning messages without requiring a user to edit/create a record. One component may be added to the record detail page, showing data quality issues with a record being viewed. The other component may be added to the home page, displaying either all or only owned records with data quality issues.
Does Data Quality Helper help me find data quality issues for records that were created prior to the configuration of a validation or duplicate rule?
Yes. After a rule is configured you may:
- go back to the Data Quality Helper home page
- select the option for the type of rule that was just created
- click the dropdown arrow next to the rule that was just created
- click the Log Validation Issues menu item
Once all issues are logged you may view the home page Lightning Web Component to see all records with data quality issues.
Why are soft validation rules valuable? Why should we allow users to bypass validation rules?
There are many reasons why an organization would like to allow its users to bypass defined validation rules.
- In most situations, the data input on a record should follow the standards set in place by an organization. However, sometimes those standards cannot be achieved. For example let’s say an organization prefers to reach out to contacts via a phone number populated on the contact record. Sometimes that phone number is not correct and other times that phone number is not provided or available. Would you prefer to prevent that contact from being created, or would you still want that contact to be created with other forms of contact such as email? We’ve found that in most situations organizations still want those contacts to be created.
- Soft validation rules may be put in place to inform users of a cascading effect before or after a save of a record. Let’s use a time-off request as an example. Say a user has 10 hours remaining in their balance of time off remaining for the year. If that user logs a time off request for 20 hours, wouldn’t it be important to inform that user that they are requesting more hours off than what is remaining in their balance and also to inform them that if they continue to request the time off they will have some unpaid time off?
- Sometimes data is only available at a later date. Let’s say your organization is working on a project for one of your customers. In most cases, key information such as the start date is known right away, but that is not the case 100% of the time. It’s important for your organization to prepare for a project regardless of when the project is set to begin. So having all the known project information in Salesforce is important even if that project is missing key information such as the start date. It’s simple to find those project records without start dates if a start date validation rule is defined, so the user can easily populate that information once it is known.
After data cleanup rules have been run, some records that meet the defined criteria might not have been deleted. Why is this happening?
The default behavior of data cleanup rules is to only delete a maximum of 20,000 records when rules are run. Also, Data Quality Helper Free Edition is limited to 20,000 record deletions per month. If Admins would like more than the 20,000 records to be deleted, there is the option to either adjust the 'Maximum Number Of Records To Delete' setting or manually run Data Cleanup Rules Storage Helper multiple times. With either option, an upgrade to Data Quality HelperStorage Helper Premium Edition is required to delete more than 20,000 records per month.
Why do I not have access to data cleanup rules?
Users may not have access to use data cleanup rules because the user is not assigned to the permission set for the feature. To get access, users may ask the Salesforce Admin to be added to the data cleanup rules permission set.
What security do I have with Data Quality Storage Helper and Passage Technology?
See answers to our frequently asked security and data processing questions.
What is your release process?
See Future Release Process.