Solved

Creating a merge field in word that returns Yes or No based upon a Salesforce checkbox field

  • 26 February 2020
  • 2 replies
  • 55 views

Hello ... I have a checkbox field in Salsforce, <<Client_Special_Education>>.  If it is checked, I would like to return Yes on my document.  If if is not checked, I would like to return No on my document.  Here is my Word merge field, but it returns No everytime.  Even when <<Client_Special_Education>> is checked.  

 

IF "<<Client_Special_Education>>" = "1" "Yes" "No"  * MERGEFORMAT

 

 

icon

Best answer by leighburke 26 February 2020, 22:37

View original

2 replies

Userlevel 5
Badge +13

Hi @dag-us ,


 


Checkboxes in Salesforce return true or false as the value, you will need to filter by this.


 


 

This did it!  Thank you so much!

Reply