Join Cris Ippolite for an in-depth discussion in this video Establishing search operators, part of FileMaker Pro 13 Essential Training.
…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 know that I'm trying to search the year.…
Author
Cris Ippolite
Released
5/7/2014- Creating databases from Starter Solutions
- Determining what tables you need
- Defining key fields and creating relationships between tables
- Creating fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Managing layouts and layout objects
- Using the Layout Assistant
- Applying themes to layouts
- Finding records and working with found sets
- Building reports and charts
- Exploring calculations
- Creating and triggering scripts
- Working with relationships in scripts, calculations, and charts
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 4s
-
Using the exercise files1m 29s
-
-
1. Getting Started
-
What is a database?2m 33s
-
Exploring the interface6m 17s
-
-
2. Database-Creation Essentials
-
Adding tables by importing5m 52s
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 34s
-
5. Working with Fields
-
Understanding field types5m 12s
-
Defining fields8m 32s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records4m 35s
-
8. Importing and Exporting
-
Importing data9m 50s
-
Exporting data5m 42s
-
-
9. Creating Layouts
-
Introducing layouts4m 1s
-
-
10. Working with Layouts
-
Previewing the Inspector1m 39s
-
11. Formatting Layout Objects
-
Applying Screen Stencils3m 25s
-
Applying gradients2m 19s
-
Understanding states5m 9s
-
Setting field behaviors3m 23s
-
Using the popover feature7m 40s
-
Setting the tab order4m 29s
-
12. Finding Data
-
Saving find requests6m 15s
-
13. Sorting Data
-
Sorting with related fields2m 21s
-
Sorting using custom values3m 44s
-
Sorting using buttons4m 54s
-
14. Value Lists
-
15. Printing and Saving
-
Printing in different views6m 15s
-
Printing merge letters5m 24s
-
16. Reports
-
Creating subsummary reports8m 29s
-
Adding charts to reports9m 10s
-
17. Calculation Essentials
-
Introducing calculations3m 11s
-
Using number functions6m 12s
-
Using text functions9m 5s
-
Using get functions3m 58s
-
Using logic functions9m 50s
-
-
18. Script Essentials
-
Creating multiline scripts10m 23s
-
Using script parameters5m 7s
-
19. Script Triggers
-
Introducing script triggers2m 13s
-
Using object-based triggers13m 5s
-
-
20. Using Relationships
-
Using related fields8m 10s
-
Creating portals7m 48s
-
Conclusion
-
Goodbye1m 49s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Establishing search operators