FileMaker® 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples

Maybe you know FileMaker, and you have used it for years, but need a quick reference, immediately accessible while not interrupting your work on screen. This is the only book on the market expressly focused on describing each calculation formula and how and when to use each! Filled with real-world, concrete examples, this book is an invaluable companion to readers working to develop solutions to their every day software problems. Contains hundreds of calculation functions, script steps, and operations that will appeal to every FileMaker user, new and old.

Online Sample Chapter

FileMaker 9's Custom Function Primer

Sample Chapter(s)

Download Chapter 10: Custom Function Primer

Index

Download the Index

Introduction

Download the Introduction

Table of Contents

Introduction Welcome to FileMaker 9

Developer Reference . . . . . . . . . . . . . . . . . . . . . . . 1

1 FileMaker 9 Product Line . . . . . . . . . . . . . . . . . . . 9

2 New Features of FileMaker 9 . . . . . . . . . . . . . . . 13

3 Overview of FileMaker 8.5 Features . . . . . . . . . 21

4 Overview of FileMaker 8 Features . . . . . . . . . . . 25

5 Specifications and Storage Limits . . . . . . . . . . . 33

6 Field Types and Import/Export Formats . . . . . . 37

7 Calculation Primer . . . . . . . . . . . . . . . . . . . . . . . . 53

8 Calculation Signatures . . . . . . . . . . . . . . . . . . . . 59

9 Calculation Functions . . . . . . . . . . . . . . . . . . . . . 69

10 Custom Function Primer . . . . . . . . . . . . . . . . . . 243

11 Useful Custom Functions . . . . . . . . . . . . . . . . . 249

12 Scripting Primer . . . . . . . . . . . . . . . . . . . . . . . . . 331

13 Script Step Reference . . . . . . . . . . . . . . . . . . . . 337

14 FileMaker XML Reference . . . . . . . . . . . . . . . . . 439

15 FileMaker API for PHP . . . . . . . . . . . . . . . . . . . . 453

16 JDBC/ODBC and External SQL Connectivity . . 489

17 AppleScript Integration . . . . . . . . . . . . . . . . . . . 499

18 FileMaker Error Codes . . . . . . . . . . . . . . . . . . . 511

19 FileMaker Keyboard Shortcuts . . . . . . . . . . . . . 521

20 FileMaker Network Ports . . . . . . . . . . . . . . . . . 539

21 FileMaker Server Command Line

Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541

A Additional Resources . . . . . . . . . . . . . . . . . . . . 553

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 561