Skip to main content
nate_newbykew
Contributor ⭐️⭐️⭐️
February 13, 2018
New Idea

Enhance Concat formula to allow other field types

  • February 13, 2018
  • 15 replies
  • 248 views
We populate some of our Timeline entries' fields into sections of the CS360 page so that users with Shared 360 access and those not wanting to dig through the weeds can easily see the most important updates. It would be helpful to pull the Activity Date into the front (or back) of those updates so that the users could know when the entry was posted.

Currently, the Concat formula in the Transformation task type only allows for String fields and I'm not seeing a way to convert a date or numeric field so that it would be able to be entered there.

Thanks!

      15 replies

      Show previous replies
      HollySimmons
      HollySimmons
      Helper ⭐️
      March 22, 2022

      This really should be basic functionality, concatenating dates, numbers and text is incredibly useful. 

      anirbandutta
      anirbandutta
      Expert ⭐️
      March 23, 2022

      @gopal_rao_kallepu could you pl revise the latest status with this one?

      It's an opportunity for engagement
      Intuitive_Geneva
      Intuitive_Geneva
      Contributor ⭐️⭐️⭐️
      July 15, 2022

      We are in need of this feature or a workaround as well in NXT. Trying to tie a string field to a number field via rules or Data Designer 

      benwanlessmenlo
      benwanlessmenlo
      Contributor ⭐️⭐️⭐️⭐️⭐️
      September 6, 2022

      This would be very nice to have as the current workaround is pretty laborious.

      We have a separate MDA object used exclusively for Date conversions. This way we join this table on a specific Date field then select what string values are needed (i.e. Date as String, Month Name, Day of the Week, Fiscal Year, etc.)

      Best,

      Ben Wanless

      rakesh
      Gainsight Employee ⭐️
      rakesh
      Lets put your data to work!
      September 7, 2022

      We did release Data Type conversions feature in Data Designer which would make concatenating the date and string really easy.

        Terms & ConditionsAccessibility statement