Skip to main content

Solution to a compiled formula being too big to execute

Have you ever ran into a problem when creating a formula field where you get the error that the compiled formula is too big to execute (i.e. "Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (7,498 characters). Maximum size is 5,000 characters.")?

 You might think that splitting the formula into two formula fields and then combining the two values into another formula field will circumvent the problem, right? Wrong.

 You are getting this error because SFDC counts every character used to create source fields for a formula. There are two approaches to take: (1) shortening API Names, and (2) using Workflow Filed Updates.

  1. Shortening API Names:
    • You can try shortening API names, but this has not helped me much in the implementations that I have delivered.
  2. Workflow Field Updates:
    • The best way around the limit is to use workflow field updates since:
      • they do not have a compile limit, and;
      • the compiled size that is referenced in formulas referncing the updated field will be significantly smaller because a number/percent/currency field is being updated with a value rather than containing the logic in the field.
    • Note that the record needs to be edited and saved in order to execute the formula.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to create a custom button to open Visualforce page

Let's say that you are working in a large Org and different groups throughout the company use the same object, but each a little differently. Instead of overriding the standard "Edit" or "New" buttons, create a custom button. For example, there is a custom object on the standard Opportunity object and you want to launch a different page layout for your sales team for a custom quoting object. Create your "Quote" Visualforce page. Create the custom button on the custom object. Label: New API Name: New_Quote Type: List Button Content Source: OnClick JavaScript Behavior: Execute JavaScript Button or Link URL: window.open("/apex/InputVisualforcePageNameHere?RecordType=InputRecordTypeIdHere&retURL={!Opportunity.Id}&cancelURL={!Opportunity.Id}&saveURL={!Opportunity.Id}","_parent"); Edit the Opportunity page layout for the sales team and modify the buttons on the related list to add your custom button. In
Post a Comment
Read more

Replace the Salesforce.com logo with a company logo

Having the Salesforce.com logo in the top left of your Org can make it feel like you are using a tool that is not built for your company. Fortunately, there is an easy way to brand your Org with your company's logo. Follow these simple steps: Import the company logo Go to All Tabs > Documents. Select the "Documents" object and the "New" button. The document name will be something like "CompanyLogo.jpg". Set "Externally Available Image" as TRUE. Choose to place the record in either a custom Admin folder to separate from other document files or place it in your "My Personal Documents". Upload the file from your computer. I recommend that the image you attach be 200 pixels width, 45 pixels height, and no more than 20KB in size. Try to use an image with a transparent background since SFDC's background uses a gradient color scheme. Save. Create a custom App Go to Setup > Build > Create > Apps. Select
Post a Comment
Read more

How to Format Number or Currency Values in Conga (Word)

Formatting Number Values The number formatting parameter begins with \#, followed by any combination of the following parameters.  Please see the examples following this table. When Conga Composer populates a numeric value, the digit grouping symbol (the “thousands separator”) is defined according to your Locale settings (as defined in Salesforce’s Setup | Personal Information) or according to the Culture or CurrencyCulture Conga Composer parameter. Despite the cultural settings that govern the output from Conga Composer, within an appearance parameter, you must use a comma (",") for the digit grouping symbol (for thousands) and a period (".") as the decimal symbol. ​   PARAMETER DESCRIPTION 0 (zero) Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero). Example: { = 4 + 5 \# 00.00 } displays "09.00". # Specifies the requisite numeric places to display in the r
Post a Comment
Read more