Zapier Question - Can I create a unique company name with two contact properties?

SOLVE
Advisor

I have a unique use case where I need the name of the company to be set as a unique identifier using two contact properties. I would like the name of the company to be a combo of two contact properties - Last 4 digits of SSN + Birthdate. This would ensure that every company created is a unique company. 

 

I cannot sync using domain name because the companies in this situation do not have websites/domain name. 

 

Can this be done with Zapier or integromat? Appreciate any insight someone familiar with the zapier/integromat can provide. 

 

Thanks!

-Adam

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Top Contributor

Hey Adam-

 

Hubspot will let you create companies with the same name all day log... It's the "Company Domain Name" property the enforces uniqueness.

 

Just set the "domain" property to something unique...

 

Zapier and Integromat both have tools to generate hash's. You could generate a hash based on the string value of the concatenated SSN and Birthdate. This hash would be unique - and not comprimise sensitive information. JUST append ".com" on the end and you are good to go!

 

We use the domain technique to enforce uniqueness - in our case we have an external on-premise system and use the Customer Number... so the domain value for companies looks like this "customer-number-172100.com"

 

Edit: Hey Hubspot - it would be nice to be able to enforce uniqueness without having to use a otherwise useful field for something such as this....

 

3 Replies
Highlighted
Community Manager

HI @HubSpotMaster,

 

I wanted to pull in some users who have discussed integromat in the past. @Wholesale-Solar and @joeolsenmm do you have any tips for @HubSpotMaster?

 

I did want to highlight as well that storing personal information, including SSN's is prohibited in HubSpot's terms of service.  

 

Thank you,

Jenny


Did my post help answer your query? Help the Community by marking it as a solution
Reply
0 Upvotes
Top Contributor

Hey Adam-

 

Hubspot will let you create companies with the same name all day log... It's the "Company Domain Name" property the enforces uniqueness.

 

Just set the "domain" property to something unique...

 

Zapier and Integromat both have tools to generate hash's. You could generate a hash based on the string value of the concatenated SSN and Birthdate. This hash would be unique - and not comprimise sensitive information. JUST append ".com" on the end and you are good to go!

 

We use the domain technique to enforce uniqueness - in our case we have an external on-premise system and use the Customer Number... so the domain value for companies looks like this "customer-number-172100.com"

 

Edit: Hey Hubspot - it would be nice to be able to enforce uniqueness without having to use a otherwise useful field for something such as this....

 

Community Manager

Thanks for sharing @Wholesale-Solar! (Thank you for the feedback as well, there are a few ideas that discuss deduplication rules based on factors other than domain). As and when updates are available, they will be communicated through the ideas. Let me know if you have any questions around that! Smiley Happy 


Did my post help answer your query? Help the Community by marking it as a solution
Reply
0 Upvotes