I have a custom formula field that shows an image using static resources. The resource to use is build using a field of the record:
IMAGE('/resource/ImagesProducts/'+ ProductCode +'.jpg' , 'MyImage' )
In this way I show the correct image of a product. But I haven't an image for each product. So I need to check in the formula that the resource
'/resource/ImagesProducts/'+ ProductCode +'.jpg'
exists. If true I want to show the image, otherwise I want to show a text such as 'No image found'.
Is there a way to achieve this? I've tried to use the IF formula, but I couldn't find a way to build the logical test. I've also checked the URLFOR function but it cannot be used in the formula fields! :(