Skip to main content
Topics#EmailDomanda di Sophie Ritzman
Sophie Ritzman (Cloudbase) ha fatto una domanda in #Email
22 apr 2014, 19:14

need help with an ISBLANK formula

Can someone help me fix this formula for a Visualforce email template please?  Trying to add first name for the contact if there isn't a spouse...so it would be 'contact first name', but if there is a spouse... then want to address 'contact first name & spouse first name'

 

{!

 

    IF(

 

        ISBLANK(relatedTo.Contact__r.First_Name__c),"Contact__r.FirstName",

 

        TEXT(relatedTo.Contact__r.FirstName) + " & " +

 

        TEXT(relatedTo.Contact__r.Spouse_First_Name__c)

 

    )

 

}
1 risposta
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    22 apr 2014, 19:21
    How about this one:

     

    {!
        IF(
            ISBLANK(relatedTo.Contact__r.Spouse_First_Name__c),
            relatedTo.Contact__r.FirstName,
            relatedTo.Contact__r.FirstName + " & " +
            relatedTo.Contact__r.Spouse_First_Name__c
        )
    }
Scrivi una risposta...
0/9000