FileMaker 12 in Depth (In Depth)

FileMaker® 12 In Depth

Do more in less time!

FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features.

•      Use themes to build solutions for FileMaker Pro on Windows and OS X, FileMaker Go

on iOS, and Instant Web Publishing

•      Get the most out of new container field technology

•      Quickly become a FileMaker 12 power user

•      Make the most of FileMaker fields, tables, layouts, and parts

•      Iteratively design reliable, high-performance FileMaker relational databases

•      Work with relationships, including self-joins and cross-product relationships

•      Write calculation formulas and use functions

•      Use event-driven scripts to make databases more interactive

•      Build clear and usable reports, publish them, and incorporate them into workflows

•      Secure applications with user accounts, privileges, file-level access, network security,

and authentication

•      Use FileMaker’s Web Viewer to access live web-based data

•      Convert systems from older versions of FileMaker, and troubleshoot successfully

•      Share, exchange, export, and publish data via SQL and XML

•      Instantly publish databases on the web, and use advanced Custom Web Publishing techniques

•      Trigger automated behaviors whenever specific events occur

•      Extend FileMaker’s functionality with plug-ins

•      Set up, configure, tune, and secure FileMaker Server

All In Depth books offer

•     Comprehensive coverage with detailed solutions

•     Troubleshooting help for tough problems you can’t fix on your own

•     Outstanding authors recognized worldwide for their expertise and teaching style

Learning, reference, problem-solving... the only FileMaker 12 book you need!

FileMaker® 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker on a wide variety of platforms - from Windows and Mac desktops to iPhone and iPad! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features. Quickly become a power user, and then learn how to design reliable, high-performance, multi-user relational databases; write calculation formulas and use functions; increase interactivity with event-driven scripts; build and publish clear and useful reports; systematically secure your applications; share, exchange, export, and publish data via SQL, XML, and the Web; trigger automated behaviors; convert systems from older versions of FileMaker; extend FileMaker 12 with plug-ins; set up, configure, and tune FileMaker Server; and much more. Like all In Depth books, FileMaker® 12 In Depth delivers comprehensive coverage with detailed solutions, and troubleshooting help for tough problems you can’t fix on your own. Learning, reference, problem-solving: it’s the only FileMaker Pro book you need!

Jesse Feiler has worked with FileMaker since its beginnings. He has written a number of books about FileMaker as well as OS X, iOS, iWork, Core Data, Objective-C, and other new technologies. His books have been translated into Japanese, Chinese, Polish, German, Spanish, French, Arabic, Hungarian, and other languages. As software director of North Country Consulting, he has designed and implemented a variety of FileMaker solutions for small businesses and nonprofits in fields such as production, marketing, the arts, printing and publishing, food service, and construction. His meeting management software for iOS devices, MinutesMachine, is published by Champlain Arts Corp (champlainarts.com).

His website is www.northcountryconsulting.com . You can find updates and file downloads there.

1 FileMaker Overview

2 Using FileMarker Pro

3 Defining and Working with Fields

4 Working with Layouts

Part II: Developing Solutions with FileMaker 9

5 Relational Database Design

6 Working with Multiple Tables

7 Working with Relationships

8 Getting Started with Calculations

9 Getting Started with Scripting

10 Getting Started with Reporting

Part III: Developer Techniques

11 Developing for Multiuser Deployment

12 Implementing Security

13 Using the Web Viewer

14 Advanced Interface Techniques

15 Advanced Calculation Techniques

16 Advanced Scripting Techniques

17 Advanced Protal Techniques

18 Advanced FileMaker Solution Architecture

19 Debugging and Troubleshooting

20 Converting Systems from Previous Versions of FileMaker Pro

Part IV: Data Integration and Publishing

21 Integrating FileMaker Pro with Other Databases in Real Time

22 Importing Data into FileMaker Pro

23 Exporting Data from FileMaker

24 Instant Web Publishing

25 Custom Web Publishing with XML/XSLT

26 Custom Web Publishing with PHP

Part V: Deploying a FileMaker Solution

27 Deploying and Extending FileMaker

28 FileMaker Server and Server Advanced

Part VI: Appendix