5 Replies Latest reply on Mar 27, 2013 8:37 AM by b84f644ed3d665fbbb9834fa13cf9d83c04b481f

    Remove data from a Multi String field

      I have a SFDC form where there is a picklist Value.

      In Marketo i have Checkboxes (Boolean)

      I want when a field like "Want_assetstore_news" field is False

      Then i want to remove the string name in another field. Change data value Remove "AssetStoreNews"

      The other field is for our SFDC users so they dont need to tjeck the Boolean fields in SFDC:


      I found this artikel to add ekstra data https://community.marketo.com/MarketoArticle?id=kA050000000KzejCAC

      But i need the oppesite only remove 1 data fields.

      Im doing a email managment center for unsubribe. And want this to work with a single field in SFDC.

        • Re: Remove data from a Multi String field
          If you have a limited number of subscriptions, you could create a series of smart campaigns that would reconstruct the subscription string field value whenever any of the subscription checkbox fields changes.  In the first smart campaign's Flow tab, you would have the following flow actions.

          Change Data Value
               Choice 1
               If: [subscription 1 checkbox field] is 'true'
               Attribute: [subscription string field]  New Value: [subscription 1 string value]

               Default Choice
               Attribute: --Do Nothing

          Request Campaign
               Requested Campaign: Update [subscription string field] 2


          The Update [subscription string field] 2 smart campaign would have a Campaign is Requested trigger and the following flow action steps.

          Change Data Value
               Choice 1
               If: [subscription 2 checkbox field] is 'true'
               Attribute: [subscription string field]  New Value: {{lead.[subscription string field]}}, [subscription 2 string value]

               Default Choice
               Attribute: --Do Nothing

          Request Campaign
               Requested Campaign: Update [subscription string field] 3

          You would repeat this sequence of linked smart campaigns for every subscription checkbox field you have.
          • Re: Remove data from a Multi String field
            Thanks Elliot. 

            Thats is a Quit easy way of doing a Turn around. 

            But in some way i think it strange that i cant Remove a Value only add. But you sugestion solve my Program.. Thanks. 
            • Re: Remove data from a Multi String field
              This Contain and Error the solution. Elliot Provieded

              If you wanna Remove data in a field this is not the solution to do it.

              If you just ad Choice 1
              If: [subscription 2 checkbox field] is 'true'
              Attribute: [subscription string field]  New Value: {{lead.[subscription string field]}}, [subscription 2 string value]

              And continue. Then if i update the field again or i remove a choice. Then i still have the old field.


              So basic i need a Smart Logic from Salesforce

              Then i need a Smart Logic from the Landingpage management.

              These cant over rule. So if anything happens 1 of the places i i need to change so it Match with the subtring.
              • Re: Remove data from a Multi String field
                Jan, my suggestion was not on how to remove subscription names from the "subscriptions" field, but rather to rebuild the list of subscription names in the field using the technique described in the How Do I Append Data To a String Field Using the Change Data Value Flow help article.  I hope this answers the concern you seem to be raising about this.
                • Re: Remove data from a Multi String field
                  Hi Elliot .

                  The problem with the solution is that I dont tjeck the first newsletter but start at the next.
                  •           Then i dont want my data start with , Data
                       Like:
                       Unity newsletter, Assetstore Promotion, Asset Store News, Asset Store 24 hour deals,Events,SimVitz,Gambling
                        
                       So if the Starting Point is the Promotion and the user Unsubribe the General newsletter.
                       Then i end up having the data ",Assetstore Promotion, Asset Store News, Asset Store 24 hour deals,Events,SimVitz,Gambling"

                  The other problem if the change is happening in SFDC that meaning its from the field that contain.

                  Then the logic here is to remove The True from the Flow steps.

                  Elliot do Solution for both ways? Right now i see the best solution is build a WebHock app.