Increase Formula Compiled Size above 5000 - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
3,600  Points
Open - Not Planned
Open - Not Planned

Increase Formula Compiled Size above 5000

Customization & App Building

Please increase the formula size above 5000. I know APEX is a solution; however it is time consuming and difficult to obtain the resources. 

Merge Idea · Flag

Latest Comment from Salesforce

  • Shannon Hale - 7 years ago

    This particular limit is determined by the maximum query size that the database can execute, which is not something we have much control over. What we can control is the makeup of a query, by writing formula functions that execute more efficiently and compile to smaller sizes. It's a bit like a suitcase: we can't change the dimensions, but we can fit more into it if we move things around and fold them better.

    In Summer '12, we were able to decrease the compile size of many formula functions, some of them -- particularly the date-related functions -- drastically, by removing the checks that are done behind the scenes from the compile size. This meant that some formulas that previously compiled to more than 5,000 characters, now compile to less than half that (see my earlier comment for examples).

    This doesn't solve every case, and we are continuing to evaluate the efficiency and performance of our formula functions and engine to make further improvements -- trying to fit more into the suitcase, as it were. But the limit won't be changing or going away any time soon.

  • Upvotes
  • Downvotes



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.