Ability to add or append data to a field, rather than overwrite by default | Community
Skip to main content
A
Anonymous
January 22, 2015
Duplicate

Ability to add or append data to a field, rather than overwrite by default

  • January 22, 2015
  • 9 replies
  • 4443 views
It would be great to have the ability, either via list import, or possibly on form submissions, to set data being mapped to certain fields to append to existing data in that particular field, rather than overwrite it.

One example would be for the Description SFDC field, which is a long text field.  This field is probably commonly used by sales reps to write in call notes, or used by the marketing team to write in campaign notes of some sort.  It would be great to have the option to append notes from other campaigns to this field on a list load, rather than either have to map additional notes to a new field or be forced to overwrite whatever is already in this field.

    9 replies

    K
    kh-lschutte
    New Participant
    February 7, 2020
    No text available
    A
    Anonymous
    January 23, 2015

    There is legend that there is an ascii line break, but I never got it to work. <br> does nothing. 

    So no. What I do instead is put a space then | and another space. " | " in between values.

    A
    Anonymous
    January 23, 2015
    Nice workaround. Is there any way to force a line break between the old and new value?
    A
    Anonymous
    January 23, 2015
    Exactly. You don't need that field in Salesforce as it's only a "holding place" for the data before it's appended to the salesforce field. It definitely works.
    A
    Anonymous
    January 23, 2015
    Interesting workaround.  I haven't tried this method myself, but seems like it could work. It looks like this requires the creation of an additional 'holding' field to push data into, which would then be appended...although that field could probably just be a Marketo field so it wouldn't require involvement from a SFDC administrator..
    A
    Anonymous
    January 23, 2015

    Yes. That's what I mean. 

    Field 1 -- import field
    Field 2 -- history field

    Campaign : 

    If Field 1 is updated, then change data value - Field 2 - {{lead.Field 1}} {{lead.Field 2}} 

    Now you've pushed that data together.

      A
      Anonymous
      November 4, 2015

      Hi Adam - would this only work for a list import mass-append? What about appending data from a form submission if that value is already populated and we want to append new form submission data onto the field?

      A
      Anonymous
      November 4, 2015

      This was originally posted in the community, but it didn't get pulled over into the new community, so I copied it to my linkedin.

      Concatenation in Marketo | Adam New-Waterson | LinkedIn

      A
      Anonymous
      January 23, 2015
      Yep, I think you can do this on an individual lead basis, but we'd love to be able to mass append - like having the option to concatonate to a specific field through the list import wizard, for example
      A
      Anonymous
      January 23, 2015
      This can be accomplished with tokens & multiple fields now, but isn't quite the idea you suggested.
      A
      Anonymous
      January 23, 2015
      This would be great!
      Terms & ConditionsAccessibility statement

      Loading footer...