Welcome. I’ve also been facing this challenge lately.
The best solution I have found across other threads seems to be creating another field in your database where you will store the thing you want to search against in lowercase, and then using that field in searches. It makes your database a little bigger but it’s not that much work to implement:
- Create new field on your datatype to store that lowercase text. I called mine “searchstring” because, even though currently it’s just the lowercase version of another text field, in the future I might decide to save more in there. See @aj11 's explanation here: Search bar that isn't capital sensitive - #10 by it16
- Using the App search tool, look for the uses of the field that you’re going to put in that search string (seems to be Name in your case). Specifically, look for where this field is updated and make sure your new searchstring field is also updated accordingly in those places.
- In App data, run a bulk operation to populate that new field. You’ll also have to do this in your live environment after deploying, if your app is already live of course.
Let me know if you find a better solution!
PS: another technique I tried before was filtering the search output as suggested in this article but that turned out to be extremely slow (for context: I have around 15k things in the table I’m querying).