FileMaker Pro Database Development: Scripting, Relationships, and Reporting

Moving beyond basic database tables is the key to unlocking the true power of FileMaker Pro. To build truly dynamic business applications, you need to understand how data relates, how scripts automate tasks, and how calculations drive logic. In this course, you will transition from simple data entry to designing fully functional, relational custom apps. Through a structured, text-based approach, you will learn the core mechanics of database design, scripting, and reporting by analyzing a real-world invoicing solution. What you'll learn: - Design multi-table relational databases using proper entity-relationship diagrams and key fields. - Write automated scripts to streamline user workflows, navigate layouts, and manipulate data. - Create dynamic calculations using built-in functions, custom logic, and modern techniques like ExecuteSQL. - Build professional, multi-level reports with sub-summary parts to present data clearly. - Apply JSON parsing within scripts to handle modern data exchange and parameter passing. - Configure portal elements and relationship graphs to display related records seamlessly. You will start by mastering the fundamental concepts of database relationships and calculation logic. From there, you will progress through hands-on written scripting exercises and layout design, culminating in a fully realized invoicing system. This course is designed for learners who have a basic understanding of FileMaker Pro layouts and fields and are ready to take their development skills to the next level. No prior programming experience is required. Start building more powerful, automated, and professional custom applications today.