Microsoft Office Forums IF Statements NOT working when the Merge Field is a checkbox

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2019, 01:12 PM
shawn.low@cox.net shawn.low@cox.net is offline IF Statements NOT working when the Merge Field is a checkbox Windows 10 IF Statements NOT working when the Merge Field is a checkbox Office 2016
Novice
IF Statements NOT working when the Merge Field is a checkbox
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 10
shawn.low@cox.net is on a distinguished road
Default IF Statements NOT working when the Merge Field is a checkbox

I have a Word Document that has several "IF" statements.


There are several "IF" Statements that reference a "Merge" field that is a checkbox, so if the checkbox is checked, print this text, if it is un-checked, print this different text.
Here's an example of what I have:


{IF <<Opportunity_Autopay>> = TRUE "Text" "Alternate Text"}


I have tried putting the TRUE in quotes, I've tried it without quotes, nothing is working.
Can you please let me know where I am going wrong in the formula?


Thank you,
Shawn
Reply With Quote
  #2  
Old 09-24-2019, 09:07 PM
macropod's Avatar
macropod macropod is offline IF Statements NOT working when the Merge Field is a checkbox Windows 7 64bit IF Statements NOT working when the Merge Field is a checkbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,653
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

There is no such thing as a mergefield checkbox. If the data source contains a checkbox character, then you need to insert the same checkbox character (not TRUE) into the IF test.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-25-2019, 07:49 AM
shawn.low@cox.net shawn.low@cox.net is offline IF Statements NOT working when the Merge Field is a checkbox Windows 10 IF Statements NOT working when the Merge Field is a checkbox Office 2016
Novice
IF Statements NOT working when the Merge Field is a checkbox
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 10
shawn.low@cox.net is on a distinguished road
Default

Good Morning,


Thank you getting back to me on this.
Please accept my apologies in advance, for what I am sure are dumb questions.
What do you mean when you say "Insert the same checkbox character into the IF Statement"?
The IF statement is looking at a field in Salesforce, in this case, that field is a checkbox. If the checkbox is "checked" then a specific paragraph needs to be included in the document. If the checkbox is not checked, then different paragraph would need to be included.
So what would the IF Statement look like?
(Yes, basically, I'm asking if you can provide me the formula for the IF Statement)


It almost seems easier to change the field in Salesforce to a picklist and use "Yes" & "No", that way I can use the "merge" field in the IF statement.



Please let me know about adding the same checkbox character?


Thank you,
Reply With Quote
  #4  
Old 09-25-2019, 04:05 PM
macropod's Avatar
macropod macropod is offline IF Statements NOT working when the Merge Field is a checkbox Windows 7 64bit IF Statements NOT working when the Merge Field is a checkbox Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,653
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

How are you creating <<Opportunity_Autopay>> and what does it output? Whatever it outputs is what you have to test.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
checkboxes, if statements

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested IF statements not working ckerber Mail Merge 5 08-23-2019 03:01 PM
IF Statements NOT working when the Merge Field is a checkbox Conditional checkbox mailmerge: coding "or" statements within IF statements mtracy16 Mail Merge 3 05-22-2018 02:03 PM
IF Statements NOT working when the Merge Field is a checkbox Field Codes - IF Statements, IncludeText Automatic Numbering RMerckling Mail Merge 1 01-18-2018 11:37 PM
I know nothing about mail merge, but need help with conditional statements briyosa Word 1 03-27-2017 10:17 PM
IF Statements NOT working when the Merge Field is a checkbox Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM


All times are GMT -7. The time now is 03:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft