Philosophy of FileMaker 20 - Volume 2

🌟 Philosophy of FileMaker 20 - Volume 2: Mastering Scripting, Calculations, and Relationships 🌟

Unlock Your FileMaker Potential!

Are you ready to elevate your FileMaker skills to a whole new level? Philosophy of FileMaker 20 - Volume 2 is the ultimate course for intermediate to advanced learners who wish to master FileMaker scripting, calculations, and relationships. Led by the esteemed expert John Mark Osborne, this comprehensive course will guide you through every nuance of professional FileMaker development.

Why Choose This Course?

• Real-World Application: Begin with a clean slate as we build a complete Invoicing solution from scratch, providing context and clarity throughout the learning process.
• Intermediate to Expert Techniques: Transition smoothly from intermediate to advanced methodologies with John's clear guidance.
• In-Depth Learning: Focus on one solution—Invoicing—to fully understand its development from beginning to end, while acquiring skills applicable to any FileMaker project.
• Think Like a Pro: Learn to approach problems creatively and make informed decisions based on understanding the 'why' behind each action.
• Multiple Approaches: Explore various solutions and comprehend their applications, so you can choose the most effective method for your specific needs.

Course Highlights:

• Starting with a Blank File: Observe every step of the process as we develop an Invoicing solution.
• FileMaker Scripting: Discover the art of automation and learn to write scripts that can handle complex tasks effortlessly.
• Advanced Calculations: Master the intricacies of calculations in FileMaker, enabling you to manipulate data with precision.
• Relationships & Structure: Understand the principles of establishing relationships between tables, which form the backbone of any robust database.
• Expert Techniques Revealed: Gain insights into the methods employed by professional developers to tackle advanced challenges.
• 30 Years of FileMaker Wisdom: Benefit from John's extensive experience in FileMaker training, spanning over three decades.

Course Structure:

1. Introduction to Intermediate Concepts

   • Understanding the FileMaker interface and layout options
   • Working with scripts: Actions, parameters, and error handling
   • Introduction to calculations and the scripting step function

2. Deep Dive into Advanced Scripting

   • Looping structures and conditional execution
   • Integrating external data sources with FileMaker
   • Script triggers and custom functions

3. Calculations Made Simple (Yet Powerful)

   • Exploring the Calculation engine: Let() vs If()
   • Date and time manipulations for dynamic invoicing
   • Advanced functions like Get(FileMode) and SetErrorCaptions()

4. Mastering Relationships

   • Designing a relational database schema that scales
   • Advanced join calculations
   • Optimizing performance with relationship optimizations

5. Bringing it All Together: The Invoicing Solution

   • Tying together scripts, calculations, and relationships in real-world scenarios
   • Best practices for solution design and user experience
   • Debugging tips and tricks to ensure your solutions are robust and reliable.

Join the FileMaker Community of Experts!

By completing this course, you will not only have a firm grasp of FileMaker 20 but also join the ranks of professionals who leverage this powerful tool to solve complex business challenges. Whether you're looking to enhance your current skillset or aiming to become a certified FileMaker expert, this course is your stepping stone to success.

🎓 Start Learning Today! 🎓

Don't just take our word for it; check out the free previews in each chapter to experience firsthand why John Mark Osborne's FileMaker training has been a trusted resource for over 30 years. Enroll now and embark on your journey to becoming a FileMaker guru!