Questions tagged [image-formula]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
111 views

Formula field adds amp; after the & character

I have the following issue. I would like to create a lot of survey invitations at once, and generate for them QR code to patient which will receive the survey by post will have possibility to scan and ...
Qba2312's user avatar
  • 11
0 votes
2 answers
42 views

Existing days in stage formula, but need it to differentiate between Record Types

We have an existing "days in stage X" formula for Opps that works, but I need to wrap it so that it runs one calculation or a second calculation based on record type, so basically If Record ...
Radi0raheem's user avatar
0 votes
0 answers
99 views

How to show QR Code in Custom field

I created a QR Code Using LWC. It works well when I show the QR Code on an HTML page. Now I want to show that QR code which is generated via LWC in a custom field (It can be formula or Rich text area) ...
Suriya Jaisankar's user avatar
0 votes
1 answer
26 views

Formula field to define FCR met or Not Met

trying to build a formula field to define FCR and my formula always turns wrong. The first part works correctly however I'm receiving an error : Field Reason_for_Reopen__c is a picklist field. ...
B Hassine Qais's user avatar
0 votes
2 answers
347 views

Display qr code image from formula field in LWC

I have this formula field that shows the generated qr code on the record detail page: IMAGE('https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=https://www.yahoo.com' ,'QR code to open ...
mackmama's user avatar
  • 709
-1 votes
1 answer
225 views

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

IF( LastActivityDate < DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY())) - 30, IMAGE("/img/samples/flag_green.gif", "green"), IF( LastActivityDate > DATE(...
Shirley's user avatar
1 vote
1 answer
827 views

Is there way to programmatically obtain URL of File related to sObject?

This is for my pet project. I have a Candidate object and image from related files should be displayed on it's record page. I know that it is possible to display image using formula field, but for ...
dobra_wodka's user avatar
-1 votes
1 answer
2k views

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

I am trying to create a formula to show a red flag if a checkbox field is set to True This is the current formula (IF("Response Timer Failed" = TRUE, IMAGE("/img/samples/color_red.gif&...
asidrey's user avatar
  • 79
1 vote
0 answers
166 views

How to properly adjust width and size to image rendered with apex:outputField

I am developing a visualforce renderAs pdf. One of the requirements is to show a couple of images stored in formula fields in Product2 objects (formula using IMAGE()). This means that querying those ...
joacoiudica's user avatar
0 votes
1 answer
323 views

svg image in a formula field not aligned to the left

I have a formula field on which I am displaying a svg image using the IMAGE function. I have no issues displaying the image, but the image displayed is not left aligned. Here is formula I am using in ...
sumchans's user avatar
  • 777
1 vote
1 answer
52 views

Render Images from Formula - Not Image address

This formula is doing everything that I want except showing the actual Image on the field. Instead it shows the image address. IF( AND(ISPICKVAL(Asset.LBS__c, 'Active'),ISPICKVAL(Asset.Swap__c, '...
Quango Bruce's user avatar
0 votes
2 answers
675 views

Formula for showing flags based on a number field

am fairly new to Salesforce and do not come from a technical background so struggling with Formulas. I am trying to achieve the following logic; If the NPG Triage Result Code is 5, 7, 9, 21, 99 then ...
asidrey's user avatar
  • 79
-1 votes
1 answer
169 views

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

I am trying to create a formula, this is the on I am working on. The first IF statement is working OK but the other two are not. The logic required is; Additional Formula : Existing formula + Yellow ...
asidrey's user avatar
  • 79
-1 votes
1 answer
2k views

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

I have a hyptothetical formula (in pseudocode): if (XXX_field is empty): return 100 And I will change it to return 200 When should I see changes in that field? (200 instead of 100) Only after ...
NonameJavaNoob's user avatar
0 votes
1 answer
49 views

Can't pull a string for apex:image

My client has a 'technical document' which shows you some data about their product, I created a button that gather these information and creates a page and it's all working fine. But depending on what ...
tr1v's user avatar
  • 29
0 votes
1 answer
564 views

How to resolve extra margin added in formula field with multiple images?

Here's a sample formula field called Icons IMAGE("/img/samples/color_red.gif", "Red",20,20) + ' ' + IMAGE("/img/samples/color_yellow.gif", "yellow",20,20) + ' ' ...
Shamina's user avatar
  • 4,245
0 votes
1 answer
934 views

Increase size of an image formula field

Hi all I have written a formula field Flagstatus which updates each time a choose a picklist value from the picklist field flag.The red flag is displayed when I choose red in the picklist and so on.. ...
user110290's user avatar
0 votes
1 answer
29 views

Formula Field issue1

I need to write a formula where if some conditions are true it should display one image and if the same conditions and an added one is true it should display another image. So far I have this but ...
user107526's user avatar
0 votes
1 answer
2k views

Get label instead of API name in salesforce formula

I am trying to add image plus text value to a field in the case object. In the below formula I am adding an icon based on the Type picklist value chosen and also at the end appending the label of the ...
Sumesh Chandran's user avatar
0 votes
2 answers
1k views

How to change image url to Image Logo in rich text custom field.?

I need help to understand how to change the URL value to the image logo. I have a custom field called image URL datatype (RichText), I would like to convert my image URL to an image logo. can you ...
Mr.shahi's user avatar
0 votes
1 answer
330 views

Help with nested IF statement with images

I have a field "Account__r.Commission_Rate__c" and depending on the value of this % field, I want to show a coloured flag. If the % is 0-5, the red flag needs to display. If the % if 5-10, ...
1918721's user avatar
0 votes
0 answers
498 views

I'm trying to implement a case flagging formula but sometimes the flags work sometimes it does not for some records

As seen on the image some of records has flags and some are not even though there is a value on SLA Category and Case Age. Here is my formula: IF( (OR( AND(TechSLACategory__c=1, ...
Sherwin Mier Betonts's user avatar
1 vote
1 answer
205 views

How to add a letter next to an Image in a formula field for Color Blind users?

On a related list, the risk is shown as a red, orange or green flag. We can have multiples records. This is an issue for users that are color blind as they cannot see the difference between the lines. ...
Ludivine Jobit's user avatar
0 votes
1 answer
786 views

Include Image and Text in Formula Field using Number Field as Condition

So I have an NPS object setup and one of the items (Text field) is based on the NPS score, either 1 of 3 images will show and this works fine example: Basically I am trying to have it show the image ...
Craig Phoenix's user avatar
0 votes
1 answer
484 views

Image formula field render issue

I have a formula that is rendering a static resource based on checkboxes on my Contact record. The issue I am seeing is that when the image loads, it appears super tiny - the static resource is not ...
Geo's user avatar
  • 205
0 votes
2 answers
608 views

Profiles and Image Formula Fields

I had to create a profile that was significantly more restricted than any of our other profiles. In the process of creating this profile, I have ended up causing an important formula field with an ...
thinker's user avatar
  • 1,432
0 votes
1 answer
173 views

Displaying Custom Product image on Opportunity

I have created a formula field that displays an image if a product has gone "End Of Life" this is based on a date field that is managed on the Product Object. This is also displayed on the ...
Quango Bruce's user avatar
1 vote
2 answers
188 views

Workflow - Error - Visualforce email template - External image

I'm getting a weird error when trying to use my workflow to send out a visualforce email template. The visualforce email template generates a PDF attachment (from VF component) and works fine when I ...
James Wargent's user avatar
1 vote
1 answer
3k views

Get base64 of image from rich text field

My question is about rendering image using its base64 instead of src attribute. I have a rich text field where users can attach images. I am displaying these images in a visualforce page. How can I ...
Illusion's user avatar
  • 185
6 votes
0 answers
4k views

Can Lightning SLDS icons be displayed in formula field without using static resources?

I want to display an icon in a formula field based on the value in another checkbox field on my object. I would like to use the standard Lightning SLDS icons here. I've found a way to achieve this ...
Aislinn Hayes's user avatar
0 votes
1 answer
2k views

Image from static resource not working in formula

I have few images (Star01, Star02...etc) Which i clubbed to a Folder called StarsImg, Then i zipped this folder (Name of zipped File is same StarsImg). Now i have uploaded this zip file as Static ...
Dnyaneshwar's user avatar
0 votes
2 answers
889 views

How to sort formula showing Image in List View

I have a simple formula field in salesforce which show particular image based on another picklist, as below. IMAGE(IF(ISPICKVAL(Rating__c,"1 Star"), "/img/samples/stars_100.gif", IF(ISPICKVAL(...
Dnyaneshwar's user avatar
1 vote
1 answer
1k views

Image Formula and If Statements

I had an image formula field running off a picklist that had fixed values 1,2,3,4,5. The formula worked and showed a red, amber, green, light blue, or dark blue image respectively. To make the ...
Rebecca's user avatar
  • 57
1 vote
2 answers
3k views

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

There seem to be several way to add an image to a Product2 object: Add a rich text field Upload image to documents and then add the URL for the image to Product2 and use a formula text field to ...
Joseph Nardone's user avatar
1 vote
1 answer
4k views

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

What I have tried : 1) I already have a Campaign Member custom field (Using Formula Text) showing QR code on the detail page tied to their respective Campaign Member Id E.g. IMAGE('http://api....
compski's user avatar
  • 1,352
1 vote
1 answer
4k views

Image formula field in lightning do not display images,

I have a lightning component to display a image formula field in the lightning app and Community. when added this field to the lightning app image is not rendering instead it just displaying the html ...
Aman's user avatar
  • 159
0 votes
1 answer
1k views

How to Show Profile Pictures to their Corresponding contact record

I want to display Contact User Picture In Page Layout. How Can I call Image Id automatically in Contact formula. I tried this logic but its only works for one record. IMAGE("/servlet/servlet....
Maddy's user avatar
  • 11
1 vote
2 answers
1k views

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

I would like to change the entire background color, or place a background image on all layouts of the account object based on a value in a custom field in said object. The use-case here is I want ...
Kay Dastgheib's user avatar
0 votes
1 answer
1k views

IMAGE Function not displaying image in field (previously worked)

I have a formula field that makes use of IMAGE function to show an image from a url. It goes like this: HYPERLINK(URL__c , IMAGE( URL__c , "Photo unavailable", 400, 400)) The image itself doesn't ...
Jay Bolt's user avatar
  • 143
3 votes
1 answer
228 views

Apex not saving Dashboard Image

I have tried this codes but the image is still not being save into the file in the Document Folder. Can anyone help me fix my code so that it can save an image? Apex Class public void send(){ ...
Luke Au's user avatar
  • 179
1 vote
1 answer
1k views

Dashboard URL and Apex code on converting Dashboard into an image

I know I already ask on how to convert the Dashboard into an image about a week ago. But that code isn't working for me. All i getting from that code is a blank image rather then an image of the ...
Luke Au's user avatar
  • 179
1 vote
1 answer
2k views

Using Apex Codes to Save an image of the Salesforce Dashboard at certain time

I need help with creating apex codes for a scheduler to save an image of my company's dashboard once everyday into the Salesforce document folder. From This post here I understand you can get an ...
Luke Au's user avatar
  • 179
0 votes
2 answers
446 views

Tiered Case Priority and Response Time Formula

I have a formula to measure SLA response times, however it doesn't seem to be filtering based on priority as it's intended. It only seems to filter as if Priority is Low on the case, or just always ...
Marc Swan's user avatar
1 vote
1 answer
112 views

Name-Based Formula IMAGE Reference

Is it possible to refer to an IMAGE in a FORMULA by 'name' instead of ID? Just in formulas - not Apex, not VF, etc. IMAGE( "/servlet/servlet.FileDownload?file=" & CASE( TEXT( ...
AMM's user avatar
  • 4,704
0 votes
1 answer
1k views

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

Hi I am trying to make my images from a formula field show up in an exported report. Here is a sample of the image file Note I do have Externally Available Image checked Here is how I see the Excel ...
Nitish's user avatar
  • 331
0 votes
1 answer
2k views

Multiple If statements for a formula field to show images

I am trying to write a formula depending on the count of roll-up summary fields to indicate which color needs to show on the Account object. Here is what I have so far: IF( OR(...
Paul's user avatar
  • 71
3 votes
1 answer
4k views

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

The below formula displays green red or yellow in the field based on the calculation. It works fine in classic view but not in Lightning. I read that as of Winter 15 images were not supported in ...
user8310's user avatar
  • 121
2 votes
0 answers
152 views

Image in related list in salesforce1

I have a related list which displays a image-formula based field i.e. as per the formula it displays different images (icons). This works perfectly in desktop version but in salesforce1 it does not (...
stack_pointer is EXTINCT's user avatar
4 votes
2 answers
795 views

Formula field image BETWEEN numbers

I am having some trouble with a happiness meter formula field based on NPS score in our surveys. Here is what I have so far: IF( NPS__c >= 9, IMAGE("/resource/Misery09", "Promoter"), IF( ...
Allen Mann's user avatar
  • 1,092
1 vote
1 answer
877 views

Show formula field image in Visualforce Site

Image is showing up in internal visualforce page but not showing up in external visualforce site page.I have stored image in document and made it externally available and document folder is accessible ...
sfdc's user avatar
  • 13.7k