Tips, Tricks & Best Practices

Ktamir
Contributor | Platinum Partner
Contributor | Platinum Partner

Custom unique property

SOLVE

Hi,

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

Is this correct?



<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">










Karin Tamir










Karin Tamir

HubSpot Expert
Glare Marketing Technologies | HubSpot Platinum Partner



Schedule a Call with me










Thumbs Up

Did my post help answer your query? Help the community by marking it as a solution.







0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Custom unique property

SOLVE

Hi @Ktamir,

 

That's correct, see the full announcement below.

 

Best regards!

 

--

 

Contacts | Companies | Deals | Tickets | Settings | Custom Objects

[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.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

4 Replies 4
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Custom unique property

SOLVE

Hi @Ktamir,

 

That's correct, see the full announcement below.

 

Best regards!

 

--

 

Contacts | Companies | Deals | Tickets | Settings | Custom Objects

[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.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

MS1512
Member

Custom unique property

SOLVE

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").

JNOnHubspot
Member

Custom unique property

SOLVE

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..

DaveParry
Contributor | Elite Partner
Contributor | Elite Partner

Custom unique property

SOLVE

@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 

0 Upvotes