quick find criteria starting with a number, like 1abc seem to return data with just "1"

October 1, 20232 yr

Newbies

I wanted to verify if it is expected behavior that submitting:

1Password

… (which I have in 6 records out of over 3,500) in quick find returns records containing a value of just "1" in one more more fields (the found set includes over 95% of the records in the database). Same results when I enter a string that does not exist, such as 1asdfsdfaf.

This appears to be the case after doing some testing, but it's possible I'm missing something.

FileMaker Pro 19.6.3.302 macOS 12.6.9.

October 1, 20232 yr

39 minutes ago, Bob47 said:

returns records containing a value of just "1" in one more more fields

What is the data type of those fields? If you have both a Text field and a Number field enabled for Quick Find, then searching for "123abc" will find records where the Text field contains a word that starts with "123abc" OR the Number field contains the value of 123.

Edited October 1, 20232 yr by comment

October 1, 20232 yr

Author
Newbies

At least one of them is a Number field. From what you wrote, it appears then that entering 1asdf will return a Number field with a value of 1. Thank you for confirming that.