function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
formulformul 

to avoid 5000 characters in formula fields, any temp variables can we use ?

*rdinakaran**rdinakaran*

No .Its not an efficient way.If you add any temp variables,it is also calculated to your characters limit.

 

Formula field character size calculated by all refering fields size.

 

for ex: Temp_formula_Field1 compiled is 100 (for example only i put 100)

 

Temp2_Formula_Field2 = 80 + Temp_formula_Field1 

 

 

Now the compiled size of Temp2_Formula_Field2 is 104. 

 

 

To avoid  5000 characters in formula follow simple tricks like instead of using "IF" for multiple check use CASE.

 

 

 

Thanks