Skip to main content
Nintex Community Menu Bar

Drawloop - Quotes Break If Statement

  • March 26, 2021
  • 0 replies
  • 294 views

KB_Admin
Nintex Employee
Forum|alt.badge.img+8

Topic

If the value being merged from Salesforce contains quotations marks, this will break the Microsoft Word IF statement.
 

Instructions

Try using two single quotes instead of double-quotes in the Salesforce data.

1. Manually update the data to be two single quotes.

 

2. Create a formula field to do the logic and formatting and reference this new field in the DocGen Package.

 

Formula fields to remove the double quotes and add two single quotes (From a Text Area Field Type)
SUBSTITUTE( Api_of_Field , """