Apex Code Development You need to sign in to do that
Don't have an account?
stilljustbig Image formula - How do I change an image field to a different image based on the date
Hey There,
I have this basic image field "Status Detail Color" that will display an image based on my case "Status Detail". It is working great, but there are two date fields that also determine what this image should be. I need the formula below to show a different image
IF "Date Scheduled" and "Date Re-schedled" are blank
and a different image if "Date Scheudled" or "Date Re-scheduled" are not blank
Any suggestions?
IMAGE(
CASE( Status_Detail__c,
"Waiting Estimate Tech","/servlet/servlet.FileDownload?file=01560000001Gmx8",
"Waiting Tech", "/servlet/servlet.FileDownload?file=01560000001Gmzx",
"Scheduled", "/servlet/servlet.FileDownload?file=01560000001GmxD",
"Waiting Part", "/servlet/servlet.FileDownload?file=01560000001Gmx3",
"Waiting Client", "/servlet/servlet.FileDownload?file=01560000001Gmx3",
"System Down", "/servlet/servlet.FileDownload?file=01560000001Gmwy", "Bid Due Waiting Office","/servlet/servlet.FileDownload?file=01560000001GmxI",
"Waiting Estimate Office", "/servlet/servlet.FileDownload?file=01560000001GmxI",
"Bid Inspection Assignment", "/servlet/servlet.FileDownload?file=01560000001GmxN",
"Connect Tech & Customer", "/servlet/servlet.FileDownload?file=01560000001Gmx8",
""),"Pending")
try this code CASE( Status_Detail__c, "Waiting Estimate Tech"," IMAGE("/servlet/servlet.FileDownload?file=01560000001Gmx8", "Flower", 300, 300), "Waiting Tech", IMAGE("/servlet/servlet.FileDownload?file=01560000001Gmzx", "Flower", 300, 300), "Scheduled", IMAGE("/servlet/servlet.FileDownload?file=01560000001GmxD", "Flower", 300, 300), "Waiting Part", IMAGE("/servlet/servlet.FileDownload?file=01560000001Gmx3", "Flower", 300, 300), "Waiting Client", IMAGE("/servlet/servlet.FileDownload?file=01560000001Gmx3", "Flower", 300, 300), "System Down", IMAGE("/servlet/servlet.FileDownload?file=01560000001Gmwy", "Flower", 300, 300), "Pending")