View Single Post
 
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