cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
himes
Nintex Newbie

Conditional Formatting in word document - Null fields

Jump to solution

I am struggling to write an if then statement for a null condition.  Here is what i am trying to do:

 

If all fields have content in Salesforce, show this way:

Attendee Name, Attendee Title 

 

If there is no title in Salesforce, show this way:

Attendee Name 

 

Here is the code I am putting in Word 

<<Attendee_Attendee_First_Name>> <<Attendee_Attendee_Last_Name>> { IF <<Attendee_Title_Form>> = “” “” “, <<Attendee_Title_Form>>” \*MERGEFORMAT}

 

When I run the report - I get this:

First Last IF Title = “” “” “, Title”

 

or if there is no title - I get this:

First Last IF  = “” “” “,”

 

I can't figure out how to write the code in Word.  Any help would be appreciated

 

Thank you,

Karen Himes

Western Energy Institute

Labels: (2)
0 Kudos
Reply
5 Replies
DocFather_Ray
Nintex Newbie

Re: Conditional Formatting in word document - Null fields

Jump to solution

@himes  You need to wrap your field tag in quotes for your statement to work. Try this:

 

<<Attendee_Attendee_First_Name>> <<Attendee_Attendee_Last_Name>> { IF "<<Attendee_Title_Form>>" = “” “” “, <<Attendee_Title_Form>>” \*MERGEFORMAT}

 

If that doesn't work, attach your template and I can take a look.

0 Kudos
Reply
himes
Nintex Newbie

Re: Conditional Formatting in word document - Null fields

Jump to solution

First off - thank you so much for responding!  I put the code in using your suggestion and still get the output with the code in it.  I'm attaching the template and the product for you to take a look at.

0 Kudos
Reply
himes
Nintex Newbie

Re: Conditional Formatting in word document - Null fields

Jump to solution

Here is the product of the template when i run it.

0 Kudos
Reply
Moderator
Moderator

Re: Conditional Formatting in word document - Null fields

Jump to solution

Try this.  You need to insert the text by creating a formula field. 

 

https://www.youtube.com/watch?v=mFs0rbIxz3Y

 

 

Learn how to use word formulas in Nintex Drawloop DocGen® for Salesforce. Want to know more about using Nintex in your organization? Read our full product guide: https://nintex.us/2tfxbob
0 Kudos
Reply
himes
Nintex Newbie

Re: Conditional Formatting in word document - Null fields

Jump to solution

This is EXACTLY what I needed!!  You have opened up so many opportunities for me.  Thank you so much!  It worked perfectly.

 

Thank you,

Very happy DocGen user,

Karen

0 Kudos
Reply