From the course: FileMaker Pro 13 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 13 Essential Training
Establishing search operators
One good thing to know about doing finds in FileMaker is that when you're searching for your data, you don't always have to specify the exact criteria. We looked at that before when I put in partial words in, like LOS, and I get Los Angeles, for example. But, for example, if I want to find all of the invoices in this untitled 12_03 data base that we created. And let's say I want to look at all the invoices between the year 2000 and the year 2010. I don't actually have to go create ten new Find Requests. So, for example, I won't have to go in here and say, Invoice Date, 2000. Another Find Request. 2001. And by the way, notice here that when I'm typing in just the year, even though if I enter data into a date field and I typed in just a four digit number it would reject that because it doesn't meet the requirements of a date field which is a two digit day, two digit month, and a four digit year. But in Find mode, I can just type in a four digit year and FileMaker's intelligent enough to…
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.