Learn FileMaker Pro 16

1. Front Matter

   Pages i-xlvi

   PDF

2. Using FileMaker

   1. Front Matter

      Pages 1-1

      PDF

   2. Introducing FileMaker

      • Mark Conway Munro

      Pages 3-17

      PDF

   3. Exploring the Application

      • Mark Conway Munro

      Pages 19-43

      PDF

   4. Exploring a Database Window

      • Mark Conway Munro

      Pages 45-60

      PDF

   5. Working with Records

      • Mark Conway Munro

      Pages 61-97

      PDF

   6. Transferring Data

      • Mark Conway Munro

      Pages 99-116

      PDF

3. Defining Data Structures

   1. Front Matter

      Pages 117-117

      PDF

   2. Working with Database Files

      • Mark Conway Munro

      Pages 119-153

      PDF

   3. Working with Tables

      • Mark Conway Munro

      Pages 155-170

      PDF

   4. Defining Fields

      • Mark Conway Munro

      Pages 171-201

      PDF

   5. Connecting Tables with Relationships

      • Mark Conway Munro

      Pages 203-232

      PDF

   6. Managing Containers

      • Mark Conway Munro

      Pages 233-242

      PDF

   7. Managing Value Lists

      • Mark Conway Munro

      Pages 243-254

      PDF

4. Writing Formulas and Using Functions

   1. Front Matter

      Pages 255-255

      PDF

   2. Writing Formulas

      • Mark Conway Munro

      Pages 257-290

      PDF

   3. Text Functions

      • Mark Conway Munro

      Pages 291-312

      PDF

   4. Text Functions (JSON)

      • Mark Conway Munro

      Pages 313-320

      PDF

   5. Text Formatting Functions

      • Mark Conway Munro

      Pages 321-326

      PDF

   6. Number Functions

      • Mark Conway Munro

      Pages 327-334

      PDF

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. 

• Filemaker
• SQL
• Database
• Scripting
• Tables

• Lewisburg, USA

  Mark Conway Munro

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

Policies and ethics