# Update/Overwrite/Append Data Options for Contact Property Fields

**URL:** <https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788>\
**Category:** HubSpot Ideas\
**Tags:** object, forms\
**Created:** [January 20, 2017, 12:06pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788 "2017-01-20T12:06:14Z")\
**Posts on this page:** 20\
**Page:** 6

<div class="post-metadata">

**Author:** ![RZhang](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rzhang/32/29892_2.png) [@RZhang](https://community.hubspot.com/u/RZhang)\
**Post date:** [June 10, 2021, 4:31pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/101 "2021-06-10T16:31:58Z")

</div>

why already 4 years. there is no function about it…

Let’s say I put this note field in the form, then a person fills it for the first time, and there is a note he fills again for the second time, then will the first note be overwritten before that.

 ![QQ截图20210611003106.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/6/6ada2dc1605974bdc603e0958447d2142994f56f.png)

---

<div class="post-metadata">

**Author:** ![MoreLeadsPlz](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MoreLeadsPlz](https://community.hubspot.com/u/MoreLeadsPlz)\
**Post date:** [June 10, 2021, 9:49pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/102 "2021-06-10T21:49:42Z")

</div>

@RZhang brings up a 2nd point that is also a big flaw of Hubspot - the note card that sits in contact’s newsfeeds is completely unlinked from any notes field in the contact properties, so those notes cannot be reported on, cannot be shown as previews from other objects, cannot be exported, basically cannot be treated like a field in any way. The note cards also create separate instances each time you take a note, and these cannot be linked or appended together.  
This causes misalignment between sales and marketing, because marketing often creates a notes property on contact objects that appears in the left-hand sidebar on contacts in order to view and report on notes from anywhere, but the UI prompts sales to leave notes in the unusable note cards that appear in contact newsfeeds, where information gets lost and buried underneath reems of contact activity that happens after those notes.

Hubspot’s notes set-up leads to a loss of context and data for go to market teams, diminshed collaboration, and increased organizational friction between marketing and sales.

---

<div class="post-metadata">

**Author:** ![jenrankin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jenrankin/32/1529_2.png) [@jenrankin](https://community.hubspot.com/u/jenrankin)\
**Post date:** [July 15, 2021, 10:25pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/103 "2021-07-15T22:25:17Z")

</div>

This is a huge issue for our use cases and creates so much manual work on our end that it’s debilitating.

---

<div class="post-metadata">

**Author:** ![NAylward](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/naylward/32/98997_2.png) [@NAylward](https://community.hubspot.com/u/NAylward)\
**Post date:** [July 27, 2021, 2:01pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/104 "2021-07-27T14:01:05Z")

</div>

adding a big ol’ +1 to this!! this is also entirely unrelated to the import tool also - not satisfied that the most recent reply to this actually understands the issue in this thread.

for our use case; we’d love to be have something like this in order to work reliably with the profitwell integration.

for some of our bigger customers; they could have several teams / departments with individual accounts and stripe subscriptions - all of which map to \*unique contacts\* in hubspot that are associated to the \*same company\*. we’d love to be able to:

1) roll up the MRR for multiple contacts associated to a single company, to get an overall figure. currently, we have a workflow that copies the value from the contact to the associated company, and the profitwell fields are simply overwritten to match the most recently altered subscription.

2) list the plan types associated with the customer, rather than them being overwritten, such that we can use “where Plans (Profitwell) contains \<plan\_name\>” with confidence.

in it’s current state, we’re working under the knowledge that hubspot will also be fluctuating around the truth, rather than being able to provide it reliably

---

<div class="post-metadata">

**Author:** ![amanda-robo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amanda-robo/32/93181_2.png) [@amanda-robo](https://community.hubspot.com/u/amanda-robo)\
**Post date:** [August 3, 2021, 3:46pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/105 "2021-08-03T15:46:25Z")

</div>

This feature is desperately needed. Especially in the case of form fill outs and keeping a history of what was logged in properties in the past. I find this is an issue across the hubspot platform as well (for example, the recurring revenue analytics tools update the revenue value for monthly recurring revenue even for past dates once you update the amount). It basically erases the old data which is sometimes vital for historical account knowledge and reporting in some cases.

---

<div class="post-metadata">

**Author:** ![anandk](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/anandk/32/51304_2.png) [@anandk](https://community.hubspot.com/u/anandk)\
**Post date:** [August 4, 2021, 5:02am UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/106 "2021-08-04T05:02:04Z")

</div>

agreed!

---

<div class="post-metadata">

**Author:** ![TDN](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tdn/32/21752_2.png) [@TDN](https://community.hubspot.com/u/TDN)\
**Post date:** [August 12, 2021, 6:40pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/107 "2021-08-12T18:40:22Z")

</div>

The values of the multiples checkboxes gets overwritten by the new values of any subsequent forms submission. We need the ability to append values globally on any properties!

---

<div class="post-metadata">

**Author:** ![Sami\_Sharaf](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sami_sharaf/32/95715_2.png) [@Sami\_Sharaf](https://community.hubspot.com/u/Sami_Sharaf)\
**Post date:** [August 12, 2021, 7:01pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/108 "2021-08-12T19:01:40Z")

</div>

We found a workaround to this…

2 new fields:-

- ‘field’

- ‘field history’

On form submission ‘field’ is updated

Workflow triggered on changes to ‘field’, ie. When ‘field’ is Known

Trigger webhook to append ‘field’ to ‘field history’ prepended with a comma

So that ‘field history’ lists all changes to ‘field’ separated by a comma

---

<div class="post-metadata">

**Author:** ![danielrnorris](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielrnorris/32/22768_2.png) [@danielrnorris](https://community.hubspot.com/u/danielrnorris)\
**Post date:** [September 13, 2021, 10:06pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/109 "2021-09-13T22:06:21Z")

</div>

Yes I think the Append, especially for Multi Select checkboxes is a major hole in the CRM functionality. I know there are ways to do it with workflows but this function should be in Lists when bulk editing and in Forms.

---

<div class="post-metadata">

**Author:** ![BHolden](https://avatars.discourse-cdn.com/v4/letter/b/c2a13f/32.png) [@BHolden](https://community.hubspot.com/u/BHolden)\
**Post date:** [February 3, 2022, 9:28pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/110 "2022-02-03T21:28:39Z")

</div>

This functionality exists in Marketo and there are many true business use cases that require this functionality. It allows for data to into one field multiple times instead of having to create a new task in Salesforce.

---

<div class="post-metadata">

**Author:** ![stephsurns](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stephsurns/32/99730_2.png) [@stephsurns](https://community.hubspot.com/u/stephsurns)\
**Post date:** [March 22, 2022, 1:35am UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/111 "2022-03-22T01:35:39Z")

</div>

Agreed! Will this be revisited as Hubspot is bringing on larger clients?

---

<div class="post-metadata">

**Author:** ![MoreLeadsPlz](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MoreLeadsPlz](https://community.hubspot.com/u/MoreLeadsPlz)\
**Post date:** [March 30, 2022, 11:44pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/112 "2022-03-30T23:44:24Z")

</div>

[@Sami\_Sharaf](https://community.hubspot.com/t5/user/viewprofilepage/user-id/149091) Have you considered how posting information like this hurts Marketing Operations professionals? Many of us have invented this exact solution before you, without guidance from our managers or colleagues; some even solved this in the first 1-2 years of our professional careers. A potentially stressful experience. But now, you have given away the information for free. Giving away monetizable trade secrets has a cost to professionals who have earned this solution.

---

<div class="post-metadata">

**Author:** ![danielrnorris](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danielrnorris/32/22768_2.png) [@danielrnorris](https://community.hubspot.com/u/danielrnorris)\
**Post date:** [March 31, 2022, 12:19am UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/113 "2022-03-31T00:19:42Z")

</div>

[@Sami\_Sharaf](https://community.hubspot.com/t5/user/viewprofilepage/user-id/149091) that is a great workaround that I have implemented with a few clients. Though definitely think it is time HubSpot made Appending a universal feature across the tools. Anyways appreciate you sharing though. @MoreLeadsPlz that is what this community is all about, a simple workaround is not a trade secret and should hardly be considered an invention. My clients dont hire me because I hide solutions from them, my clients hire me because i help them find solutions and am there to help solve all their future problems. There is no shortage of problems clients need our help with.

---

<div class="post-metadata">

**Author:** ![Amy\_Brierley](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amy_brierley/32/91639_2.png) [@Amy\_Brierley](https://community.hubspot.com/u/Amy_Brierley)\
**Post date:** [June 30, 2022, 12:40pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/114 "2022-06-30T12:40:39Z")

</div>

We have only just discovered that the importing functionality has been not working the way we thought, with regards to properties that are multiple select drop down.

When importing data, if you are importing records which have a value that is a multiple select drop down property, during the import process, when you are asked if you want to overwrite the value, and you specify no to overwrite values, it not import the value at all (i.e. it does not import and append the value). Per [this HubSpot knowledge base documentation](https://knowledge.hubspot.com/crm-setup/import-objects#:~:text=To%20prevent%20the%20import%20from%20overwriting%20all%20properties%20included%20in,that%20property%20will%20be%20updated.), selecting the _Don’t override existing value_ checkbox ensures the import will not update that property for any records that have the value. Any new records or existing records with no value for that property will be updated

To add or append values to a [multiple checkboxes property](https://knowledge.hubspot.com/articles/kcs_article/contacts/what-are-the-different-property-field-types-available) in an import, there are two workaround options:  
(1) add a semicolon before the first value, and then, between each additional value (;value 2;value 3; value 4) in your [import file](https://knowledge.hubspot.com/articles/kcs_article/contacts/set-up-your-import-file). These value options must be created in your property prior to the import ([KB](https://knowledge.hubspot.com/crm-setup/import-data-to-checkbox-properties#:~:text=To%20add%20or%20append%20values,property%20prior%20to%20the%20import.))  
or  
(2) Import the data without importing the property in question, then filter the contacts you are hoping to add this property value to in your portal by using the import id, and bulk edit their property value (Contacts \> Contacts \> all filters \> select the checkbox next to name \> select all records \> edit)

To do either of these workarounds each time we import, where we have with several fields of this type is going to be time consuming! Ideally, we just want to import and append values, without overwriting the existing values

---

<div class="post-metadata">

**Author:** ![lindahouben](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lindahouben/32/82677_2.png) [@lindahouben](https://community.hubspot.com/u/lindahouben)\
**Post date:** [August 5, 2022, 8:00am UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/115 "2022-08-05T08:00:58Z")

</div>

Would be a great addition.

---

<div class="post-metadata">

**Author:** ![VEspo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vespo/32/44503_2.png) [@VEspo](https://community.hubspot.com/u/VEspo)\
**Post date:** [September 21, 2022, 2:42pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/116 "2022-09-21T14:42:36Z")

</div>

Wondering why you can’t chose the Don’t Overwrite option when you are importing a file that includes the record ID. We need an option to NOT update certain fields if a value already exists - even when mapping the record ID

---

<div class="post-metadata">

**Author:** ![TimBrown](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/timbrown/32/98997_2.png) [@TimBrown](https://community.hubspot.com/u/TimBrown)\
**Post date:** [September 22, 2022, 3:42am UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/117 "2022-09-22T03:42:20Z")

</div>

That option wasn’t available when this thread was first created 5 years ago. The choosing not to update function is still pretty weak in my opinion. You should at least be able to say update if field is blank. And to not update if field is known. Still have to use InSycle to achieve that.

---

<div class="post-metadata">

**Author:** ![VEspo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vespo/32/44503_2.png) [@VEspo](https://community.hubspot.com/u/VEspo)\
**Post date:** [September 22, 2022, 6:01pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/118 "2022-09-22T18:01:37Z")

</div>

Do I start a new thread on this topic?

---

<div class="post-metadata">

**Author:** ![Steeler](https://avatars.discourse-cdn.com/v4/letter/s/71e660/32.png) [@Steeler](https://community.hubspot.com/u/Steeler)\
**Post date:** [December 12, 2022, 7:56pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/119 "2022-12-12T19:56:46Z")

</div>

+1

---

<div class="post-metadata">

**Author:** ![Ryamak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ryamak/32/84335_2.png) [@Ryamak](https://community.hubspot.com/u/Ryamak)\
**Post date:** [December 14, 2022, 8:45pm UTC](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788/120 "2022-12-14T20:45:08Z")

</div>

This is a huge need. Amazing that after 5 years the ability to do this still hasn’t been considered. Need a way for a form submission property to be filled in if blank or don’t update if field is known. Would require too many workflows for all of the different properties used on various forms.

[Previous page](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788.md?page=5)

[Next page](https://community.hubspot.com/t/update-overwrite-append-data-options-for-contact-property-fields/788.md?page=7)
