Difference between revisions of "Handling MailingStreet"

From EN Salesforce Integration
Jump to: navigation, search
(Created page with "Below is an example how Address 1 and Address 2 can be used in combination with the MailingStreet field, on the Contact object. Note that two process flows are required. Th...")
 
Line 3: Line 3:
 
Note that two process flows are required.  
 
Note that two process flows are required.  
  
The first is to combine Address 1 and 2, into one field on the Engaging Networks Import Record, in order to populate MailingStreet on processing. The second is to separate MailingStreet, into two fields on the Contact object, in order for this data to be pushed correctly to Engaging Networks.
+
* The first is to combine Address 1 and 2, into one field on the Engaging Networks Import Record, in order to populate MailingStreet on processing.  
 +
* The second is to separate MailingStreet, into two fields on the Contact object, in order for this data to be pushed correctly to Engaging Networks.
  
  
== Formula to Combine Address 1 and 2 ==
+
Before creating the following formula and workflows, a Custom Label needs to be created. This will provide a workaround to insert and then find/replace new line characters for the addresses. It is based off this idea, [https://explorationsintosalesforce.wordpress.com/2015/12/01/saving-line-breaks-to-text-fields/comment-page-1/ expressed on this blog].
  
 +
=== Create a custom label ===
 +
 +
Head to Setup and create a new 'Custom Label'.
 +
 +
 +
[[File:Newline label.png|framed|none]]
 +
 +
 +
 +
== Formula to Combine Address 1 and 2 ==
  
 +
Head to the field settings of the [[Engaging Networks Import Records|Engaging Networks Import Record]]. Create new a formula field and named the field '''Mailing Street Combined'''
  
  

Revision as of 15:06, 14 February 2019

Below is an example how Address 1 and Address 2 can be used in combination with the MailingStreet field, on the Contact object.

Note that two process flows are required.

  • The first is to combine Address 1 and 2, into one field on the Engaging Networks Import Record, in order to populate MailingStreet on processing.
  • The second is to separate MailingStreet, into two fields on the Contact object, in order for this data to be pushed correctly to Engaging Networks.


Before creating the following formula and workflows, a Custom Label needs to be created. This will provide a workaround to insert and then find/replace new line characters for the addresses. It is based off this idea, expressed on this blog.

Create a custom label

Head to Setup and create a new 'Custom Label'.


Newline label.png


Formula to Combine Address 1 and 2

Head to the field settings of the Engaging Networks Import Record. Create new a formula field and named the field Mailing Street Combined




Workflow to separate MailingStreet into Address 1 and Address 2