You need to sign in to do that
Don't have an account?
Nathan S.ax891
Checkbox values in Email Templates
Hi Everyone,
What we are trying to achieve is to have a checkbox return a value other than "0" and "1", whether it be the field name, or a custom string of text, either would work. Does anyone know if this is possible? As far as I know, operators cannot be used in email templates?
Thanks for any advice
There are a couple of option:
1. You can fceate a formula field on your Object that is the value you want to display. You can then include that field in your email template. For instance, I used:
IF(Checkbox__c==True, "The Checkbox is checked", "The Checkbox is not checked")
2. You can create a Visualforce Email Template and include the checkbox. The field should be listed as "true" or "false"
Hope this helps.
Jay
Hi Jay,
Thanks for the advice, it worked out quite well :)
-Nathan
We are facing the same issue, but the business actually wants to see the checkmark shown in the template when the value is true, is this possible?
If so, how would one accomplish this?
I am trying to write a formula on my object like you described. Here is my formula:
IF ( Spanish_Speaker__c == true, "Spanish Speaker", "English Speaker" )
However when I check the Syntax I receive this error:
Error: Formula result is data type (Text), incompatible with expected data type (true or false).
Correct me if I am wrong, but I thought the point of this formula was to output text and not a boolean number. Can anyone see what I am doing wrong?
For example, a checkbox value of '1' would map to a custom image, and '0' would map to another one.
Just tried this today and it works! Although you will likely need to whitelist your Salesforce servlet ([yourSfdcDomain].force.content.com) or gmail will break the images.
Not sure how to guarantee functionality for external facing emails
- Checkbox Field: {!IF(ObjectName.Checkbox_Field__c, 'Yes', 'No')}
The trick is not to use "==True" or you will get no output. No need for extra formula fields on the object though if you just want the information in an email.