Master Tips & Tricks of FileMaker Experts

Intermediate & Advanced FileMaker Techniques

Created by: John Mark Osborne
FileMaker Pro Expert

What Will I Learn?

• Learn important keyboard shortcuts
• Position window anywhere on the screen
• Manipulate dates properly
• Understand restoring of scripts steps
• Learn layout tricks of the trade
• Understand how the index works
• Write scripts at an advanced level
• Formulate complex calculations
• Work with local and global variables
• Create virtual lists
• Design relationships with operators other than equals
• Understand SQL
• Combine scripts, calculations and relationships into a cohesive feature
• Create custom functions
• Understand recursion
• Conquer multi-user issues
• Uniquely number subsummaries and restart numbering at breaks
• Define parameters with multiple values
• Create progress bars
• Create a quick calendar
• Delete files off a hard drive with only FileMaker
• And, much more!

Requirements

• Students should be familiar with layout mode, scripting, calculations and relational design
• Philosophy of FileMaker Parts 1, 2 and 3 are good experience for this course
• This is course move from intermediate to advanced to expert

Target audience

• Students who enjoyed the Philosophy of FileMaker video series
• Aspiring developers with some to moderate experience designing FileMaker solutions