Hi,
I’m new with Tap Forms and just getting start. As like using other app, I tried to do a full text search for part of data. Unfortunately, it only supports search beginning of a field, not in middle. After do some search in forum, I found you previous mentioned (a few years ago like 2014) it is limited by FTS engine of SQLite. Any plan to improve? Seems FTS engine evolved to FTS5. Any chance Tap Forms can use some new feature to support “real” full text search? Thank you.
BTW: Really good job with Tap Forms. Just start use it but already a fan.
Hi Sam,
Yes, this is definitely a problem with FTS. I do not believe it has been solved with FTS5 though. Although I’m researching possible solutions to the problem.
Hi Brendan,
So currently, is there any way to perform a simple “in-middle” full text search without creating a filter? It takes too many steps to create a filter, check results, and then delete the filter, for only find a specific record.
Unfortunately no. But what you can do is keep the filter around and then just edit it when you want to search for a different word. I know it’s way less convenient than the regular general full text search though. It’s too bad that whoever programmed FTS didn’t take into consideration languages with words that aren’t delimited by spaces or linefeeds.