Learn FileMaker Pro 19: The Comprehensive Guide to Building Custom Databases, Second Edition

  • 9h 13m
  • Mark Conway Munro
  • Apress
  • 2021

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 You’ll Learn

  • Discover interface and feature changes in FileMaker 17-19
  • Create and maintain healthy files
  • Plan and create custom tables, fields, relationships
  • Write calculations using built-in and custom functions
  • Build recursive and repeating formulas
  • Discover advanced features using cURL, JSON, SQL, ODBC and FM URL
  • Manipulate data files in the computer directory with scripts
  • Deploy solutions to a server and share with desktop, iOS and web clients

Who This Book Is For

Casual programmers, full time consultants, and IT professionals

About the Author

Mark Conway Munro is a software developer and the author of AppleScript: Developer Reference (2010, Wiley) and Learn FileMaker Pro 16 (2017, Apress). After a 1988 introduction to FileMaker, Mark began using AppleScript and FileMaker for information management and process automation tasks. In 1994, Mark founded Write Track Media, a computer consultancy firm that develops custom database and workflow automation solutions. Mark builds time-saving custom systems for a diverse list of clients across industries, including education, entertainment, finance, news, publishing, and manufacturing, and more. Understanding the virtue of using technology to free human focus from repetitive tasks so they can pursue a higher level of productivity, Mark is unwavering in his commitment to developing the highest quality workflow management solutions.

In this Book

  • Introducing FileMaker
  • Exploring the Application
  • Exploring a Database Window
  • Working with Records
  • Transferring Records
  • Working with Database Files
  • Working with Tables
  • Defining Fields
  • Forming Relationships
  • Managing Containers
  • Defining Value Lists
  • Writing Formulas
  • Exploring Built-in Functions
  • Using JSON
  • Creating Custom Functions
  • Introducing ExecuteSQL
  • Introducing Layouts
  • Getting Started with Layouts
  • Exploring Layout Panes
  • Creating Layout Objects
  • Manipulating Objects
  • Using Themes and Styles
  • Customizing Menus
  • Introduction to Scripting
  • Common Scripting Tasks
  • Debugging Scripts
  • Using Script Triggers
  • Extending Features with Plug-ins
  • Deploying and Accessing Databases
  • Defining Accounts and Permissions
  • Analyzing and Modifying Files