0

I have a formula that sync multi-select picklist field from accounts to contacts object but having issue on character limit.

Eg.,

IF( INCLUDES(Account.Category2__c ,"Accessories (Bags, hats, scarves etc)"),
    "Accessories (Bags, hats, scarves etc)","") 
& 
IF( INCLUDES(Account.Category2__c ,"Accountants & Bookkeepers"),
    "Accountants & Bookkeepers","") 
& 
IF( INCLUDES(Account.Category2__c ,"Activities"), "Activities","")  

We have a long list of this category2. If i include all the listed category on the formula. It only allows upto the character limit. Is there other way on how to sync multi-select picklist field from accounts to contacts object?

Accessories (Bags, hats, scarves etc) Accountants & Bookkeepers Activities Activities & enrichment Adult Enrichment Adventure Holidays Aesthetics Afternoon Tea Airconditioning etc.....................................................

1 Answer 1

0

There are two ways you can try this : -

  1. Create workfolw rule and update the field based on the criteria which you have mentioned in the Formula and in field update , update the desired value.

  2. if there you face the same issue then you need do the same update using trigger.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.