The Comprehensive Guide to Building Custom Database
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 a beginner needs 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
The previous edition of this book was published in 2017. In the introduction to Learn FileMaker Pro 16, I reminisced about my first encounter with the software working at Tannen’s Magic Shop in Manhattan back in 1988 and highlighted the evolutionary changes that spanned the decades between. In the three years since that publication, the technological march forward continues with improvements to the FileMaker application.
The product is now in version 19. The Apple subsidiary was renamed Claris to reflect an expanding product line with more diversity than the former FileMaker-centric offerings. The previous two versions of the desktop application — FileMaker Pro and FileMaker Pro Advanced — are now rolled into a single title that includes all development tools. Annual upgrades to the product have resulted in an accumulation of feature changes. To stay relevant and reflect the current software, a new edition was required.
In addition to revisions covering changes to the software, I was determined to make improvements to the original book. Some changes were in response to legitimate criticisms from readers. Although readers widely praised the first book, some thought there were too many pages focused on a function reference section that too closely resembles what is available in the online help guide. Others thought there were not enough real-world examples. I felt the original book could have been more succinct. I updated the text for feature changes and spent extra months completely rewriting each section and producing what is almost an entirely new book. I hope the effort shows.
I love hearing from readers and welcome any feedback or questions. If you enjoy the book, please consider posting a review on your favorite online bookseller’s site and/or sharing on social media. Contact me directly by joining the Learn FileMaker FaceBook group, connecting to my professional network on LinkedIn or through my business website:
FileMaker is a highly capable tool used by millions worldwide. I hope you enjoy the book and that it helps you on your journey.
Mark Conway Munro
December 2020 / Lewisburg, PA
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, 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.