Update/Overwrite/Append Data Options for Contact Property Fields

Basically for each property I want 3 options to choose from:
1) Update value if blank
2) Append to value
3) Overwrite value

 

Sample use case(s):
Append Option: Notes Field
I have a comments field on my contact form where someone sends us a query. If that contact later submits another query I don't want to lose the previous info from my records. I want to see the new information appended to that field.  (Can't keep creating new properties and using smart properties). 

 

Overwrite Option 
Standard as happens curently with most fields, if a contact enters a new phone number it overrides the previous data to keep it updated with the latest information.

 

Update if Blank option - Lead Source
When a lead comes in, I assign the Lead Source to it, but I only want that updated if there is no previous Lead Source assigned to it. I don't want subsequent forms to overwrite the value. Smart Field(s) works only partially because if I use the API to submit forms, smart fields do not stop it from being overwritten.

 

Thanks 

HubSpot updates
49 Replies
JoeDavies Esteemed Contributor | Gold Partner
Esteemed Contributor | Gold Partner

This definitely should be a feature - as well as selective use of existing data at the field level rather than only on a field as a whole.

It also looks weird/confusing/creepy to the user if they come back to submit a 2nd form and the message they wrote last time pops up!

Boon
New Contributor

A good CRM should be able to allow new entries submitted in the same field. For B2C companies, we usually record a lot of conversations with our prospects. I suggest new messages could be automatically synced from "messages" field, and recorded under "Notes" in contacts timeline. 

Vicky
Occasional Contributor

Yes, it is absolutely must have! I need to save all the options of the property that existed ever. Could not find the way to do it.

Is there any news on this idea??

kyle2
Occasional Contributor

Upvote. This is a critical flaw with hubspot right now.

BB1
Regular Contributor

Hi Everyone - definately sounds like an important capability, hoping Hubspot will roll it out asap.

 

Meanwhile, I think a simple workaround can be as follows;

 

1. Add an extra field for each of thos you don't want overwritten, for example Lead Source, make Lead Source Temp.

2. Map the import to Lead Source Temp

3. Create a workflow - if field Lead Source is blank, copy Lead Source Temp to Lead Source.

 

You can do a similar thing for fields to append, make Notes Temp, then make a workflow - if Notes is not blank, append Notes Temp to Notes, if blank - copy Notes Temp to Notes.

 

How does that sound for now?

JoeRoberts
Occasional Contributor

 Even in List imports it would be great to have the option to not update any fields if the contact is already in the system.

 

Give you the option to either overwrite existing contact's data or ignore them from the import. Assumed this would be out of the box functionaliy.

Zsofia
New Contributor

Upvote! 

trevorfox
New Contributor

Immutable hs_analytics_souce, hs_analytics_souce_1, hs_analytics_souce_2 fields are helpful to understand the first touch. But allowing leadsource to be updated when it already set shifts attribution to secondary touches.  That is really misleading.

TimBrown
Occasional Contributor

 Hubspot - how have you not made this change yet? It is basic data management.

 

Please prioritise this improvement!!!

TimBrown
Occasional Contributor

Furthermore, we ideally should be able to turn on a feature that allows us to manually check updates to data to make sure good data isn't being overridden with garbage. For instance, it would be good to be able to review all data that has filled in a form form and review it. At the moment, all I can see is if we do that manually for each form. Should be able to select any form. Can do last modified but that could include uploads.