I have a table that shows a list of contacts with their names, addresses, companies, etc. On top of the table, I put a search box. I noticed that if a contact name was entered with a lower case (or capital) letter, the search only works with the same match, ie. lower case can only find names that were input with a lower case and so forth. Any ideas on how to solve this? I want the table to find results irrespective of the case. Chat GPT suggested I create another field that creates only lower case names regardless of the input name and all search happens on it. But that seems complicated.
The plugin works as a fuzzy search but in order for it to work what it does is it LOADS ALL of the data it has to search through (that your privacy rules allow).
That means if you have 10k records, it loads all 10k records and all data in all fields, not just the field you are looking through.
sorry everyone, I’m not as smart as most of you. I’ve been getting some one-line answers which didn’t really help me. Someone write something like You can keep it in sync with a DB trigger very easily. But I don’t understand what a trigger is and how to ‘easily’ do this. I with there is either a full answer or no answer haha.
