- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
The new FileMaker 12 allows you to build unparalleled databases for a wide variety of devices, from Windows and Mac desktops to iPhones and iPad. With 10 million registered customers, FileMaker's users are "average Joes" who are knowledge workers, subject matter experts, and business users from all walks of life. The community extends well beyond the pool of professional software developers. FileMaker's legendary ease-of-use has led to its wide adoption and has allowed non-programmers an avenue into creating sophisticated software solutions. FileMaker 12 Developer's Reference will serve to help bridge the gaps in these people's understanding of FileMaker's hundreds of calculation functions, script steps, and operations. They know FileMaker, they've used it for years, but they need a quick reference, immediately accessible while not interrupting their work on screen.There is no other book like this on the market. All FileMaker books include information on calculation formulas, scripting, etc., but none have expressly focused on giving readers one simple thing: a quick reference to be used in conjunction with their programming efforts. Some books teach, others explain, still others explore specific in-depth topics. This book will appeal to the entire FileMaker Pro community and be a great extension of their library. This edition is updated for the many new features coming with FileMaker 12, including the product's design functionality and the file format, and a new section dedicated to FileMaker Go, which is the iOS client.
Contents
Introduction. . . . . . . . . . .1How This Book Is Organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2Part I: FileMaker Specifications . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . .2Part II: Layout Tools & Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2Part III: Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2Part IV: Script Steps & Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2Part V: FileMaker Go . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . .3Part VI: FileMaker Connectivity . . . . . . . . . . . . . . . . . . . .3Part VII: Quick Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3Part VIII: Other Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4Special Features . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .4Typographic Conventions Used in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4Key Combinations and Menu Choices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4Typographic Conventions Used for FileMaker Scripts . . . . . . . . . . . . . . . . .5Who Should Use This Book . . . . . . . . . . . . . . . . . . . . . . . . . .5Part I: FileMaker Specifications1 FileMaker 12 Product Line . . . . . . . . . . . . . . . .7FileMaker Pro 12 . . . . . . . . . . . . . . . . . . . . . . . . . .7FileMaker Pro 12 Advanced . . . . . . . . .. . . . . . . . . . . .7FileMaker Server 12 . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8FileMaker Server 12 Advanced . . . . . . . . . . . . . . . .8FileMaker Go 12 . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . .9FileMaker Go 12 for iPad . . . . . . . . . . . . . . . . . . .92 FileMaker 12 New Features . . . . . . . . . . . . .11New File Format . . . . . . . . . . . . . . . .. . . . . . . . .11FileMaker Pro/Advanced 12 . . . . . . . . . . . . . . . . . . . . .12Themes . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . .12Enhanced Container Fields . . . . . . . . . . . . . . . . . . . .13Enhanced Charting Features . . . . . . . . . . . . . . . . . . . . . . . . . .14Advanced Window Styles . . . . . . . . . . . . . . . . . . . . .14Plug-in Updating . . . . . . . . . . . . . . . . . . . . . . . . .15ExecuteSQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15And More... . . . . . . . . . . . . . . . . . . . . . . . . .16FileMaker Server/Advanced 12 . . . . . . . . . . . . . . . . . . . . . . . .17Improved WAN Performance . . . . . . . . . . . . .1764-bit Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17Rewritten Web Engine . . . . . . . . . . . . .. . . . . .17Backup Improvements . . . . . . . . . . . . . . . . . . .18Managed Container Fields . . . . . . . . . . . . . . . . . . . . . . . . . .19Progressive Media Download . . . . . . . . . . . . . . . . . . . . . . .20Group Start Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .20FileMaker Go/Go for iPad . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21Multitasking Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21Improved Media Integration . . . . . . . . . . . . . . . . . . . . . . . . .21Export Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22Location Functions . . . . . . . . . . . . . . . . . . . . . .223 Specifications and Storage Limits . . . . . . . .. . . . . . . . . . . . .23Knowing Your Limits . . . . . . . . . . . . . . . . . . . . . .23External SQL Sources (ESS) Specifications . . . . . . . . . . . . . . . . .254 Field Types and Import/Export Formats . . . . . . .. . . . . . . . . . . . .27FileMaker Field Types . . . . . . . . . . . . . . . . . . . . . . . .28Text . . . . . . . . . . . . . . . . . . . . . . . . . . .28Number . . . . . . . .. . . . . . . . . .29Date . . . . . . . . . . . . . . . . . . . . . . . . . .29Time . . . . . . . . . . . . . .. . . . . . . . . . .30Timestamp . . . . . . . . . . . . . . . . . . .31Container . . . . . . . . . . . . . . . . . . . . .31Calculation . . . . . . . . . . . . . . . . . . .34Summary . . . . . . . . . . . . . . . . . . . . . .34Additional ESS References . . . . . . .. . . . . . . . . . .35Importing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35File-Based Data Formats . . . . . . . . . . . . . . . . . . . . . .35Importing Multiple Files at Once . . . . . . . . . . . . . . . . . . . . . . . . .36Importing from an ODBC Data Source . . . . . . . . . . . . . . .37Importing from an XML-Based Data Source . . . . . . . . . . . . . . .38Creating New Tables on Import . . . . . . .. . . . . . . . . .39Exporting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . .39Exporting to HTML . . . . . . . . . . . . . . . . . . .39Exporting to FileMaker Pro . . . . . . . . . . . . . . . . . . . . . .39Exporting to Excel . . . . . . . . . . . . . . . . . . . . .40Exporting to XML . . . . . . . .. . . . . . . . . . . . .40Automatically Opening or Emailing Exported Files . . . . . . .. . . . . . . . . .40Part II: Layout Tools & Objects5 Layout Tools . . . . . .. . . . . . . . . . . .41About Layouts . . . . . . . . . . . . . . . . . . . .41The Layout Setup Dialog . . . . . . .. . . . . . .41Layout Themes . . . . . . . . . . . . . . . . . .43Organizing Layouts . . . . . . . . . . . . . . . . . . .44The Inspector . . . . . . . . . . . . . . . . . . . . . . . .45Position Tab . . . . . . . . . . . . . . . . . . . . . .45Appearance . . . . . . . . . .. . . . . . . . . .50Data . . . . . . . . . . . . . . . . . . . . . . . . . . . .53Additional Object Formatting . . . . .. . . . . . . . . . . . . . .56Button Setup . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . .57Conditional Formatting . . . . . . . . . . . . . . . .57Script Triggers . . . . . . . . . . . . . . . . . . . . . . .58Accessibility Inspector . . . . . . . . . . . . . .586 Charting . . . . . . . . . . . . . . . . . . . .59Creating Charts . . . . . . . .. . . . . . . . . . . .59Quick Charts . . . . . . . . . . . . . . . . . . . . . . . . . . .60The Chart Tool . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .61Specifying a Chart's Data Source . . . . . . . . . . . . . . . . . . . . . .61Current Found Set - Summarized Groups of Records . . . . . . . . . . . . . . . . . .62Current Found Set - Individual Record Data . . . . . . . . . . . . .62Current Record (Delimited Data) . . . . . . . . . . . . . . .64Related Records . . . . . . . . . . . . . . . . . . .64Chart Types . . . . . . . . . . . . . . . . . . . . . . . . . . . .65Chart Styles . . . . . . . . . . . . . . . . . . . . . . . . . . .66Tips for Effective Charting . . . . . . . . . . . . .. . . . . . . . . . . . .677 Other Layout Objects . . . . . . . . . . . . . .69Tab Controls . . . . . . . . . . . . . . . . . . . . . . .70Formatting a Tab Control . . . . . .. . . . . . .71Autosizing of Tab Controls . . . . . . . . . . . . . . . . . .72Other Tab Control Notes . . . . . . . . . . . . . . . .72Portals . . . . . . . . .. . . . . . . . . . . . . . .73Portal Setup . . . . . . . . . . . . . . . . . . . . . . .73Working with Records in a Portal . . . . . . . . . . .75Autosizing of Portals . . . . . . . . . . . . . . .76Other Notes About Portals . . . . . . . . . . . . . .76Web Viewer . . . . . . . . . .. . . . . .77Setting a Web Viewer via Script . . . . . . . . .79Other Web Viewer Notes . . . . . . . . . . . . . . . . .79Part III: Functions8 Calculation Primer . . . . . . . . . . . . . . . . . . . . . .81The Calculation Function Interface . . . . . . . . . . . . . . .81Calculations: Things to Remember . . . . .. .829 Calculation Signatures . . . . . . . . . . .87Aggregate Functions . . . . . . . . . . . . . . .87Container Functions . . . . . . . . . . . . . . . .87Date Functions . . . . . . . . . .. . . . . . . . . . .88Design Functions . . . . . . . . . . . . . . . . . . . . . .88External Functions . . . . . . . . . . . . . . . . . . . . .89Financial Functions . . . . . . . .. . . . . . . . . . . .89Get Functions . . . . . . . . . . .. . . . . . . . .90Logical Functions . . . . . . . .. . . . . . .92Mobile Functions . . . . . . . . . . .. . . . . . . . . . . .93Number Functions . . . . . . . . . . . . . . . . . . . . . . .94Repeating Functions . . . . . . . . . .. . . . . . . .94Summary Function . . . . . . . . . . . . . . . . . .95Text Functions . . . . . . . . . . . . . . . . . . . . . .95Text Formatting Functions . . . . . . . . . . . . . . . . .96Time Functions . . . . . . . . . . . . . . . . . . . . . . .97Timestamp Function . . . . . . . .. . . . . .97Trigonometric Functions . . . . . . . . . . . . .9710 Calculation Functions . . . . . . . . . . . . . . . . . . . . . . .9911 Custom Function Primer . . . . . . . . . . . . . . . . .273The Custom Function Interface . . . . . . . . . . . . . . . . . . .274Custom Functions: Things to Remember . . . . . . . . . . . .274Recursive Techniques . . . . . . . . . .. . . . . . . .276Part IV: Script Step Reference12 Scripting Primer . . . . . . . . . . . . . . . . . .279The Manage Scripts Interface . . . . . . . . . . . . . . . . .279Where Scripts Live . . . . . . . . . . . . . . . . . . .280Editing or Creating Scripts . . . . . . . . . . . . . . . .281Organizing Scripts . . . . . . . . . . . . . . . . . .281Filtering Scripts . . . . . . . . . . . . . . . . . .282Script Privileges . . . . . . . . . . . . .. . . . . . . . .282Debugging Scripts . . . . . . . . . . . .. . . . . . . . . .282Scripting for the Web . . . .. . . . . . . . . .284Scripting for FileMaker Go . . . . . . . . . . .285Server Scheduled Scripts . . . . . . . . . . . . . .28513 Script Triggers . . . . . . . . .. . . . . . . . . . . . . .287Setting Script Triggers . . . .. . . . . . . . . . . . . .287File Events . . . . . . . . . . . . . .. . . . . . .287Layout Events . . . . . . . . . . . . . . . . . . .288Object Events . . . . . . . . . .. . . . . . . .289Activating Script Triggers . . . . . . . . . . . . . . . . . . . .290Timing of Script Triggers . . . . . . . . .. . . . . . .291Scripting for Script Triggers . . . . . . . . . . . . . . . . . .293Tab Control Objects . . . . . . . . . . . . .. . . . . . . . . . .294Instant and Custom Web Publishing . . . . . . . . . . . .294Script Trigger Reference . . . . . . . . . . . . . . . . .29514 Script Step Reference . . . . . . . . . . . . . . .311 Part V: FileMaker Go15 FileMaker Go Specifications . . . .. . . . . . . . . . . . . .431Device Compatibility . . . . . . . . . . . . . .431FileMaker Go 12 . . . . . . . . . . . . . . . . . . . . . .431FileMaker Go 12 for iPad . . . . . . . . . . . . . . . . . . . . .431Differences Between FileMaker Go and Pro . . . . . . .. . . . . . . . . .432Limits . . . . . . . . . . . . . . .432Text Fields . . . . . . . . . . . . . . . . . . . . . . . . . .432Container Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . .433Interface Feature Differences . . . . . . . . . . . . .433Export Records . . . . . . . . . . . . . . . . . . . . .436Saving Records as PDF . . . . . . . . . .. . . . . . . .436Script Step Differences . .. . . . . . . . . . . . . . . . . . . .437Security . . . . . . . . . . . . . . . . . . . . . . . . . .438Plug-ins . . . . . . . . . . . . . . . . . . . . . . . . . .43916 Designing for FileMaker Go . . . . . . . . . . . . . . . . .441File Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .441Model 1: An Integrated File . . . . . . . . . . .. . . . . . . . . . . . . . . .442Model 2: A Separate Hosted File . . . . . . . . . . . . . . . .443Model 3: A Separate Local File . . . . . . . . . . . . . . . . .444Model 4: Hybrid . . . . . . . . . . . . . . . . . . . . . . . .444Designing Layouts for FileMaker Go . . . . . . . . . . . . . . . . . . . .444Disabling Pinch-to-Zoom . . . . . . .. . . . . . . . . . . . . . .446Object Sizes . . . . . . . . . . . . . .. . . . . . . . . . . . . .447Font Families . . . . . . . . . . . . . . . . . . . . .447Other Layout Tips . . . . . . . . . . . . .. . . . . . . .448Optimizing Workflows . . . . . . . . . . . . . . . . . . .448Minimalist Approach . . . . . . . . . . . . . .. . . . . . . . . .449Server-side Procedures . . . . . . . . . . . . . . . . . . .451Export Procedures . . . . . . . . . . . . . . . . . . . . . .451Additional Performance Tips . . . . . . . . . . . . . . . . .452Deploying Files . . . . . . . . . . . . . . . . .452Email . . . . . . . . . . . . . . .. . . . . . . . . .452iTunes . . . . . . . . . . . . . . . . . . . . . . . .452Web Download . . . . . . .. . . . . . . . . . . . .453Container Field . . . . . . . . . . . . . . . . . . .453Sync Strategies . . . . . . . . . . . .. . . . . . . . . . . . . .453One-way Synchronization . . . . . . . . . . . . . . . .454Two-way Synchronization . . . . . . . . . . .456Transactional Model . . . . . . . . . . . . . . . . . .457Portal Transaction . . . . . . . . . . . . . . . . . . . .457Text Block Transfer . . . . . . . . . . . . . . . . . . .458Security Plan . . . . . . . . . . . . . .. . . . . . . . .459Secure Connections to FileMaker Server . . . . . . . . . . . . . .461Implications of the Background Behavior . . . . . . . . . . .461Security Tips . . . . . . . . . . . . .. . . . . . . . .462Interacting with Other Apps . . . . . . . . . . . . . . . . . .463FileMaker URL Scheme . . . . . . . . . . . .463Maps and Location . . . . . . .. . . . . .464Dial Phone . . . . . . . . . . . . . . . .466Part VI: Connectivity17 FileMaker XML Reference . . . . . . . . . . . . . . .467URL Syntax for Web Access to FileMaker Data . . . . . . . . . . . . . . . . . .467URL Syntax for XML Access . . . . . . . . . . . . . . . . . .467URL Syntax for Access to Container Objects . . . . . . . . . . . . .468FileMaker XML Grammars . . . . . . . . . . . . . . . .. . . . . .469Query Parameters for XML URL Requests . . . . . . . . . . . . .472Query Commands . . . . . . . . . .. . . . . . .473Query Parameters . . . . . . . . . . . . .474FileMaker XML Namespaces . . . . . . . . . . . . . .47818 FileMaker API for PHP . . . . . . . . . . . . .479Class Overview . . . . . . . . . . . . . . . . . . . . .479Classes and Methods . . . . . . . . . . . . .480FileMaker . . . . . . . . . . . . . . . . . . . . . . . . . . . . .480FileMaker_Command . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .487FileMaker_Command_Add . . . . . . . . . .. . . . . . . . . . . . . . . . . .490FileMaker_Command_CompoundFind . . . . . . . . . . . . . . . . . . . . . . . .490FileMaker_Command_Delete . . . . . . . . . . . . . . . . . . . . . . .492FileMaker_Command_Duplicate . . . . . . . . . . . . . . . . . . . . . . . . . .492FileMaker_Command_Edit . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .493FileMaker_Command_Find . . . . . . . .
