In this post we will discuss on creating Progress bar field without any coding, just by using formula field. Initially it seems like we can’t create dynamic progress bar field by using only formula in Salesforce. There are some approach, where developers stores 4 images with interval of 25% or 10 images with 10% interval and displaying image with help of Case or IF statement.
We will create Progress bar field, which will reflect every percentage.
To create perfect Progress bar field, we will need to take help of two images.
Upload above two images in Static resource. Once it is uploaded create a formula field.
In Formula field we will be appending both images and repeating “Filled Image” as per percentage field. Logic can be seen in below image.
Formula for Progress Bar Image
IMAGE('/resource/1398170360000/BlueProgressBar', 'Test', 10, ( percField__c * 100 )) & IMAGE('/resource/1398170333000/ProgressBorder', 'Test', 10, (100 - percField__c * 100 )) & ' ' & TEXT (percField__c * 100) & '%'
In above code “1398170360000” is ID of static resource displayed in URL.
Leave a Reply