Skip to main content
Hello!

 

I am looking to create a process builder that does the following:

 

When either the 'Last CSM Activity Date__c' or 'Sales Rep Last Acitvity Date__c' are updated/changed on the Account object, then update the related Customer Info object 'Comments__c' field with the following:

 

Last AM/AE Touchpoint = {Sales Rep Last Activity Date__c} - {Sales Rep Last Activity__c} | Last CSM Touchpoint = {Last CSM Activity Date__c} - {Last CSM Activity Type__c}

 

How would I put the above into a concatenated formula field?
4 respostas
  1. 11 de nov. de 2020, 20:36
    Hi Brittney,

     

    Try this:

     

     

    "Last AM/AE Touchpoint =" + " " +

    TEXT([JBCXM__CustomerInfo__c].JBCXM__Account__r.Sales_Reps_Last_Activity_Date__c) + " " + "-" + " " + [JBCXM__CustomerInfo__c].JBCXM__Account__r.Sales_Reps_Last_Activity__c + "|" + "Last CSM Touchpoint =" + " " + TEXT([JBCXM__CustomerInfo__c].JBCXM__Account__r.Last_CSM_Activity_Date__c) + "-" +

    [JBCXM__CustomerInfo__c].JBCXM__Account__r.Last_CSM_Activity_Type__c

    If that doesn't work, could you please tell me what type of fields are those?

     

    Regards,

     

    Jayson

     

     
0/9000