Questions tagged [image-formula]
The image-formula tag has no usage guidance.
58
questions
-1
votes
1
answer
22
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 ...
0
votes
1
answer
17
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 ...
0
votes
1
answer
33
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) +
' ' ...
0
votes
1
answer
64
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..
...
0
votes
1
answer
26
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 ...
0
votes
1
answer
209
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 ...
0
votes
1
answer
160
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 ...
0
votes
1
answer
125
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, ...
0
votes
0
answers
157
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,
...
1
vote
1
answer
119
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.
...
0
votes
0
answers
71
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 ...
0
votes
1
answer
133
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 ...
0
votes
2
answers
315
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 ...
0
votes
1
answer
110
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 ...
1
vote
2
answers
150
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 ...
1
vote
1
answer
2k
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 ...
5
votes
0
answers
3k
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 ...
0
votes
1
answer
902
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 ...
0
votes
2
answers
570
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(...
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 ...
1
vote
2
answers
2k
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 ...
1
vote
1
answer
3k
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....
1
vote
1
answer
3k
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 ...
0
votes
1
answer
575
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....
1
vote
2
answers
955
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 ...
0
votes
1
answer
941
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 ...
3
votes
1
answer
186
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(){
...
1
vote
1
answer
785
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 ...
1
vote
1
answer
1k
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 ...
0
votes
2
answers
200
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 ...
1
vote
1
answer
75
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( ...
0
votes
1
answer
855
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 ...
0
votes
1
answer
1k
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(...
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 ...
2
votes
0
answers
94
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 (...
4
votes
2
answers
303
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( ...
1
vote
1
answer
779
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 ...
2
votes
1
answer
1k
views
Support Tooltip on the IMAGE Function?
Does the Image Formula field have Alt Text?
IF(Res_Date__c > NOW(), IMAGE("/img/msg_icons/confirm16.png", "All good"))
When the user hover over the Image I want to have a text display in my case ...
1
vote
2
answers
4k
views
Formula Field - Image from zipped static resource
I need some help with a Formula Field (please don't send me visualforce code) image.
I am trying to get the image from a zipped static resource.
BCIGraphics is the zip file.
Here is what I have ...
4
votes
3
answers
3k
views
Profile picture in formula field
I'm trying to get the user's profile picture to display in a page layout through the use of a formula field (image function). But I can't find the profile picture in the user object. Is it possible at ...
0
votes
1
answer
91
views
how to write a formula based on quantity field
i have an requirement , i have field like quantity it is number field and i have a field like batch number it is text field , and i have written a validation rule on batchnumber with regex function ,...
2
votes
1
answer
300
views
Image Formula Field
I am trying to create an image field (Opp) to show one money dollar image if the closed mrc field is between 0 to 100, two money dollar images if its between than $200-299, three money dollar images ...
3
votes
1
answer
1k
views
Display Attachment image in formula field
I have a trigger which updates attachment id into a custom field of object X__c. I have creatted a formula field with below formula to display the attached pic
IMAGE('/servlet/servlet.FileDownload?...
3
votes
1
answer
3k
views
utilising javascript in HYPERLINK function of a formula field
I want to execute this Javascript from the HYPERLINK function in my image formula field. This way I can display an image in a certain circumstance (using IF) and then do something via the Javascript ...
5
votes
1
answer
2k
views
Formula field image not visible from communities
I have a formula field displaying an image. It works great for an internal user but does not work for my partner community.
I have tried using the IMAGE(LEFT($Api.Partner_Server_URL_260, FIND( '/...
2
votes
2
answers
1k
views
progress bar formula
I am trying to develop a formula that will give me a progress bar with images in the campaigns
The idea that i want to achieve is that I have days from the start of the campaign till the end of the ...
0
votes
3
answers
923
views
Image Formula Field Isn't Working
I would like an image to show based on the "Rating" field picklist value. I keep getting syntax errors. Here's what I have.
IMAGE(
IF(ISPICKVAL(Rating, "Cold"),"/servlet/servlet.FileDownload?file=...
0
votes
2
answers
770
views
Error with HTML tag for image static resource
I am getting an HTML tag output instead of the Image in a formula field. The image is stored as Static resource in salesforce. Can someone let me know the possible reason for the error and a way out ...
0
votes
1
answer
104
views
Control formula field display based on User
I have a requirement to display an Alert image that I have uploaded as a static resource to the User who is viewing the record only if the User is owner of the record.
Can someone please guide me ...
1
vote
0
answers
74
views
Error displaying image linked list
I created a formula field that according to check some fields returns the image to the status of the object. In the registration screen, the image is displayed correctly, however when viewing the ...