How to make Primary company (associated company) and Company Name match automatically?

Hello,
I am trying to figure out how to setup an automation that will match the company name field to whatever the generated associated company is. 95% of the time hubspot generates the correct associated company name and it is redudant to them manually enter this into the company name field.
Any help is appreciated. Thanks,

Hi @BButterfield there are quite a few threads that answer this, one this week, and as long as you have a pro subscription it can be done with workflows.

My question is - why?

The reason I’m asking is because “Company name” as a contact property existed before the “associated company” property - it was a way to populate the company name on the contact record outside of the association. (my reply to a related thread explaining this here)

Now that the associated property exists there is already a value and it is a redundant field.

How are you using company name property in a way that you can’t use associated company property?

I’d be happy to help solve for this if needed!

Hi @Jnix284!

The main reason I am wanting this is that I am a building out a series of reports that will include company name. In seeking to add that field into the reports, it appears HubSpot only allows “company name” as a field and not “primary company” or “associated company”

The closest substitute I could find was associated company name (id) which would give the associated company name, but would also include an ID # string at the end

Hi @BButterfield when you build a Custom Report, you can select additional data sources, if you include Companies then you can pull the company name value directly from the company, rather than the contact:

Then when you search for company, make sure you choose the value from the Company object, not the Contact object:

This will allow you to build reports that include company details for contacts.

I hope this helps you find what you’re looking for without having to cross-populate the company name property for contacts!

cc: @spnc thought this might also be helpful for you, I confirmed these reports can be built in a free account.

Thanks.

Dam n HubSpot feels so deep (and slightly overengineered) sometimes, and it would need another layer of documentation with practical use cases and demos because it feels like we often need to come on the Community forum to find answers :slightly_smiling_face:

Cheers will check that out.

You’re welcome @spnc, there is definitely a lot of depth and quite a bit to explore discover (it’s why so many have made entire businesses off of supporting HubSpot customers)…it can be a lot to figure out on your own if you’ve never used it before.

I was in that boat back in 2016 when it wasn’t quite fully fledged hubs (there were marketing tools, sales tools, and website options) and thankfully I’ve grown in my experience as the tools have evolved/expanded - there’s a lot to learn when you’re just getting started, but that’s exactly what the community is for!

Documentation will only go so far, sometimes asking a question and having someone share best practices or ideas with you can save a lot of time/trouble.

As you saw with the questions you’ve asked, there are a lot of different ways to approach things within HubSpot and it’s also a lot easier to customize for your use case once you work through the initial configuration.

Thank you! @Jnix284

You’re welcome @BButterfield, happy to help!

Orientation: Customer Starter Platform… Settings, Integrations, Connected Apps, Outlook Contacts, Actions, Settings, Contact Sync, Edit…

Solution: One way without exporting is to turn off the Company Name default option in mapped fields and create a custom mapping for Company Name to Company Name then Save and sync. That populates the Company Name property and also leaves the previous Primary Company association intact. New contacts after that will only have the Company Name property and not the Primary Company association. But it you reverse the process the Company Name property that was populated remains, and new contacts will only have the Primary Company association.

Suggestion: Would be nice if you could allow the source (Outlook) Company Name property to be mapped to both the Hubspot Company Name property and Primary Company association so that both would sync. Maybe provide an option to duplicate the source Company Name as Company Name 2 so user could then add custom mapping for that to sync with the Company Name property while leaving the original source Company Name to the default sync with the Primary Company association.

I was tackling the same problem for a client and found a rather simple solution - by creating a workflow automation.

Problem: Company name field (in contact properties) is blank even though there is a Company record associated with the Contact record. I want to populate the field using the associated company name.

Solution: I built a Contact based workflow as follows:

Trigger - Primary Associated Company is known.

Action - Copy Company property “Company name” into Contact property “Company Name”

Result: The associated company name is now copied and reflecting the Contact Property “Company Name”.

Let me know what you think and if that answers your question.