Skip to main content
How do to make a formula field that will be a picture showing the progress poncentaje (example pictured) but in another field entering a numeric value in the image to increase that value?

 

Formula field poncentaje with a number field
4 件の回答
  1. 2014年4月2日 17:01
    You can do an image formula in the field, and base the sections off of the number field in pixels.

     

    IMAGE("/img/samples/color_green.gif", "green", 15, NUMBERFIELDConvertedToPercent*TotalWidthPixels ) & IMAGE("/img/samples/color_white.gif", "white", 15, (TotalWidthPixels - (NUMBERFIELDConvertedToPercent*TotalWidthPixels) )

     

    Putting in some values to explain better:

     

    IMAGE("/img/samples/color_green.gif", "green", 15, .25 * 200 ) & IMAGE("/img/samples/color_white.gif", "white", 15, (200 - (.25 * 200) )

     

    This example bar has a height of 15 pixels, 25% as the value in the field, which will be green. The rest of the 75% will be white. The overall length of the bar is 200 pixels.

     

    You can apply this with multiple sections by simply putting multiple images in the formula field in different colors, and manipulating the numbers so that the length of the final white section is equal to the remainder of pixels available in the bar.
0/9000