topic Re: Updating HubSpot with Salesforce formula fields in APIs & Integrations

Updating HubSpot with Salesforce formula fields

Jonnydk — Sun, 19 Jul 2020 09:07:22 GMT

Hi, I have read an article that states that HubSpot doesn't know when a formula field is updated on contact in Salesforce. Does anyone have a good workaround that will trick HubSpot into updating those operational fields in HubSpot?

Re: Updating HubSpot with Salesforce formula fields

Daniel_Bleich — Sun, 19 Jul 2020 09:28:07 GMT

Hi Jonny,

You can choose how a contact property gets updated when matched with an SFDC field.

If you choose "allways use SFDC" your contact property should get updated with the newest identity.

Be advised you will need to make sure that the contact is in the SFDC "inclusion list" to make sure this update happens.

Re: Updating HubSpot with Salesforce formula fields

Phil_Vallender — Sun, 19 Jul 2020 09:31:13 GMT

Hi @Jonnydk

Have you confirmed that is the case? Can you share the article?

If this is the case, then you might be able to use Salesforce Process Builder to map the value of the formula field to a standard field.

Hope this helps.

Re: Updating HubSpot with Salesforce formula fields

Jonnydk — Sun, 19 Jul 2020 09:37:09 GMT

@Phil_Vallender this is the article https://knowledge.hubspot.com/salesforce/salesforce-integration-sync-triggers "Please note: while updated values in a Salesforce formula field will not trigger a sync, an updated value in a mapped Salesforce field that is part of a formula will trigger a sync." I think it does actually work, right?

Re: Updating HubSpot with Salesforce formula fields

Phil_Vallender — Sun, 19 Jul 2020 15:38:51 GMT

Hey @Jonnydk

That note has me totally confused! Is the calculated field a part of the formula that calculates it?! Presumably. So it should work.

@jennysowyrda - I think that documentation could be impoved.

Re: Updating HubSpot with Salesforce formula fields

Jonnydk — Sun, 19 Jul 2020 16:23:28 GMT

👍 makes two of us 🙃 totally confused.

Re: Updating HubSpot with Salesforce formula fields

JuliaMongeau — Tue, 21 Jul 2020 18:15:06 GMT

Hey @Phil_Vallender ! Thank you for flagging this! I'll review this doc and partner with my team to improve the copy.

Re: Updating HubSpot with Salesforce formula fields

jared33edwards — Wed, 22 Feb 2023 23:02:07 GMT

Bulk editing all your records to an obviously incorrect value will trick the sync to running and matching to the correct Salesforce value. I know this works for text fields but you have to have the sync set to "Always Use Salesforce" for it to work.

So an example might be if you know you have records where the property value should be 1 thru 10, but you put a value of 200 in all your records. The HS sync autocorrects those 200 values to a 1 thru 10 value from the salesforce record. Hope this helps someone!