-
Conga Solution : Need to update the field dynamically in the conga email template
I had a “Reserve field” in the salesforce Object , So when the field is not filled , Instead of showing Blank in the email template , need to show “TBD” . Need to satisfy two conditions. 1) it should show “TBD” if the Checkbox “No Reserve” or “Reserve price” is not selected 2) It should show the amount if “Reserve Price” is selected. I had this condition. Can someone fix this formula which should be put in the template.
IF( No_Reserve__c || Reserve_Price__c > 0
, IF(No_Reserve__c ,’NO RESERVE’, TEXT(Reserve_Price__c))
, ‘TBD’) -
1 Reply
-
Hi
For this, you can look into the below two Conga Support links
How to Compare Two Values in Word Templates using IF Statements
How to Create IF Fields in a Microsoft Word Template
Or you can build a custom formula field on salesforce side and then use that in your template.
Hope this helps you.
Log In to reply.
