- FileMaker provides ways that we can search data…that's being stored in the database,…and we do so by entering Find mode,…clicking into a field that we want to search,…and entering some criteria.…Then we get what's called a "found set" in return.…So that's a simple search.…But let's say in this particular case where…I just went in and I searched for the State field,…let's say I want to get a found set…that combines the state of California…and the state of Washington.…If I go into the State field in Find mode…and I enter in California and Washington,…FileMaker's just going to look for records…that actually have a CA and a WA in them.…
So how can we combine a found set of records?…Well the key is this button up here called New Request.…So let's first initiate the California search.…Now we see we've got 23 records that match that search.…So we're asking a question of our database,…"How many customers do we have in California?"…and the answer is 23.…But we also want to know how many we have…in Washington and combine that total together.…
Author
Cris Ippolite
Released
5/12/2015- Comparing flat vs. relational databases
- Creating databases from starter solutions
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating and working with fields, including container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Working with layout themes
- Using layout parts and tools
- Formatting layout objects
- Finding and sorting data
- Creating value lists
- Printing and saving
- Building reports, including subsummary reports and quick charts
- Using the Calculation dialog
- Creating and triggering scripts in the Script workspace
- Working with script triggers
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome57s
-
Touring the Launch Center6m 44s
-
Using the exercise files1m 25s
-
-
1. Getting Started
-
What is a database?2m 35s
-
Exploring the interface5m 35s
-
-
2. Solution Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 27s
-
5. Working with Fields
-
Understanding field types7m 50s
-
Defining fields8m 23s
-
Adding fields to layouts5m 33s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records3m 33s
-
8. Importing and Exporting
-
Importing data6m 25s
-
Exporting data4m 17s
-
-
9. Creating Layouts
-
Introducing layouts3m 18s
-
Working with layout themes5m 41s
-
-
10. Working with Layouts
-
Understanding layout parts6m 24s
-
Previewing the Inspector2m 23s
-
11. Formatting Layout Objects
-
Applying themes to layouts6m 35s
-
Applying screen stencils4m 2s
-
Applying gradients2m 43s
-
Understanding states7m 47s
-
Setting field behaviors4m 47s
-
Using the tab control feature12m 38s
-
Setting the tab order4m 9s
-
12. Finding Data
-
13. Sorting Data
-
Sorting with related fields2m 41s
-
Sorting using custom values2m 59s
-
Sorting using buttons4m 4s
-
14. Value Lists
-
15. Printing and Saving
-
Printing merge letters4m 52s
-
Saving as PDF or Excel1m 54s
-
16. Reports
-
Creating subsummary reports9m 35s
-
Adding charts to reports6m 54s
-
17. Calculation Essentials
-
Introducing calculations3m 26s
-
Using number functions6m 57s
-
Using text functions11m 50s
-
Using get functions5m 49s
-
Using logic functions12m 42s
-
-
18. Script Essentials
-
Touring the Script workspace5m 14s
-
Creating multiline scripts7m 56s
-
Using script parameters3m 48s
-
19. Script Triggers
-
Introducing script triggers1m 23s
-
Using object-based triggers9m 18s
-
Using layout-based triggers7m 26s
-
-
Conclusion
-
Goodbye1m 48s
-
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: Reviewing new requests in find mode