Filemaker 8 Functions And Scripts Desk Reference

by Love, Scott; Lane, Steve; Bowers, Bob

• ISBN13: 9780789735119
• ISBN10: 0789735113
• Edition: 1st
• Format: Paperback
• Copyright: 2006-02-21
• Publisher: Que Pub

Summary

"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.

Author Biography

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."

Table of Contents

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

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> Introduction Introduction Welcome to the FileMaker 8 Desk Reference Just the Facts, 8 to the PointThis is the book we want on our desks--even after writing it. Just as a writer always needs a dictionary nearby, we've found over the years that it would be great to have a quick set of reminders within reach. It's impossible to recall each function's syntax, or every script step's attributes. Although we use the Let() function every day, the exact output of RelationInfo() can be a little less fresh in our minds. This desk reference contains notes on all the script steps and calculation functions in FileMaker, and provides lists of other facts like error codes, port numbers, XML grammar, and more. This book will provide invaluable assistance to like-addle-minded developers everywhere, regardless of one's experience with FileMaker. Help Is a Function Key AwayBefore going any further, we'd like to congratulate the tech writers, engineers, and product managers at FileMaker, Inc. for an excellent help system and set of both printed and electronic documentation. If you've never used FileMaker's help resources or website, you're missing a wealth of information. Both are fantastic places to learn, refresh your memory, or uncover areas of FileMaker you had no idea were there.Sometimes, however, it's nice to leave what's on your screen unchanged, keep your work and your reference material separate, and be able to turn to actual paper. (It's hard to take notes in the help system, for example!)Some of this book may overlap a bit with the help system, especially in cases where there's really nothing more to add: for example, as in the Abs() function. Where we hope this book will prove useful is in the additional information and examples we're able to provide, the fact that it's collected all here on paper, and that it's a bit more accessible during those times when you may not be in front of Fil