"Dear {!Contact.FirstName} and {!Contact.Partner_Name__c};
You are invited ... "
Naturally, I don't want the "and" between the Contact's name and the Partner's name to be visible when the Partner name field is blank. And, I would want the ";" to appear straight after the Contact's name.
Is this possible?
Thanks,
Jackie
답변 11개
One more try :
Dear {!if(ISBLANK(Contact.Partner_Name__c),Contact.FirstName,Contact.FirstName & "and" & Contact.Partner_Name__c)};
If abpve doesnt work,Could you try one more thing?How about creating formula field which returns a text using the above formula simple and use this in merge field:
if(ISBLANK(Contact.Partner_Name__c),Contact.FirstName,Contact.FirstName & "and" & Contact.Partner_Name__c)