Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases

Extend FileMaker’s built-in functionality and totally customize your data management environment with specialized functions and menus to super-charge the results and create a truly unique and focused experience. This book includes everything a beginner needs to get started building databases with FileMaker and contains advanced tips and techniques that the most seasoned professionals will appreciate. Written by a long time FileMaker developer, this book contains material for developers of every skill level.

FileMaker Pro 16 is a powerful database development application used by millions of people in diverse industries to simplify data management tasks, leverage their business information in new ways and automate many mundane tasks. A custom solution built with FileMaker can quickly tap into a powerful set of capabilities and technologies to offer users an intuitive and pleasing environment in which to achieve new levels of efficiency and professionalism.

What You’ll learn

• Create SQL queries to build fast and efficient formulas
• Discover new features of version 16 such as JSON functions, Cards, Layout Object window, SortValues, UniqueValues, using variables in Data Sources
• Write calculations using built-in and creating your own custom functions
• Discover the importance of a good approach to interface and technical design
• Apply best practices for naming conventions and usage standards
• Explore advanced topics about designing professional, open-ended solutions and using advanced techniques

Who This Book Is For

Casual programmers, full time consultants and IT professionals.

Table of Contents

Part I: Using FileMaker
Chapter 1: Introducing FileMaker
Chapter 2: Exploring the Application
Chapter 3: Exploring a Database Window
Chapter 4: Working with Records
Chapter 5: Transferring Data

Part II: Defining Data Structures
Chapter 6: Working with Database Files
Chapter 7: Working with Tables
Chapter 8: Defining Fields
Chapter 9: Connecting Tables with Relationships
Chapter 10: Managing Containers
Chapter 11: Managing Value Lists

Part III: Writing Formulas and Using Functions
Chapter 12: Writing Formulas
Chapter 13: Text Functions
Chapter 14: Text Functions (JSON)
Chapter 15: Text Formatting Functions
Chapter 16: Number Functions
Chapter 17: Date, Time, and Timestamp Functions
Chapter 18: Container Functions
Chapter 19: Aggregate, Summary, and Repeating Functions
Chapter 20: Financial and Trigonometric Functions
Chapter 21: Logical Functions
Chapter 22: Get Functions
Chapter 23: Design Functions
Chapter 24: Mobile Functions
Chapter 25: Creating Custom Functions
Chapter 26: Introducing ExecuteSQL

Part IV: Designing Interfaces
Chapter 27: Introducing Layout Mode
Chapter 28: Getting Started with Layouts
Chapter 29: Exploring Layout Palettes
Chapter 30: Creating Layout Objects
Chapter 31: Manipulating Objects
Chapter 32: Using Themes and Styles
Chapter 33: Customizing Menus

Part V: Automating Tasks with Scripts
Chapter 34: Introduction to Scripting
Chapter 35: Common Scripting Tasks
Chapter 36: Debugging Scripts
Chapter 37: Using Script Triggers
Chapter 38: Extending Features with Plugins

Part VI: Sharing and Networking
Chapter 39: Introducing Network Sharing
Chapter 40: Securing Database Access
Chapter 41: Advanced Sharing and Analysis Tools
Chapter 42: Getting Connected