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 16is 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 Youll 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 SourcesWrite 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 standardsExplore advanced topics about designing professional, open-ended solutions and using advanced techniquesWho This Book Is For

Casual programmers, full time consultants and IT professionals.

Mark Munro is an author, software developer and entrepreneur. A 1988 introduction to FileMakerled Mark to pursue a career as a developer. Soon after, he was using AppleScript and FileMaker forinformation management and process automation. In 1994, Mark founded Write Track Media, acomputer consultancy to develop custom database and workflow automation solutions for clients.Today, Mark continues in that mission, using AppleScript and FileMaker Pro in combination withother tools and technologies to build time-saving systems for a diverse list of clients. Armed withthe conviction of the virtue of using of technology to free human focus from repetitive computertasks so they can pursue a higher level of productivity, Marks passion for the work isunwavering.

PART 1 Introduction.- 01 Introducing FileMaker.- 02 Exploring the Application.- 03 Exploring a Database Window.- 04 Working with Records.- 05 Transferring Data.- PART 2 Defining Database Structure.- 06 Working with Database Files.- 07 Creating Tables.- 08 Defining Fields.- 09 Connecting Tables with Relationships.- 10 Writing Formulas.- 11 Creating Custom Functions.- 12 Using SQL Queries.- 13 Managing Containers.- 14 Managing Value Lists.- PART 3 Using Built-in Functions.-15 Text Functions.- 16 Text Functions (JSON).- 17 Text Formatting Functions.- 18 Number Functions.-.-19 Date, Time& Timestamp Functions.- 20 Container Functions.- 21 Aggregate, Summary& Repeating Functions.- 22 Financial& Trigonometric Functions.- 23 Logical Functions.- 24 Get Functions.- 25 Design Functions.- 26 Mobile Functions.- PART 4 Designing User Interfaces.- 27 Introducing Layout Mode.- 28 Getting Started with Layouts.- 29 Exploring Layout Palettes.- 30 Creating Layout Objects.- 31 Configuring Objects.- 32 Using Themes and Styles.- 33 Customizing the Menu Bar.- PART 5 Automating Tasks with Scripts.- 34 Introduction to Scripting.- 35 Common Scripting Tasks.- 36 Debugging Scripts.- 37 Reacting to Script Triggers.- 38 Extending Features with Plug-ins.- PART 6 Sharing Databases on a Network.- 39 Introducing Network Sharing.- 40 Securing Database Access.- 41 Advanced Sharing and Analysis Tools.- 42 Getting Connected.