Discover how easy it is to create multi-user, cross-platform custom solutions with FileMaker Pro, the relational database platform published by Apple subsidiary Claris International, Inc. Meticulously rewritten with clearer lessons, more real-world examples and updated to include feature changes introduced in recent versions, this book makes it easier to get started planning, building and deploying a custom database solution.The material is presented in an easy to follow manner with each chapter building on the last. After an initial review of the user environment and application basics, it begins a deep exploration of the integrated development environment that seamlessly combines the full stack of data table schema, business logic and interface layers into one visual programming experience. This book includes everything needed to get started building custom databases and contains advanced material that seasoned professionals will appreciate.Written by a professional developer with decades of real-world experience, Learn FileMaker Pro 19 is your comprehensive learning and reference guide. Join millions of users and developers worldwide in achieving a new level of workflow efficiency with FileMaker Pro.What Yoüll LearnDiscover interface and feature changes in FileMaker 17-19Create and maintain healthy filesPlan and create custom tables, fields, relationshipsWrite calculations using built-in and custom functionsBuild recursive and repeating formulasDiscover advanced features using cURL, JSON, SQL, ODBC and FM URLManipulate data files in the computer directory with scriptsDeploy solutions to a server and share with desktop, iOS and web clientsWho This Book Is ForCasual programmers, full time consultants, and IT professionals

Plan and create database tables, fields, relationships

Part 1 - 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 2 Defining Database Structure.- Chapter 6 Working with Database Files.- Chapter 7 Working with Tables.- Chapter 8 Defining Fields.- Chapter 9 Forming Relationships.- Chapter 10 Managing Containers.- Chapter 11 Defining Value Lists.- Part 3: Writing Formulas and Using Functions.- Chapter 12 Writing Formulas.- Chapter 13 Exploring Built-in Functions .- Chapter 14 Using JSON.- Chapter 15 Creating Custom Functions.- Chapter 16 Introducing ExecuteSQL- Part 4 Designing User Interfaces.- Chapter 17 Introducing Layouts.- Chapter 18 Getting Started with Layouts.- Chapter 19 Exploring Layout Panes.- Chapter 20 Creating Layout Objects.- Chapter 21 Manipulating Objects.- Chapter 22 Using Themes and Styles.- Chapter 23 Customizing Menus.- Part 5 Automating Tasks with Scripts.- Chapter 24 Introduction to Scripting.- Chapter 25 Common Scripting Tasks.- Chapter 26 Debugging Scripts.- Chapter 27 Using Script Triggers.- Chapter 28 Extending Features with Plugins.- Part 6 Deploying, Securing, and Analyzing Files.- Chapter 29 Deploying and Accessing Databases.- Chapter 30 Defining Accounts and Permissions.- Chapter 31 Analyzing and Modifying Files.