From the course: FileMaker Pro 12 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Establishing search operators - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
Establishing search operators
In FileMaker Pro, when you're searching for data, you don't always have to specify exact search criteria. For example, in the Exercise 12_03, if I want to find all the invoices that were created between the years 2000 and 2010, I would enter Find mode, and here we have an Invoice Date. And what I could do is put-in the year 2000. By the way, when I enter in a four digit date in Find mode into a Date field, FileMaker automatically assumes that I'm searching for any date that's within that year. So I could do 2000, 2001, and you could see here it saw that there were the four characters, so now it does what's called these wildcards. So it puts an */*. So it says any month, any day of the year 2000. So, I've got a new one. I could keep doing this doing 2000, all the way up to 2010, and of course, it would find all those matching records for me. But a much easier way to do it is to use what's called a Search Operator. So I can type in 2000 and here we see this dropdown with all these…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.