-
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.
Popular Salesforce Blogs
Best Books to Prepare for Salesforce Certification
Salesforce is a cloud-based platform that allows you to create and manage cloud-based apps with high flexibility. This platform is primarily intended for businesses and enterprises,…
Automate Salesforce Data Import/Export Using Data Loader CLI
One of the key facets of Salesforce is import and export data from salesforce. Data loader is a great tool provided by Salesforce to achieve…
FlexDeploy Loves Salesforce: Source Control Your Salesforce Changes
FlexDeploy is an Enterprise DevOps platform with fully integrated support for Salesforce apps, metadata customizations, integrations and more. This is the second article in a…
Popular Salesforce Videos
How to Test Your Process Builder | Salesforce
In this video, Appopedia provides helpful tips on how to test your process builder in Salesforce. She explains how to create a test user, what…
How to Use Salesforce Process Builder 2017
Salesforce process builder is a powerful tool you can use to automate business processes. It has a simple interface that allows you to point and…
Build Multi-Column Screens in Flow Builder - Spring'21 feature for the Salesforce Screen Flows
Build Multi-Column Screens in Flow Builder (Pilot) You can divide each flow screen into multiple sections and columns to create a visually appealing and effective…
