Skip to main content
Topics#EmailSophie Ritzman の質問
Sophie Ritzman (Cloudbase) が「#Email」で質問
2014年4月22日 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 件の回答
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2014年4月22日 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
        )
    }
回答を記入...
0/9000