Making Email property unique

Smart CRM & Sales Hub CRM
1

Is it possible to make the Email property unique once data already exists? Currently this is grayed-out. Is that because there’s duplicate Email values, or because I cannot select this option once there are any Contacts?

2

@Bethesda can you elaborate a bit, maybe add a screenshot? The email property is unique, and it’s what identifies a Contact record and keeps duplicates managed. But you should be able to edit the email. Here’s a screenshot:

danmoyle_0-1661948723342.png
danmoyle_0-1661948723342.png374×640 27 KB

Or when you hover over the name there’s an edit button:

danmoyle_1-1661948759421.png
danmoyle_1-1661948759421.png383×227 15 KB

Is that what you’re referring to?

3

Thanks Dan. So what you’re saying is that the built-in Email property has a unique constraint no matter what? I would have expected the "Require Each Value for this Property to be Unique" checkbox / text to be gray. Since it is not, it suggested that there were cases where it I could allow duplicates in the Email property. Hope that makes sense.

Bethesda_1-1661949772867.png
Bethesda_1-1661949772867.png1206×1202 154 KB

4

@Bethesda this looks like a recent update. @karstenkoehler have you seen this or used it yet? I’m looking in my portal, and it says it’s not yet available for Contacts.

Short answer is that yes, HubSpot uses the email property to uniquely identify a contact record. So honestly, I’m not sure why this option would exist for the email in the contact properties.

5

Hi @Bethesda,

Adding to what @danmoyle, the email property on the contact property is already enforced by HubSpot as a unique identifier. There can be no two contacts with the same email address: Deduplicate records in HubSpot

Should any tool (import, form, API) try to create a record with an existing email address, the existing contact record will be overwritten/updated.

Best regards!

6

Maybe I’m just stubborn :slightly_smiling_face: but details really really matter in a UI -- if HubSpot always requires that the Email property is unique, then why is the checkbox not checked?

Bethesda_0-1661950293371.png
Bethesda_0-1661950293371.png992×292 30.4 KB

7

Hi @Bethesda,

The email property is as old as HubSpot itself and HubSpot has been around for a while. Enforcing unique values has been introduced fairly recently – it’s probably an oversight that you could flag with HubSpot support or here: https://community.hubspot.com/t5/HubSpot-Ideas/Require-a-property-to-be-a-unique-value/idi-p/324225

Best regards!