Best practice for syncing web form data to Salesforce

bgottesman
Member

When a visitor fills out the contact form on our web site, it sends the data to HubSpot which then passes it through to Salesforce which creates a new lead or updates an existing lead or contact. The Comment field on the form is passed into the Description field in Salesforce. 

 

The problem is that if the vistor fills in the form more than once, the newer comment will overwrite the older comment when what we really want to do is preserve both comments.

 

To avoid this problem, I was thinking that we would write the comment to a custom field in Salesforce (e.g. Web Comment), which would kick off a workflow that moves the content of the field to a new Task record and then clear the field. That way, each form submission is stored as a separate task and we can preserve the entire history.

 

My question is: Is this the best way to handle this? How have other companies dealt with this issue?

 

Thanks.

2 Replies 2
willsmith
Key Advisor | Diamond Partner

@bgottesman - were you able to find a workaround or resolution to this?

PamCotton
Community Manager

Hello @bgottesman 

 

Happy Friday, I will be tagging some top experts to join this conversation @Aakar@lynton@trevorjones71, any suggestions to @bgottesman  matter?

 

Thank you!

Pam

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




0 Upvotes