Apex Code Development You need to sign in to do that
Don't have an account?
roni shore Formula field using IMAGE
Hi guys,
I am using a formula to show an image based on picklist values, its coming correct but if I modify the formula to accommodate one more picklist values the formula saves but doesn't show the image. plz suggest
formula
======
This works fine
CASE(Lost__c,"Old",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"), "False"),NULL)
if one more picklist val added the image doesn't show
CASE(Lost__c,"Old","","Lost-Z6",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"), "False"),NULL)
I am using a formula to show an image based on picklist values, its coming correct but if I modify the formula to accommodate one more picklist values the formula saves but doesn't show the image. plz suggest
formula
======
This works fine
CASE(Lost__c,"Old",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"), "False"),NULL)
if one more picklist val added the image doesn't show
CASE(Lost__c,"Old","","Lost-Z6",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"), "False"),NULL)
CASE(Lost__c, "Old",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"),"False"), "Lost-Z6",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"),"False"), NULL)All Answers
CASE(Lost__c, "Old",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"),"False"), "Lost-Z6",""&" "&IMAGE((LEFT($Api.Partner_Server_URL_260, FIND('/services',$Api.Partner_Server_URL_260))+"resource/1247929509000/lost"),"False"), NULL)