topic Re: Custom unique property in Tips, Tricks & Best Practices

Custom unique property

Ktamir — Sun, 21 Aug 2022 09:03:37 GMT

Hi,

I remember seeing somewhere an update about the option to create a custom unique property.

Is this correct?

Re: Custom unique property

karstenkoehler — Sun, 21 Aug 2022 09:15:14 GMT

Hi @Ktamir,

That's correct, see the full announcement below.

Best regards!

[Rolling out now] Unique Value Enforcement on Properties

Apr 27, 2022

What is it?

It's happening! You can now enforce uniqueness on properties in order to prevent duplicate values.

Why does it matter?

Two words: data quality. You rely on the data you store in HubSpot to make timely and critical business decisions, so it's important that the data is clean and reliable. One of the most critical aspects of having clean and reliable data is uniqueness—i.e., ensuring there are no duplicate records.

Until now, HubSpot has used the email property on contact objects to avoid duplicate records. We've heard loud and clear that admins need to enforce uniqueness on other objects in order to improve their data quality. With this release, admins can now set newly created custom properties as unique through the UI for HubSpot standard objects (companies, deals, products, and tickets), as well as custom objects.

How does it work?

Follow these simple steps to start enforcing uniqueness on a property:

In your HubSpot account, navigate to Settings > Properties.

Select one of the following objects from the dropdown: Company, Deals, Products, Tickets, or any Custom Object.

Then select Create Property.

Within the property creation flow, select either "Single-line text" or "Number" as the Field Type.

Next select the "Require each value for this property to be unique" checkbox and click the Create button to create the property.

When uniqueness has been enforced on a property, users will be prevented from entering duplicate values and will see the following error message when attempted:

Please note there are a few limitations to this feature:

Uniqueness can only be enforced on companies, deals, tickets, and custom object properties. It CANNOT be enforced on contact object properties.
It can only be set for newly created single-line text or number properties. Customers will not be able to set this validation on existing properties.
There is a limit to the number of properties the validation can be applied: 10 per standard object and 2 per custom object.

Who gets it?

This feature is rolling out now and will be available to all accounts.

Re: Custom unique property

DaveParry — Mon, 04 Dec 2023 20:52:28 GMT

@karstenkoehler,

Is it possible to have this behaviour adopt the new value and overwrite the old one? As I understand it, this prevents the new record being created and preserves the old one. Is this correct? Thanks.

Dave

Re: Custom unique property

JNOnHubspot — Fri, 22 Mar 2024 10:23:20 GMT

Why is it that there is always a weird restriction like "CANNOT be enforce on contacts"?? Like what am I using a CRM for?? ITEMS???? How technically hard can it be to enforce uniqueness of a property? You are either using a relational DB or nosql, whatever the tech underlying hubspot, it shouldn't be this hard and you shouldn't be "Rolling it out" like it's some new feature..

Re: Custom unique property

MS1512 — Wed, 04 Dec 2024 07:47:01 GMT

Hi, thinking this topic of ensuring unique value in a property a bit further. Can you automate unique value creation?

Typical example: you want to have an unique tender number but picking up the number not happening randomly by user. I.e. when you move your Deal to a certain sales phase ("Tender Phase") Hubspot gives automatically a tender number following certain logic to your property ("Tender_number").

Re: Custom unique property

MS1512 — Fri, 06 Dec 2024 12:39:12 GMT

Does @karstenkoehler know anything about this issue?