How to field_filter_validation_exception?
I have created a Multi Select picklist field on Account(Service Partner Type). I wanted to add criteria that would filter by "Service Partner Type" includes/contains "Certified Implementation Partner (CIP)," but since it is a multi-select picklist value, I couldn’t.
Then, I added a checkbox to the account and used WFR so that it becomes true when Service Partner Type= 'Certified Implementation Partner (CIP).' The checkbox field is added as a lookup filter criteria.
When the Service Partner Type field on the account is filled up with a value, the Service Partner Type field on the Project is also filled with the same value. If I want to populate a multi-select picklist field values onto another multi-select picklist field) Then, I use Apex.
When I edit an Account, I get the below error:
You are getting this error because you are updating a lookup field wherein a Look Up filter is already added. Also, the value you give in the lookup field does not match the filter criteria. The value of your code should match with the lookup criteria. Try to find out the API name below in your implementation:
You can make the code compatible with that filter criteria or change the filter criteria.
Answer (1)
Make sure that your Apex code sets values in a way that aligns with these lookup filter criteria. For example, if the lookup filter is based on the checkbox (Certified Implementation Partner (CIP)), verify that your Apex fnf code correctly updates this checkbox on the related record before setting the lookup field.