Join Cris Ippolite for an in-depth discussion in this video Add find criteria to a script, part of FileMaker Pro 15 Essential Training.
- [Voiceover] Finding records…is one of the most common tasks that users perform…when they're inside FileMaker,…and as a result, finding records is also a common…actions that scripts are called on to perform.…Scripts can be set up to perform any search…that a user can perform manually,…and even some that cannot be performed manually.…Because you can controlled a scripted search…as a developer more easily than you can a manual search,…scripted searched are often more efficient and reliable.…There are several scripts…that may be involved in finding records,…and if we go to the Script Workspace…and open up both of our panes here,…we see we've got the Print Welcome Letter.…
And over here, if we organize them by category…and look at Found Set,…you'll see that we've got all sorts of script steps…that mimic finding behavior inside FileMaker.…There's the ability to perform a find,…constrain found sets, show all records, even sort records.…All of these affect found sets.…So let's say in this script…that we've created here for the Welcome Letter,…
Author
Cris Ippolite
Released
5/10/2016- Understanding the FileMaker Pro interface
- Creating new FileMaker apps from spreadsheets
- Building tables and relationships
- Defining primary and foreign keys
- Working with fields
- Creating, editing, and deleting records
- Importing and exporting data in a FileMaker Pro database
- Creating and formatting layouts
- Finding data and sorting data
- Printing from FileMaker
- Building reports
- Using calculations
- Scripting
- Triggering scripts
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome52s
-
-
1. Getting Started
-
What is a database?2m 44s
-
Tour essential preferences6m 11s
-
Explore the interface5m 40s
-
Tour the Launch Center4m 46s
-
-
2. FileMaker App Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understand key fields6m 25s
-
5. Working with Fields
-
Understand field types7m 47s
-
Define fields8m 1s
-
Add fields to layouts5m 15s
-
Use field auto-enter options10m 5s
-
6. Working with Container Fields
-
7. Working with Records
-
Create and duplicate records6m 21s
-
Edit and lock records4m 4s
-
-
8. Importing and Exporting
-
Import data6m 44s
-
Export data4m 50s
-
-
9. Creating Layouts
-
Introducing layouts5m 1s
-
Work with layout themes7m 48s
-
-
10. Working with Layouts
-
Understand layout parts7m 28s
-
Preview the Inspector3m 2s
-
11. Formatting Layout Objects
-
Apply themes to layouts2m 11s
-
Apply screen stencils6m 13s
-
Apply gradients2m 3s
-
Understand states7m 1s
-
Set field behaviors2m 3s
-
Use the tab control feature7m 26s
-
Set the tab order3m 29s
-
12. Finding Data
-
Establish search operators5m 19s
-
13. Sorting Data
-
Sort with single criteria5m 48s
-
Sort with related fields1m 52s
-
Sort with multiple criteria1m 43s
-
Sort using custom values2m 25s
-
-
14. Value Lists
-
15. Printing and Saving
-
Print merge letters3m 54s
-
Save as PDF or Excel4m 48s
-
16. Reports
-
Create subsummary reports8m 37s
-
Add charts to reports7m 37s
-
17. Calculation Essentials
-
Introducing calculations2m 58s
-
Use number functions7m 6s
-
Use date and time functions2m 43s
-
Use text functions9m 42s
-
Use get functions4m 41s
-
Use logic functions10m 35s
-
-
18. Script Essentials
-
Tour the Script workspace3m 29s
-
Create multiline scripts8m 7s
-
Use script parameters2m 46s
-
19. Script Triggers
-
Introducing script triggers2m 12s
-
Use object-based triggers10m 22s
-
Use layout-based triggers7m 25s
-
-
Conclusion
-
Goodbye35s
-
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: Add find criteria to a script