Apex Code Development You need to sign in to do that
Don't have an account?
S N 27 Byte size(4000 bytes) limit - Formula
Hi All, I have a multi-select picklist that has 52 values in it. The requirement is to populate the selected values to another long text field. The original multi-select field is labeled "AMP". I have created a long text and updating the values using a workflow field update.Following is the formula I have used.
IF(INCLUDES(AMP__c,'Blue Card PPO'), 'Blue Card PPO'+ '; ',NULL)&
IF(INCLUDES(AMP__c,'Blue Choice PPO'), 'Blue Choice PPO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Blue View Vision Only'),'Blue View Vision Only'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Comprecare'), 'Comprecare'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct HMO'), 'Direct HMO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct POS'), 'Direct POS'+ "; ",NULL)
Likewise I have many more in the list. The problem is whenever I try saving this it gives me an error on the Byte size. It should not exceed 4000bytes. I have managed it to cut it down to 4600bytes. Please help me out on this.
IF(INCLUDES(AMP__c,'Blue Card PPO'), 'Blue Card PPO'+ '; ',NULL)&
IF(INCLUDES(AMP__c,'Blue Choice PPO'), 'Blue Choice PPO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Blue View Vision Only'),'Blue View Vision Only'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Comprecare'), 'Comprecare'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct HMO'), 'Direct HMO'+ "; ",NULL)&
IF(INCLUDES(AMP__c,'Direct POS'), 'Direct POS'+ "; ",NULL)
Likewise I have many more in the list. The problem is whenever I try saving this it gives me an error on the Byte size. It should not exceed 4000bytes. I have managed it to cut it down to 4600bytes. Please help me out on this.
You can follow below link
https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US
Regards,
Scott Haleo
@Hytechpro.com