| 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) |
|
|
|
7 | (1) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
FileMaker Server 8 Advanced |
|
|
8 | (1) |
|
|
|
9 | (2) |
|
2 Specifications and Storage Limits |
|
|
11 | (2) |
|
|
|
11 | (2) |
|
3 Field Types and Import/Export Formats |
|
|
13 | (12) |
|
|
|
13 | (1) |
|
|
|
13 | (3) |
|
|
|
13 | (1) |
|
|
|
14 | (1) |
|
|
|
14 | (1) |
|
|
|
15 | (1) |
|
|
|
15 | (1) |
|
|
|
15 | (1) |
|
|
|
16 | (1) |
|
|
|
16 | (1) |
|
|
|
16 | (4) |
|
|
|
17 | (1) |
|
|
|
17 | (1) |
|
|
|
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) |
|
|
|
20 | (5) |
|
|
|
21 | (1) |
|
Exporting to FileMaker Pro |
|
|
21 | (1) |
|
|
|
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) |
|
|
|
29 | (10) |
|
|
|
29 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (1) |
|
|
|
31 | (1) |
|
|
|
31 | (1) |
|
|
|
31 | (3) |
|
|
|
34 | (1) |
|
|
|
34 | (1) |
|
|
|
35 | (1) |
|
|
|
35 | (1) |
|
|
|
35 | (2) |
|
Text Formatting Functions |
|
|
37 | (1) |
|
|
|
37 | (1) |
|
|
|
38 | (1) |
|
|
|
38 | (1) |
|
|
|
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 | |
|
|
|
203 | (4) |
|
|
|
207 | (3) |
|
Text and Data Conversions |
|
|
210 | (14) |
|
|
|
224 | (2) |
|
|
|
226 | (8) |
|
|
|
234 | (3) |
|
|
|
237 | (2) |
|
Toolkit for Complex Data Structures |
|
|
239 | (1) |
|
Data API Within FileMaker |
|
|
239 | (1) |
|
|
|
239 | (1) |
|
Using XML as a Data Structure |
|
|
240 | (1) |
|
|
|
241 | (3) |
|
|
|
244 | (17) |
| IV Script Steps |
|
|
|
|
261 | (6) |
|
About FileMaker Scripting |
|
|
261 | (6) |
|
The ScriptMaker Interface |
|
|
261 | (1) |
|
|
|
261 | (2) |
|
|
|
263 | (1) |
|
|
|
263 | (1) |
|
|
|
263 | (1) |
|
|
|
264 | (3) |
|
|
|
267 | (106) |
|
About the Script Step Reference |
|
|
267 | (106) |
| V Quick Reference |
|
|
|
|
373 | (8) |
|
|
|
373 | (8) |
|
|
|
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) |
|
|
|
382 | (1) |
|
|
|
383 | (1) |
|
Data Entry and Formatting |
|
|
383 | (1) |
|
|
|
384 | (1) |
|
Working with the Relationships Graph |
|
|
385 | (1) |
|
|
|
385 | (2) |
|
|
|
387 | (1) |
|
Navigating the FileMaker Interface |
|
|
387 | (1) |
|
|
|
388 | (11) |
|
13 FileMaker Network Ports |
|
|
|
|
|
399 | (1) |
|
|
|
399 | (2) |
|
14 FileMaker Server Command Line Reference |
|
|
401 | (12) |
|
Administering FileMaker Server from the Command Line |
|
|
401 | (1) |
|
|
|
402 | (11) |
|
FileMaker Server Command Line Reference |
|
|
402 | (11) |
|
15 FileMaker XML Reference |
|
|
413 | (16) |
|
|
|
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) |
|
|
|
415 | (4) |
|
|
|
416 | (1) |
|
|
|
417 | (1) |
|
|
|
417 | (1) |
|
|
|
418 | (1) |
|
Query Parameters for XML/XSLT URL Requests |
|
|
419 | (7) |
|
|
|
420 | (2) |
|
|
|
422 | (4) |
|
FileMaker XML and XSLT Namespaces |
|
|
426 | (3) |
| VI Other Resources |
|
|
16 Where to Go for More Information |
|
|
429 | (8) |
|
|
|
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) |
|
|
|
432 | (1) |
|
|
|
432 | (2) |
|
|
|
434 | (1) |
|
|
|
435 | (1) |
|
|
|
435 | (1) |
|
|
|
436 | (1) |
|
|
|
436 | (1) |
| Index |
|
437 | |