Enhance Concat formula to allow other field types
None
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!
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!
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Are you populating the latest update in C360 or is there any other criteria you are using to determine the important activities?
Currently we're just pulling the latest update but I'm planning on implementing a flagging system to call out the important ones (something simple like a checkbox or drop-down select). Then we would append the Activity Date to the comments.
This is not implemented?! Maybe only in NXT? I have this exact issue today in SFDC Edition. Opening a new Idea on this one to vote up. Huge hindrance that I cannot leverage Numeric or Date fields in Concat Transformations.
+1 we are in NXT but we still don’t have the ability
Yeah, this will be a feature that makes the life of a Gainsight Admin/Developer really easy. I believe this is something basic that the Concat feature must be enabled between all the field types. I should be able to concat a numeric field with a date field, or a string field with a date field. It will be easy when we send the data to any downstream applications.
+
+1, we are in NXT but do not have this ability. For example, I want to be able to concat a numeric value that we use for Week to create a new string, Week 0, Week 1, Week 2, etc but currently cannot do this without creating a new String field and then using Rules Engine.
Why does this say “Partially Fixed”? What part of this is fixed…?
We either need this implemented or this request that allows you to change data types. I’ve had multiple scenarios just in the past month where I want to concat with a date field but can’t and there are no good workarounds.
This really should be basic functionality, concatenating dates, numbers and text is incredibly useful.
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
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
We did release Data Type conversions feature in Data Designer which would make concatenating the date and string really easy.