Apex Code Development You need to sign in to do that
Don't have an account?
GRStevenBrookes Formula to big to execute!
Hate it when this happens!!
Any ideas on how I can reduce Compiled Size is 5,960 - so only a little bit over!
IF(
AND(
Account_Manager_Assigned__c ="OK",
Accounts_Approval__c ="OK",
Final_Client_Approval__c ="OK",
Initial_Client_Approval__c ="OK",
QAT_Approval__c ="OK",
QAT_Approval__c ="OK",
Sales_Handover_Completed__c ="OK",
Script_Build_Complete__c ="OK",
Scriptor_Allocated__c ="OK",
SID_Received__c ="OK",
Skill_Level_Assigned__c ="OK",
Trainer_Assigned__c ="OK",
Training_Completed__c ="OK",
UAT_Approval__c ="OK",
Welcome_Call_Completed__c ="OK"),
IMAGE("/img/msg_icons/confirm16.png","OK"),
IMAGE("/img/msg_icons/error16.png","Stop"))
Ouch! that's where your overflow is coming from. It's the SUM of ALL the formulas used in the formula fields in your formula.
All Answers
That formula doesn't look very big, are any of the fields being referenced Formula fields? If so, what is their underlying code?
If you are on EE or UE you might want to try using a WFR and a Field Update instead.
Hi,
They are all forumla fields which effectivly check conditions elsewhere on the record and display an image based on that condition.
Ouch! that's where your overflow is coming from. It's the SUM of ALL the formulas used in the formula fields in your formula.
Ok - Ill have to work out a way around this - possibly with validation!
Thanks for your advice any how!
Curious about the workaround you ended up using.