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

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

How to create the Conga Composer Button

Create  a Custom Conga Composer Button Conga Composer includes sample buttons on the following standard objects so you can easily copy and paste the base URL into your button.  Lead   Contact Account Opportunity Case Contract                       ​From Setup, click  Customize , select one of the above standard objects and click  Buttons, Links, and Actions ​Click on the  Conga Composer  button and copy the four lines in the Button or Link URL field 3. Click back to the main Buttons, Links, and Actions menu and click  New Button or Link      ​4. For the label, enter something that will describe the kind of document you will create     with Conga Composer, i.e. "AccountPlan" or "Invoice" ​5. For the Display type, choose either a  Detail Page Link  or a  Detail Page Button ​6. In the Button or Link URL text box, paste th...
Post a Comment
Read more