I am not referring to the iPhone app. I am using Google Chrome and supplied a screen cap.
You have created a much better explanation using the like dog example and explaining that the search is a string.
In my example picture I have lots of assets and an assets table. I have different ways to label an asset. I see more value in a google like search than simply a string search. If the aim is intuitive and simplicity, then my search (as seen in screen cap) should return results. I kept the record visible in screen cap not to fan a flame and say I want or expect a feature that has no use, but because you can see the result wanted on the screen. I show the records because they could be buried deep among 100’s of other records, but they exist, just not shown through my “find” search.
I do not mean to quibble either because I love google and they have a search bar I love!! I also included a screen cap to make clear what search i intend to type and what results i expect out.
My comment earlier holds true:
" I could create a filter or a new view with a filter, but then it wouldn’t be quick, or intuitive."
If the search gave back results that had tomatoes and beef, contained somewhere within a record, across all the columns, this would be more intuitive. If you further created the ability to use commands in the “find” it could make it more intuitive. Ex. adding quotes around a string to do an exact match search.
I applaud you on explaining very clearly how the “find” search works. My intention is to share how I think the search would intuitively and quickly work, without regard to how it does work.
I will certainly create views with filters to fulfill specific needs. I look to the “find” search to be a powerful intuitive search capability when I need to find that one record that needs to be addressed.
Also, feel free to check out my base to get inside my head. You can get an idea of wtf I am doing on this site beside to quibble with people that actually understand database stuff.
Also, Will, your patience should be commended!