Hi,
I'm trying to work out how my users can search with items from a multiline text field.
I have a supplier account and a custom field called Business Area : this is populated from a form and can be any number of different items, so i didn't want to create this a choice as it needs to be dynamic and they can also submit their own business areas.
I need the users to be able to search based on text in these fields, it seems to only match the first line of text so example is
A supplier will have a business area formatted like this:
Hotel; Transport; Catering
if the users searching Hotel the account is displayed, if the users searched Transport, nothing is displayed. is there a better way to do this or do i need to form that column differently or use something else?
Thanks