Table of Contents

Welcome to the FileMaker 8 Desk Reference

Just the Facts, 8 to the Point

How This Book Is Organized

I FileMaker Specifications

1 FileMaker 8 Product Line

Overview of FileMaker Products

FileMaker Pro 8

FileMaker Pro 8 Advanced

FileMaker Server 8

FileMaker Server 8 Advanced

FileMaker Mobile 8

2 Specifications and Storage Limits

Knowing Your Limits

3 Field Types and Import/Export Formats

Knowing Your Data

FileMaker Field Types

Text

Number

Date

Time

Timestamp

Container

Calculation

Summary

Importing Data

File-Based Data Sources

Importing from Excel

Importing from FileMaker

Importing Multiple Files at Once

Importing from Multiple Text Files

Importing from Multiple Image Files

Importing Digital Photos (Mac OS)

Importing from an ODBC Data Source

Importing from an XML Data Source

Creating New Tables on Import

Exporting Data

Exporting to HTML

Exporting to FileMaker Pro

Exporting to Excel

Automatically Opening or Emailing Exported Files

II Calculation Functions

4 Working with Calculations Primer

The Calculation Function Interface

Calculations: Things to Remember

5 Calculation Signatures

Aggregate Functions

Date Functions

Design Functions

External Functions

Financial Functions

Get Functions

Logical Functions

Number Functions

Repeating Functions

Summary Functions

Text Functions

Text Formatting Functions

Time Functions

Timestamp Functions

Trigonometric Functions

6 Calculation Functions

III Custom Functions

7 Custom Functions Primer

The Custom Function Interface

Custom Functions: Things to Remember

8 Useful Custom Functions

Number Calculations

Date Calculations

Text and Data Conversions

Email Tools

List Handlers

Developer Tools

System Constants

Toolkit for Complex Data Structures

Data API Within FileMaker

Data Tree

Using XML as a Data Structure

Path-Based Selections

The Functions

IV  Script Steps

9 Scripting Primer

About FileMaker Scripting

The ScriptMaker Interface

Where Scripts Live

Script Privileges

Organizing Scripts

Debugging Scripts

Scripting for the Web

10 Script Step Reference

About the Script Step Reference

V Quick Reference

11 FileMaker Error Codes

Error Codes in FileMaker

FileMaker Error Codes

Web Publishing Engine Error Codes

12 FileMaker Keyboard Shortcuts

Working Quickly, Saving Time

Essential Shortcuts by Group

Keyboard Essentials

Navigation

Data Entry and Formatting

Defining Fields

Working with the Relationships Graph

Working with Layouts

Scripting

Navigating the FileMaker Interface

Menu Reference

13 FileMaker Network Ports

About Network Ports

FileMaker Network Ports

14 FileMaker Server Command Line Reference

Administering FileMaker Server from the Command Line

Command Line Reference

FileMaker Server Command Line Reference

15 FileMaker XML Reference

About FileMaker and XML

URL Syntax for Web Access to FileMaker Data

URL Syntax for XML Access

URL Syntax for Access to Container Objects

URL Syntax for XSLT Access

FileMaker XML Grammars

FMPXMLRESULT

FMPDSORESULT

fmresultset

FMPXMLLAYOUT

Query Parameters for XML/XSLT URL Requests

Query Commands

Query Parameters

FileMaker XML and XSLT Namespaces

VI Other Resources

16 Where to Go for More Information

FileMaker

General Information on Relational Databases

Data Modeling and Database Design

Project Management, Programming, and Software Development

Running a FileMaker Consulting Practice

General Resources for Tips and Tricks

Hosting FileMaker Databases on the Web

FileMaker News Sources

Plug-ins

Developer Tools

Web Programming

XML/XSL

PHP

ODBC/JDBC

Index