Contributor ⭐️⭐️⭐️

New Idea

Enhance Concat formula to allow other field types

Forum|Forum|8 years ago
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!

nitisha_rathi

Expert ⭐️⭐️

Hi Nate,

Are you populating the latest update in C360 or is there any other criteria you are using to determine the important activities?

N

nate_newbykewAuthor

Contributor ⭐️⭐️⭐️

Hi Nitisha,

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.

hiromi_yamamoto

Contributor ⭐️⭐️

I also need concat formula to allow Numeric type fields!

davebrown2242

Helper ⭐️

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.

DB

kevin.olayta

Contributor ⭐️⭐️⭐️

+1 we are in NXT but we still don’t have the ability

K

kumaranbcak

Contributor ⭐️⭐️⭐️⭐️⭐️

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.

Muthu Kumar Karuppiah

narayanan_s

Contributor ⭐️⭐️⭐️⭐️⭐️

+ :100:

Narayan

cmultanen

Helper ⭐️

+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.

mindy

Helper ⭐️

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.

Didn't find what you were looking for?

Sign up

Welcome to the Gainsight Community