FileMaker Pro Essential Training (2019)

Introduction

• Introducing FileMaker Essential Training
• Introducing the FileMaker platform

1. Getting Started

• What is a database?
• How FileMaker works
• Configuring essential preferences
• Getting to know the interface

2. FileMaker App Creation Essentials

• Getting going with starter apps
• Add-on tables

3. Creating Tables

• Determining which tables your FileMaker app will need
• Creating tables in the manage tables window
• An important note about relationships

4. Working with Fields

• Deciding what fields you will need
• Understanding field types
• Defining fields in tables
• Adding fields to layouts
• Field options: Auto enter
• Field options: Validation

5. Working with Container Fields

• Using container fields in your FileMaker app
• Applying container field options
• Container storage options

6. Working with Records

• Creating and duplicating records
• Editing and locking records
• Deleting records and backing up files

7. Importing and Exporting

• Exporting data from FileMaker
• Importing data from FileMaker

8. Creating Layouts

• Introducing FileMaker layouts
• Using the Layout Assistant to new layouts

9. Working with Layouts

• Understanding layout parts
• The Inspector panel
• Layout tools and status area in Layout mode
• Managing layouts and layout folders

10. Formatting Layout Objects

• Grouping layout objects
• Arranging and aligning layout objects
• Understanding FileMaker themes
• Applying themes to layouts
• Customizing and importing themes
• Applying Screen Stencils
• Formatting fields and applying field attributes
• Controlling layout object behaviors
• Setting the tab order
• Slide controls in your layouts
• Popovers in your layouts
• Using the tab control feature

11. Finding Data

• Using the basic find functions
• New requests in Find mode
• Search operators to find records easier
• Constraining or extending found sets
• Using Fast Match and Quick Find

12. Sorting Data

• Sorting with single criteria
• Sorting with multiple criteria
• Sorting using custom values
• Sorting using buttons

13. Value Lists

• Drop downs, radio buttons, and other field control options
• Creating and applying static value lists

14. Printing

• Previewing pages and print options

15. Reports

• Building simple reports with summary fields
• Creating subsummary reports: Summary parts
• Creating subsummary reports: Aggregating summary parts

16. Calculation Essentials

• What are calculations?
• Touring the calculation dialog window
• Number functions in FileMaker
• Date and time functions
• Analytic text functions
• Text manipulation text functions
• Logic functions: The If function
• Logic functions: The Case function

17. Script Essentials

• What are scripts and script steps?
• Assigning script steps to buttons
• Touring the Script Workspace
• Creating multiline scripts
• Creating multiline scripts: Printing in scripts
• Creating multiline scripts: Custom dialogs
• Adding find criteria to a script: Static finds
• Adding find criteria to a script: User-specified finds
• Using the New Window script step
• Understanding the If script step
• Adding the If script step to a script

18. New Features in FileMaker 19

• Core ML support
• Working with Core ML, part 1
• Working with Core ML, part 2
• Working with Core ML, part 3
• Working with Siri shortcuts
• Setting advanced Siri shortcuts using FileMaker scripts
• NFC support
• Setting up your NFC tag
• Working with NFC in your FileMaker app
• JavaScript support
• Working with JavaScript in Web Viewer

Conclusion

• Where to go from here