+ Start a Discussion
netTrekker_ADnetTrekker_AD 

Formula for a Dynamic Product Logo Field

I read an old 2006 Salesforce PDF about dynamic images using IF or CASE functions but I still cannot get this to work. Where am I wrong?

 

Depending on the Product Name, I want the image (stored in the Documents) of its logo to appear.

When I check syntax, it tells me Error: Syntax Error found "netTrekker". Can I not use the CASE function with Product Names?

 

 

IMAGE( CASE( Name) , 
netTrekker d.i., "servlet/servlet.FileDownload?file=015Q0000000DFhU", 
WRE, "servlet/servlet.FileDownload?file=015Q0000000DFhP",
BPoP, "servlet/servlet.FileDownload?file=015Q0000000DFhK", 
BPoP ESP, "servlet/servlet.FileDownload?file=015Q0000000DFhK", 
BPoP Jr, "servlet/servlet.FileDownload?file=015Q0000000DFhK",
Canada-nT, "servlet/servlet.FileDownload?file=015Q0000000DFhU",
UK nTdi, "servlet/servlet.FileDownload?file=015Q0000000DFhU"), 
"Logo")

 

 

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

Product.Name is a Text field, you need to put quotes around each Product Name value that you are testing for.  

 

https://na3.salesforce.com/help/doc/en/customize_functions.htm#CASE

All Answers

SteveMo__cSteveMo__c

Product.Name is a Text field, you need to put quotes around each Product Name value that you are testing for.  

 

https://na3.salesforce.com/help/doc/en/customize_functions.htm#CASE

This was selected as the best answer
netTrekker_ADnetTrekker_AD

Thank you again Stevemo.

 

Please check private messages