Skip to main content
angela_domenichelli
angela_domenichelli
Contributor ⭐️⭐️⭐️⭐️⭐️
December 20, 2023

Concatenate function in data Management for more than 1 String

  • December 20, 2023
  • 4 replies
  • 55 views

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

      I
      iwave-ian
      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
      angela_domenichelliAuthor
      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?

      Angela Domenichelli (She/Her/Hers)
        alizee
        alizee
        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

        The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
        angela_domenichelli
        angela_domenichelliAuthor
        Contributor ⭐️⭐️⭐️⭐️⭐️
        December 21, 2023

        Very helpful, thank you @alizee

        Angela Domenichelli (She/Her/Hers)
        Terms & ConditionsAccessibility statement