• Robert Edwards 50
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
As formula writing varies from feature to feature, I am struggling to convert multiple picklist field values into text to include as part of a Source Code concatenation process for Campaign Direct Mail assets. Can someone provide an example of how to concatenate fields of multiple data types as a single string when creating a New Resource to populate a field as a result of a decision point?

To be clear, I am trying to concatenate fields of the exact data types listed below:

TEXT+NUMBER+Picklist+Picklist+Picklist+Picklist

Here is what I have attempted so far:
{!$Record.Segment_Code__c}&{!$Record.Initiative__c}&TEXT({!$Record.Package__c})&TEXT({!$Record.RFM_Recency__c})&TEXT({!$Record.RFM_Frequency__c})&TEXT({!$Record.RFM_Monetary__c})