Category: formula

  • Quick Guide to Stunning 3D Buttons using SVG VisualForce

    Quick Guide to Stunning 3D Buttons using SVG VisualForce

    This article gives an example of how to use an SVG VisualForce page to generate images for buttons. The button is a formula that uses HYPERLINK() and IMAGE() functions that link to a VisualForce page passing parameters color and text. HYPERLINK( “/” + Id + “/e” , IMAGE( “/apex/ButtonImage?color=” + CASE( TEXT( Industry ), ‘Retail’, ‘darkgreen’,…

  • Revolutionize Your Reports and Page Layouts with SVG:  an innovative field format

    Revolutionize Your Reports and Page Layouts with SVG: an innovative field format

    If you add a long text field to a report, you may end up with something undesirable like the image below:  a field of plain text squeezed and stripped of any formatting. The “normal” way of fixing that would be to create a plain text field and use a workflow to copy the first 255 characters…

  • Unlock the Power of Color in Your Reports and Page Layouts

    Unlock the Power of Color in Your Reports and Page Layouts

    Other than using Rich Text fields, there are rigid limits in regards to how fields appear on a page layout or report. In the Account report below, you can see a text field that appears in different colors depending on the industry of the account. This article shows one way to obtain that functionality. Below is the formula used…

  • Optimize Complex Salesforce Formulas: 3 Proven Steps

    This article was also posted in LinkedIn:  3 Steps to optimize a complex formula in Salesforce. The formula below was created straight from the client requirements and didn’t fit the maximum formula size (5k bytes) when compiled. It was intended to display a red, yellow or green square depending on how many days the account was…