Skip to main content

Concatenate function in data Management for more than 1 String

  • December 20, 2023
  • 4 replies
  • 25 views

angela_domenichelli
Forum|alt.badge.img+12

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 ⭐️
  • 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 ⭐️⭐️⭐️⭐️⭐️
  • 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' ) )

 

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


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 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 ⭐️⭐️⭐️⭐️⭐️
  • December 21, 2023

Very helpful, thank you @alizee