Skip to main content
6 votes
Accepted

Image formula field in lightning do not display images,

It appears that the way to render text without HTML-escaping is using aura:unescapedHtml. I have not used Lightning, but I'd assume you need to change your page to (assuming OLRS.StatusBar__c is the ...
IllusiveBrian's user avatar
6 votes
Accepted

Formula field image BETWEEN numbers

Try this IF( NPS__c >= 9, IMAGE("/resource/Misery09", "Promoter"), IF( NPS__c > 7, IMAGE("/resource/Misery05", "Neutral"), IF( NPS__c >= 1, IMAGE("/resource/Misery06", "Detractor"), TEXT(...
Doug B's user avatar
  • 11.5k
6 votes

Is is possible to have an automatic width or height on a photo in an image formula?

Well actually I've found a way doing it! Using -1 as the value for the value you want to be set equivalently to css "auto". e.g: IMAGE(url,"alt text", 100, -1) It will actually make the browser ignore ...
Tzahi Serruya's user avatar
5 votes
Accepted

Increase size of an image formula field

Indenting and formatting your formulas is extremely helpful in finding syntax mistakes or cross-checking with the expected format. In this case, you'll note that CASE expects CASE(expression,value1, ...
Kris Goncalves's user avatar
4 votes
Accepted

Formula filed to display image, works in classic not in lightning

The issue is in lightning the domain value picked up has /one/resource/GreenBar and thats causing the issue not to have your image formula field rendered . Lets work around this with a global ...
Mohith Shrivastava's user avatar
3 votes
Accepted

How to sort formula showing Image in List View

The formula is going to end up being sorted alphabetically by file name. You would necessarily need to prefix the formula with some sort of text that can be sorted. There's absolutely no way to have ...
sfdcfox's user avatar
  • 495k
3 votes
Accepted

Get base64 of image from rich text field

Its better to save base64 encoded value of Screenshot__c field in new field created in myCustomObject__c object so that you can easily get encoded value and pass to visualforce page. For encoding ...
Reshma's user avatar
  • 4,039
3 votes
Accepted

Apex not saving Dashboard Image

You will need to set a valid sid cookie on the request to authenticate it. HttpRequest req = new HttpRequest(); //... req.setHeader('Cookie', 'sid=' + UserInfo.getSessionId()+ ';'); //... Also ...
Daniel Ballinger's user avatar
3 votes
Accepted

Show formula field image in Visualforce Site

To get access to images in SITES, simply add the images into a zip file and save as a public static resource. Reference the static resource using VF markup: <apex:image url="{!URLFOR($Resource....
cropredy's user avatar
  • 71.9k
2 votes

Formula field image BETWEEN numbers

The problem is that in your check on Neutral, you as is the NPS < 8.99 OR > 7. A value of 5 (for example) would be less than 8.99 so the or evaluates true. I would write it this way: IF( NPS__c &...
S Morgan Robertson's user avatar
2 votes
Accepted

Name-Based Formula IMAGE Reference

You can't do this for normal documents, unfortunately. However, you could use static resources, which would look like this: IMAGE( "/resource/imageBundle/" & TEXT(Division_Project__c) & "....
sfdcfox's user avatar
  • 495k
2 votes

How do you make the images from your formula field show up in exported report?

I resolved the same issue. And that was the issue of URL. Copy the Image URL(Right click on Image, open it in new tab and copy URL from address bar) and use it in Formula Field. Formula Field ...
Tejas Kadia's user avatar
2 votes
Accepted

What is the most common way to add an image to Product2?

which is the method most commonly used today? I am not aware of a "most common way", I think it all comes down to what you feel more comfortable with. For example, I highly doubt that most admins ...
glls's user avatar
  • 20.2k
2 votes

How to create dynamic QR Code that opens a URL with dynamic Salesforce unique ID to show in Email Template?

If all you see in your email client is "QR Code" (the image's alt attribute) it sounds like the email client is configured to not download images from external websites. Check if you have a warning ...
eyescream's user avatar
  • 24.1k
2 votes
Accepted

Get label instead of API name in salesforce formula

Your missing a default case on your second case statement IMAGE(CASE( Type, 'Billing', '/resource/CaseIcons/Billing.svg', 'Service', '/resource/CaseIcons/Service.svg', 'Technical', '/resource/...
Kayden Deason's user avatar
2 votes

Trying to create a formula for showing a flag on a field but my forumla keeps showing Error: Syntax error. Missing ')'

Lets start with basic of IF function: IF(logical_test, value_if_true, value_if_false) Nested IF can be written as: IF(logicalCondition1, "value 1", IF(logicalCondition2, &...
Raul's user avatar
  • 18.8k
2 votes

When I would change a formula, then when the value from that formula will change?

Formula fields do not have their values stored, they are calculated on-demand. Every time you query a record in Apex or view a record in a web browser, the formula fields are re-calculated. So there ...
Derek F's user avatar
  • 62.3k
1 vote

Error: Incorrect number of parameters for function 'IMAGE()'. Expected 2, received 3

Your innermost IF statement needs a 3rd parameter IF( LastActivityDate < DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())) - 30, IMAGE("/img/samples/flag_green.gif", "green&...
David Cheng's user avatar
  • 7,091
1 vote

Formula field - Trying to show a flag if checkbox = true

You need to use the field API Name instead of label name (Response Timer Failed) in the formula field. your formula should be like below and the formula return type should be text IF(...
Ankaiah Bandi's user avatar
1 vote
Accepted

svg image in a formula field not aligned to the left

The "Image" function does not have any property related to the position of the image. I would suggest you to kindly the check the image itself, there could be some space on the left of image ...
Mahmood's user avatar
  • 5,954
1 vote
Accepted

Render Images from Formula - Not Image address

You're using a string, not a formula, so you can't just add that on. Instead, try this: IMAGE( IF( AND( ISPICKVAL(Asset.LBS__c, 'Active'), ISPICKVAL(Asset.Swap__c, ...
sfdcfox's user avatar
  • 495k
1 vote

Formula for showing flags based on a number field

tl;dr: Don't try to be fancy. In most cases, you should just stick to the simplest thing that works. So you should stick to the simple IF() approach of your first attempt (comparing to values one at a ...
Derek F's user avatar
  • 62.3k
1 vote

Formula Field issue1

IF statements are evaluated in order, and your second set of conditions will always be met by the first set. You'll need to swap the order of evaluation, nest your statements and have a default return ...
Todd Sprinkel's user avatar
1 vote

Help with nested IF statement with images

If you look at what you get back out of the field, you'll find it's going to be 0.05 for 5%, 0.1 for 10%, etc. It's always red because the value is always between 0 and 5 (it's actually always between ...
Dave's user avatar
  • 244
1 vote
Accepted

Image formula field render issue

I have not seen this but... you can set the image height and width. enter code hereIMAGE(image_url, alternate_text [, height, width])
SeanGorman's user avatar
  • 1,015
1 vote
Accepted

Displaying Custom Product image on Opportunity

What you want is a RSF on Opportunity Opportunity_Product_Expired_Count__c that counts the OpportunityLineItem where the associated Product2 is end of life. Because you can't do RSF on cross object ...
cropredy's user avatar
  • 71.9k
1 vote

Image from static resource not working in formula

First, you need to include the file extension (e.g. .jpg, .gif); the only time you don't do this is when you're referencing the static resource itself (e.g. /resource/ImageFolder represents the static ...
sfdcfox's user avatar
  • 495k
1 vote

What is the most common way to add an image to Product2?

The most common method if you want to securely store the images is to put them in documents and reference the file id in Product2. I think it is safe to assume that Salesforce's recommended method ...
Joseph Nardone's user avatar
1 vote

Conditional background color of the account object based on a custom field?

As far as I know, there is no possible standard way to do this but by developing a set of Visualforces and routing them, but imho, that is an effort far from worth. While not being the same, you can ...
Javier García's user avatar
1 vote
Accepted

Dashboard URL and Apex code on converting Dashboard into an image

/01Z/o is not an URL to any specific Dashboard. Its the URL for Dashboard home page, which in turn opens the recently opened Dashboard using redirection. So hitting /01Z/o in a Rest call will not help ...
Santanu Halder's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible