Filemaker 8 Functions And Scripts Desk

"Think of this as the dictionary for FileMaker developers: it delivers a complete reference on the nuts-and-bolts of working with FileMaker. Use it to look up the syntax of a function, review real-world examples of scripts, and track down details like port numbers and error codes. It is an invaluable resource for professional developers with years of experience or beginners looking to learn how to build great FileMaker databases."--BOOK JACKET.

Scott Love is Vice President and manager of Soliant Consulting's California office. He co-authored Que Publishing's Special Edition Using FileMaker Pro 7 and is an authorized Professional Training Foundation Series instructor. Steve Lane is Vice President and manager of one of Soliant Consulting's Chicago area development teams. He has written for FileMaker Advisor magazine, and co-authored Advanced FileMaker Pro 6 Web Development and Que's Special Edition Using FileMaker Pro 7. He was awarded the FileMaker Fellowship Award in 2003 for "pushing the boundaries of FileMaker Pro."

Welcome to the FileMaker 8 Desk Reference

1

(6)

Just the Facts, 8 to the Point

1

(1)

How This Book Is Organized

2

(5)

I FileMaker Specifications

1 FileMaker 8 Product Line

7

(4)

Overview of FileMaker Products

7

(4)

FileMaker Pro 8

7

(1)

FileMaker Pro 8 Advanced

7

(1)

FileMaker Server 8

8

(1)

FileMaker Server 8 Advanced

8

(1)

FileMaker Mobile 8

9

(2)

2 Specifications and Storage Limits

11

(2)

Knowing Your Limits

11

(2)

3 Field Types and Import/Export Formats

13

(12)

Knowing Your Data

13

(1)

FileMaker Field Types

13

(3)

Text

13

(1)

Number

14

(1)

Date

14

(1)

Time

15

(1)

Timestamp

15

(1)

Container

15

(1)

Calculation

16

(1)

Summary

16

(1)

Importing Data

16

(4)

File-Based Data Sources

17

(1)

Importing from Excel

17

(1)

Importing from FileMaker

17

(1)

Importing Multiple Files at Once

18

(1)

Importing from Multiple Text Files

18

(1)

Importing from Multiple Image Files

18

(1)

Importing Digital Photos (Mac OS)

19

(1)

Importing from an ODBC Data Source

19

(1)

Importing from an XML Data Source

20

(1)

Creating New Tables on Import

20

(1)

Exporting Data

20

(5)

Exporting to HTML

21

(1)

Exporting to FileMaker Pro

21

(1)

Exporting to Excel

21

(1)

Automatically Opening or Emailing Exported Files

21

(4)

II Calculation Functions

4 Working with Calculations Primer

25

(4)

The Calculation Function Interface

25

(4)

Calculations: Things to Remember

26

(3)

5 Calculation Signatures

29

(10)

Aggregate Functions

29

(1)

Date Functions

29

(1)

Design Functions

30

(1)

External Functions

31

(1)

Financial Functions

31

(1)

Get Functions

31

(3)

Logical Functions

34

(1)

Number Functions

34

(1)

Repeating Functions

35

(1)

Summary Functions

35

(1)

Text Functions

35

(2)

Text Formatting Functions

37

(1)

Time Functions

37

(1)

Timestamp Functions

38

(1)

Trigonometric Functions

38

(1)

6 Calculation Functions

39

(160)

III Custom Functions

7 Custom Functions Primer

199

(4)

The Custom Function Interface

200

(3)

Custom Functions: Things to Remember

200

(3)

8 Useful Custom Functions

203

Number Calculations

203

(4)

Date Calculations

207

(3)

Text and Data Conversions

210

(14)

Email Tools

224

(2)

List Handlers

226

(8)

Developer Tools

234

(3)

System Constants

237

(2)

Toolkit for Complex Data Structures

239

(1)

Data API Within FileMaker

239

(1)

Data Tree

239

(1)

Using XML as a Data Structure

240

(1)

Path-Based Selections

241

(3)

The Functions

244

(17)

IV Script Steps

9 Scripting Primer

261

(6)

About FileMaker Scripting

261

(6)

The ScriptMaker Interface

261

(1)

Where Scripts Live

261

(2)

Script Privileges

263

(1)

Organizing Scripts

263

(1)

Debugging Scripts

263

(1)

Scripting for the Web

264

(3)

10 Script Step Reference

267

(106)

About the Script Step Reference

267

(106)

V Quick Reference

11 FileMaker Error Codes

373

(8)

Error Codes in FileMaker

373

(8)

FileMaker Error Codes

373

(6)

Web Publishing Engine Error Codes

379

(2)

12 FileMaker Keyboard Shortcuts

381

(18)

Working Quickly, Saving Time

381

(1)

Essential Shortcuts by Group

382

(6)

Keyboard Essentials

382

(1)

Navigation

383

(1)

Data Entry and Formatting

383

(1)

Defining Fields

384

(1)

Working with the Relationships Graph

385

(1)

Working with Layouts

385

(2)

Scripting

387

(1)

Navigating the FileMaker Interface

387

(1)

Menu Reference

388

(11)

13 FileMaker Network Ports

About Network Ports

399

(1)

FileMaker Network Ports

399

(2)

14 FileMaker Server Command Line Reference

401

(12)

Administering FileMaker Server from the Command Line

401

(1)

Command Line Reference

402

(11)

FileMaker Server Command Line Reference

402

(11)

15 FileMaker XML Reference

413

(16)

About FileMaker and XML

413

(1)

URL Syntax for Web Access to FileMaker Data

413

(2)

URL Syntax for XML Access

414

(1)

URL Syntax for Access to Container Objects

414

(1)

URL Syntax for XSLT Access

415

(1)

FileMaker XML Grammars

415

(4)

FMPXMLRESULT

416

(1)

FMPDSORESULT

417

(1)

fmresultset

417

(1)

FMPXMLLAYOUT

418

(1)

Query Parameters for XML/XSLT URL Requests

419

(7)

Query Commands

420

(2)

Query Parameters

422

(4)

FileMaker XML and XSLT Namespaces

426

(3)

VI Other Resources

16 Where to Go for More Information

429

(8)

FileMaker

429

(1)

General Information on Relational Databases

429

(1)

Data Modeling and Database Design

429

(1)

Project Management, Programming, and Software Development

430

(1)

Running a FileMaker Consulting Practice

430

(1)

General Resources for Tips and Tricks

431

(1)

Hosting FileMaker Databases on the Web

432

(1)

FileMaker News Sources

432

(1)

Plug-ins

432

(2)

Developer Tools

434

(1)

Web Programming

435

(1)

XML/XSL

435

(1)

PHP

436

(1)

ODBC/JDBC

436

(1)

Index

437

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Filemaker 8 Functions And Scripts Desk Reference

Summary

Author Biography

Table of Contents

Supplemental Materials