Please ensure the field that you are searching has been added to the Details Screen of that row and then this should work. Including the value in the table alone (and not on the row’s Details screen) will give you the results you’re seeing above.
I’m still new to this so I hope I understand you correctly.
By detail screen, you mean if i click in to see more information right?
Yes the data is already inside the detail screen.
So if you refer to my 2nd screenshot in the original post, you would see that A0695225 does not trigger anything if I pasted the whole number at a time, but works if I type in the string one character at a time.
This is the detail screen and you can see policy number just below the headline.
I understand the idea that if there’s same data, it will come up. My bigger problem though is why copy pasting the whole string doesn’t bring up the result, but typing in 1 character at a time does.