Skip to main content
jeffrey_coleman
Helper ⭐️
Sep 22, 2015 3:10 AM UTC

Rules engine update ideas: Post to Chatter and Concatenate

I've been building new rules to automatically provision accounts in Gainsight.The "Load to SFDC Object" action is really very useful!

But in doing that I've figured out 2 places where it's falling short:

1) I want to be able to build up a text string. Just like I do in the comments of CTA, I need to build up a string for a description or title. Right now I can only use a field I was able to get into the query. So back under Setup Rule, I'd love to be able to bring together multiple fields and static text to create a field I could then make use of.

2) I want to post to Chatter. In this particular instance, I'd like to post an update to the case I just created for the onboarding team. Ideally after creating a new record, the new record ID would be appended as an additional column in the results set. Then I could use that in the following action and post to that record's Chatter feed.

Both of these are easily achieved using Flows, but I'd love to keep all the logic in one place!

    17 replies

    sundar
    Expert ⭐️
    May 15, 2017 2:15 PM UTC
    We are planning to introduce a formula field option in Transformation task (A.K.A Aggregate task) in Bionic rules where you will be able to concatenate the string. This is in roadmap, will keep you updated on the ETA
    Translate
    kraig
    Contributor ⭐️⭐️⭐️⭐️⭐️
    May 15, 2017 6:05 PM UTC
    Thanks Sundar.  Can you comment on the estimated timing (months, years, etc.)? We're trying to decide if we can hold off, or if we need to find another solution now. Feel free to email me directly if you prefer. Thanks!
    Translate
    sundar
    Expert ⭐️
    Jun 15, 2017 4:44 AM UTC
    This is part of our Fall release (Nov'2017) approx. I'll keep you posted on when the work starts on this. 
    Translate
    kraig
    Contributor ⭐️⭐️⭐️⭐️⭐️
    Jun 15, 2017 10:14 PM UTC
    Thank you Sundar.  We are anxiously awaiting this functionality.  If you need/want to understand our specific requirements in more detail, please don't hesitate to reach out to me.  
    Translate
    jeffrey_coleman
    Helper ⭐️
    Sep 28, 2017 5:56 PM UTC
    Is it funny or sad when you go searching Google for how to concatenate in a bionic rule and find your own post? :-)

    Can't wait for the Fall update!
    Translate
    jahnavi
    Contributor ⭐️⭐️⭐️⭐️⭐️
    Nov 21, 2017 1:26 AM UTC
    is this  available in Sandbox now ? I would want to concat a date and string field to string field. Eg: Date: 11/20/2017, String=2 days, Output: 2 days, 11/20/2017
    Translate
    jitin_mehndiratta
    Helper ⭐️⭐️⭐️
    Nov 21, 2017 11:02 AM UTC
    Jahnavi,

    You will be able to concatenate only string fields as of now. Date fields cannot be concatenated.

    Regards,
    Jitin
    Translate