Hi
I’m a newbie of one week to tapforms and so far very impressed. I do have a slight issue with searching. The items for the database all have a distinct serial number typically something like 14NA3487NBO the number is used in a variety of functions beyond the database so crucial and often quoted.The trouble is that the earlier part of the number can change but say 3487NBO never. If I enter the full number into a search the record is found, if I enter any of the beginning of the number its found but 3487NBO yields no result. Ive searched the manual to no effect and I am wondering if there is some kind of Wildcard that I could insert to get a result?
Thanks for any help
Stephen
Hello Stephen,
This is a limitation of the Full Text Search (FTS4) engine that Tap Forms uses. It’s part of the SQLite database engine and unfortunately it doesn’t support searching strings within strings. It only supports searching prefixed strings as you’ve discovered. So you can find the records if you search the beginning of a word, but not the end of a word.
There is no workaround for this unfortunately other than to put a space before the part of your unique number that doesn’t change. Then it will be able to be found during a search.
Thanks,
Brendan
Brendan Thank you.
Okay, as an alternative I am also experiencing difficulty searching with a date field. so far I seem able to located a record via a date search only on the Mac version doing an advanced search. I have not been able to achieve this at all on the iOS platform.
Am I doing something wrong.
Thanks
Stephen
Hello Stephen,
Are you also using the advanced search function on iOS? You get there by tapping on the search button just to the left of the Search field when viewing a list of records. Just typing a date value into the search field won’t work because Tap Forms searches only the text in your forms with that.
Thanks,
Brendan
Thank you Brendan,
That seems to work. I was hoping I could do it via a basic string search.
Cheers
Stephen
.
