How to search an object with a string in a multi select lookup

Question

Hi... 
 I am trying to perform a search for an object. The search criteria is a string inside a text property and I have to find this text inside a multi-select lookup. 
 But I don't know how to format the string for the search without getting a type conflict. 
 I also don't know if this kind of search operation is possible. 
 Does anybody know, if it is possible and how? 
 
 Greetings from germany 
 
 Michael

Tom Humm · Answer

Hi there, you can perform this type of search/match using an event handler (BeforeCheckInChanges.) You'll need to parse the string of names in the text field and use these values as as part of the search condition to look for in the department objects. The result set of the search condition should match the object you're looking for, this would then be the value used to set the field for this content on the invoice. I'd recommend you reach out to your preferred services provider if you need assistance in coding this functionality.