Skip to main content
New Idea

Concatenate function in data Management for more than 1 String

Related products:CS Data Management & Integrations
DannyPancratz
FMEEvangelist
  • DannyPancratz
    DannyPancratz
  • FMEEvangelist
    FMEEvangelist

angela_domenichelli

As an Admin, I need to concatenate a URL field with a web address, an ID field, and the additional character /view so I can surface a usable SF URL to end users on the c/r360 so they can easily navigate to the Relationship page in Salesforce.  

Current status: In Data Management, when creating a calculated URL field, I can only add the web address and the ID, but there is no place for and additional string to be added.

Work around: We have a rule populate the field

4 replies

  • Contributor ⭐️
  • 1 reply
  • December 20, 2023

I’ve done something similar using a formula field with nested concatenate functions, like below (where `SFDC Account Id` is already a field on the object):

 

concatenate( '' , 'https://my_domain.lightning.force.com/lightning/r/Account/' , concatenate( '' , SFDC Account Id , '/view' ) )

 


angela_domenichelli
Forum|alt.badge.img+12
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 244 replies
  • December 20, 2023
iwave-ian wrote:

I’ve done something similar using a formula field with nested concatenate functions, like below (where `SFDC Account Id` is already a field on the object):

 

concatenate( '' , 'https://my_domain.lightning.force.com/lightning/r/Account/' , concatenate( '' , SFDC Account Id , '/view' ) )

 

Have you done this as a formula in the data Management table directly?


alizee
Forum|alt.badge.img+12
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 659 replies
  • December 21, 2023

Hey @angela_domenichelli 

I have done the same as @iwave-ian in data management yes, to get rid of the rule I had. See below: 

Hope this helps!

A


angela_domenichelli
Forum|alt.badge.img+12
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • 244 replies
  • December 21, 2023

Very helpful, thank you @alizee


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings