You need to sign in to do that
Don't have an account?
JamieT
Referencing Documents with the Image function???
Hi There,
I have a bank of images that I will be uploading to Documents in sfdc. I will then be creating a Image formula field in a Custom object, where I would like to source the correct Image based upon certain parameters. These will more than likely be based on infor captured in 2 Text fields.
Is there any way to do this without having to specify the unique URL for each seperate Image/Document in the custom formula field? Could you reference the correct image based upon the name of the Document and a keyword or similar?
Any help will be much appreciated!
Thanks
J
I have a bank of images that I will be uploading to Documents in sfdc. I will then be creating a Image formula field in a Custom object, where I would like to source the correct Image based upon certain parameters. These will more than likely be based on infor captured in 2 Text fields.
Is there any way to do this without having to specify the unique URL for each seperate Image/Document in the custom formula field? Could you reference the correct image based upon the name of the Document and a keyword or similar?
Any help will be much appreciated!
Thanks
J
JamieT wrote:
Hi There,
I have a bank of images that I will be uploading to Documents in sfdc. I will then be creating a Image formula field in a Custom object, where I would like to source the correct Image based upon certain parameters. These will more than likely be based on infor captured in 2 Text fields.
Is there any way to do this without having to specify the unique URL for each seperate Image/Document in the custom formula field? Could you reference the correct image based upon the name of the Document and a keyword or similar?
Any help will be much appreciated!
Thanks
J
Hi Jamie,
You will have to individually reference the URL's, but you can have it change based on the text fields. You are going to need to run a series of IF statements within your image, so it will look something like this...
IMAGE(IF(AND(Statement 1, Statement 2), "/servlet/servlet.FileDownload?file={Image 1}", IF(AND(Statement 3, Statement 4), "/servlet/servlet.FileDownload?file={Image 2}", "/servlet/servlet.FileDownload?file={Image 3}")), "Image Name")
Good Luck!
Although I believe this is due to be increased in winter '09?
Good luck!