Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-01-2017, 01:12 PM
aronfromct aronfromct is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: May 2017
Posts: 4
aronfromct is on a distinguished road
Cool “nested” IF/Then with Mergefield, utilizing Conga and Salesforce links.

Hi,

I believe I am trying to do a “nested” IF/Then with Mergefield, utilizing Conga and Salesforce links.

I am able to display images using the following.
{ MERGEFIELD IMAGE:Slideshow3_URL:W=250 \* MERGEFORMAT }
{ MERGEFIELD IMAGE:Bedroom_Generic_URL:W=250 \* MERGEFORMAT }

However, I want to display one image when one criteria is met, and the other image for all other times. I have tried a few things but it doesn’t work for me. When testing, I am copying all text to the right of ‘IF’ and entering it in an If statement. If it matters, I am using Word on a Mac, though I do have access to a PC. Any ideas would be helpful...specific instructions would be great as I am a bit new to this.

Test 1.
If Apartment_Record_Type__c=“Third Party Unit” “IMAGE:Bedroom_Generic_URL:W=250” “IMAGE:Slideshow1_URL:W=250”


Error! Unknown op code for conditional

Test 2
If Apartment_Record_Type__c = “Third Party Unit” “«IMAGE:Bedroom_Generic_URL:W=250»” “«IMAGE:Slideshow1_URL:W=250»”
Displays as «IMAGE:Slideshow1_URL:W=250»

Test 3
IF {Apartment_Record_Type__c = “Third Party Unit” { MERGEFIELD “IMAGE:Bedroom_Generic_URL:W=250” } { MERGEFIELD “IMAGE:Slideshow1_URL:W=250” }}
Displays as Mergefield.

Thanks,

Aron
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel data from salesforce excelstone Excel 1 11-07-2015 01:11 AM
Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Links need to be Hot links in Bibliography in Word 2010, 2013 synses Word 1 11-23-2013 12:48 AM
SUM a single mergefield kawirider88 Mail Merge 1 09-29-2013 06:37 PM
Business Contact Manager not loading, instead it's Salesforce RobinE Outlook 5 09-18-2012 04:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:21 AM.


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