looking for help with a formula on a visual force email template. I have formula working but I only want the result to appear in the template

Question

looking for help with a formula on a visual force email template. I have two different fields. If the first field is populated, then display the value else display the value of the second field. I have the formula working but unfortunately, the text of the formula is also appearing in my email template. The two field names are QN_Customer_Complaint_lu__r.external_id__c (which is actually a lookup to a field on the case object) and QN_Customer_Complaint__c.

Here is the text of the formula: !IF(NOT(ISBLANK(!relatedTo.QN_Customer_Complaint_lu__r.external_id__c)), {!relatedTo.QN_Customer_Complaint_lu__r.External_ID__c}, {!relatedTo.QN_Customer_Complaint__c})

How do I get the result of the formula to show up without the actual formula appearing?

Deepak K Anand · Accepted Answer

Try this =  {!IF(NOT(ISBLANK(relatedTo.QN_Customer_Complaint_lu__r.external_id__c)), relatedTo.QN_Customer_Complaint_lu__r.External_ID__c,relatedTo.QN_Customer_Complaint__c)}

Greg Banks · Answer

thank you so much for the extremely fast response. That eliminated my syntax error. One more question, if I may. The field I am checking for content, it is obviously a lookup field to the case object. There is a field on the case object called external_ID__c. typically, in this case, you replace the __c with __r and then map the api name of the field to display the value of the field. If I use the __c field, then i see the SF ID of the case record but when i map the __r.external_id__c, it shows nothing. I do not get an error.. any ideas?

looking for help with a formula on a visual force email template. I have formula working but I only want the result to appear in the template

Data Management

Aprendizaje relacionado

Más ayuda