Muutke küpsiste eelistusi

FileMaker 12 Developers Reference: Functions, Scripts, Commands, and Grammars [Pehme köide]

3.69/5 (20 hinnangut Goodreads-ist)
, , ,
  • Formaat: Paperback / softback, 672 pages, kõrgus x laius x paksus: 230x180x35 mm, kaal: 1052 g
  • Ilmumisaeg: 13-Sep-2012
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789748479
  • ISBN-13: 9780789748478
Teised raamatud teemal:
  • Pehme köide
  • Hind: 59,94 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
FileMaker 12 Developers Reference: Functions, Scripts, Commands, and GrammarsSuurem pilt
  • Formaat: Paperback / softback, 672 pages, kõrgus x laius x paksus: 230x180x35 mm, kaal: 1052 g
  • Ilmumisaeg: 13-Sep-2012
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789748479
  • ISBN-13: 9780789748478
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780789748478.html
Provides information on using FileMaker 12 to build databases for desktops, the Web, and iOS.

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.

Introduction: Welcome to FileMaker 12 Developer Reference 1(6)
How This Book Is Organized
2(2)
Part I FileMaker Specifications
2(1)
Part II Layout Tools & Objects
2(1)
Part III Functions
2(1)
Part IV Script Steps & Triggers
2(1)
Part V FileMaker Go
3(1)
Part VI FileMaker Connectivity
3(1)
Part VII Quick Reference
3(1)
Part VIII Other Resources
4(1)
Special Features
4(1)
Typographic Conventions Used in This Book
4(1)
Key Combinations and Menu Choices
4(1)
Typographic Conventions Used for FileMaker Scripts
5(1)
Who Should Use This Book
5(2)
Part I FileMaker Specifications
1 FileMaker 12 Product Line
7(4)
FileMaker Pro 12
7(1)
FileMaker Pro 12 Advanced
7(1)
FileMaker Server 12
8(1)
FileMaker Server 12 Advanced
8(1)
FileMaker Go 12
9(1)
FileMaker Go 12 for iPad
9(2)
2 FileMaker 12 New Features
11(12)
New File Format
11(1)
FileMaker Pro/Advanced 12
12(1)
Themes
12(1)
Enhanced Container Fields
13(1)
Enhanced Charting Features
14(1)
Advanced Window Styles
14(1)
Plug-in Updating
15(1)
ExecuteSQL
15(1)
And More
16(1)
FileMaker Server/Advanced 12
17(1)
Improved WAN Performance
17(1)
64-bit Application
17(1)
Rewritten Web Engine
17(1)
Backup Improvements
18(1)
Managed Container Fields
19(1)
Progressive Media Download
20(1)
Group Start Page
20(1)
FileMaker Go/Go for iPad
21(1)
Multitasking Support
21(1)
Improved Media Integration
21(1)
Export Data
22(1)
Location Functions
22(1)
3 Specifications and Storage Limits
23(4)
Knowing Your Limits
23(2)
External SQL Sources (ESS) Specifications
25(2)
4 Field Types and Import/Export Formats
27(14)
FileMaker FieldTypes
28(1)
Text
28(1)
Number
29(1)
Date
29(1)
Time
30(1)
Timestamp
31(1)
Container
31(3)
Calculation
34(1)
Summary
34(1)
Additional ESS References
35(1)
Importing Data
35(1)
File-Based Data Formats
35(1)
Importing Multiple Files at Once
36(1)
Importing from an ODBC Data Source
37(1)
Importing from an XML-Based Data Source
38(1)
Creating New Tables on Import
39(1)
Exporting Data
39(1)
Exporting to HTML
39(1)
Exporting to FileMaker Pro
39(1)
Exporting to Excel
40(1)
Exporting to XML
40(1)
Automatically Opening or Emailing Exported Files
40(1)
Part II Layout Tools & Objects
5 Layout Tools
41(18)
About Layouts
41(1)
The Layout Setup Dialog
41(2)
Layout Themes
43(1)
Organizing Layouts
44(1)
The Inspector
45(1)
Position Tab
45(5)
Appearance
50(3)
Data
53(3)
Additional Object Formatting
56(1)
Button Setup
57(1)
Conditional Formatting
57(1)
Script Triggers
58(1)
Accessibility Inspector
58(1)
6 Charting
59(10)
Creating Charts
59(1)
Quick Charts
60(1)
The Chart Tool
61(1)
Specifying a Chart's Data Source
61(1)
Current Found Set -- Summarized Groups of Records
62(1)
Current Found Set -- Individual Record Data
62(2)
Current Record (Delimited Data)
64(1)
Related Records
64(1)
Chart Types
65(1)
Chart Styles
66(1)
Tips for Effective Charting
67(2)
7 Other Layout Objects
69(12)
Tab Controls
70(1)
Formatting a Tab Control
71(1)
Autosizing of Tab Controls
72(1)
Other Tab Control Notes
72(1)
Portals
73(1)
Portal Setup
73(2)
Working with Records in a Portal
75(1)
Autosizing of Portals
76(1)
Other Notes About Portals
76(1)
Web Viewer
77(2)
Setting a Web Viewer via Script
79(1)
Other Web Viewer Notes
79(2)
Part III Functions
8 Calculation Primer
81(6)
The Calculation Function Interface
81(1)
Calculations: Things to Remember
82(5)
9 Calculation Signatures
87(12)
Aggregate Functions
87(1)
Container Functions
87(1)
Date Functions
88(1)
Design Functions
88(1)
External Functions
89(1)
Financial Functions
89(1)
Get Functions
90(2)
Logical Functions
92(1)
Mobile Functions
93(1)
Number Functions
94(1)
Repeating Functions
94(1)
Summary Function
95(1)
Text Functions
95(1)
Text Formatting Functions
96(1)
Time Functions
97(1)
Timestamp Function
97(1)
Trigonometric Functions
97(2)
10 Calculation Functions
99(174)
11 Custom Function Primer
273(6)
The Custom Function Interface
274(1)
Custom Functions: Things to Remember
274(2)
Recursive Techniques
276(3)
Part IV Script Step Reference
12 Scripting Primer
279(8)
The Manage Scripts Interface
279(1)
Where Scripts Live
280(1)
Editing or Creating Scripts
281(1)
Organizing Scripts
281(1)
Filtering Scripts
282(1)
Script Privileges
282(1)
Debugging Scripts
282(2)
Scripting for the Web
284(1)
Scripting for FileMaker Go
285(1)
Server Scheduled Scripts
285(2)
13 Script Triggers
287(24)
Setting Script Triggers
287(1)
File Events
287(1)
Layout Events
288(1)
Object Events
289(1)
Activating Script Triggers
290(1)
Timing of Script Triggers
291(2)
Scripting for Script Triggers
293(1)
Tab Control Objects
294(1)
Instant and Custom Web Publishing
294(1)
Script Trigger Reference
295(16)
14 Script Step Reference
311(120)
Part V FileMaker Go
15 FileMaker Go Specifications
431(10)
Device Compatibility
431(1)
FileMaker Go 12
431(1)
FileMaker Go 12 for iPad
431(1)
Differences Between FileMaker Go and Pro
432(1)
Limits
432(1)
Text Fields
432(1)
Container Fields
433(1)
Interface Feature Differences
433(3)
Export Records
436(1)
Saving Records as PDF
436(1)
Script Step Differences
437(1)
Security
438(1)
Plug-ins
439(2)
16 Designing for FileMaker Go
441(26)
File Architecture
441(3)
Model 1 An Integrated File
442(1)
Model 2 A Separate Hosted File
443(1)
Model 3 A Separate Local File
444(1)
Model 4 Hybrid
444(1)
Designing Layouts for FileMaker Go
444(2)
Disabling Pinch-to-Zoom
446(1)
Object Sizes
447(1)
Font Families
447(1)
Other Layout Tips
448(1)
Optimizing Workflows
448(1)
Minimalist Approach
449(2)
Server-side Procedures
451(1)
Export Procedures
451(1)
Additional Performance Tips
452(1)
Deploying Files
452(1)
Email
452(1)
iTunes
452(1)
Web Download
453(1)
Container Field
453(1)
Sync Strategies
453(1)
One-way Synchronization
454(2)
Two-way Synchronization
456(1)
Transactional Model
457(1)
Portal Transaction
457(1)
Text Block Transfer
458(1)
Security Plan
459(2)
Secure Connections to FileMaker Server
461(1)
Implications of the Background Behavior
461(1)
Security Tips
462(1)
Interacting with Other Apps
463(1)
FileMaker URL Scheme
463(1)
Maps and Location
464(2)
Dial Phone
466(1)
Part VI Connectivity
17 FileMaker XML Reference
467(12)
URL Syntax for Web Access to FileMaker Data
467(1)
URL Syntax for XML Access
467(1)
URL Syntax for Access to Container Objects
468(1)
FileMaker XML Grammars
469(3)
Query Parameters for XML URL Requests
472(1)
Query Commands
473(1)
Query Parameters
474(4)
FileMaker XML Namespaces
478(1)
18 FileMaker API for PHP
479(40)
Class Overview
479(1)
Classes and Methods
480(1)
FileMaker
480(39)
FileMaker_Command
487(3)
FileMaker_Command_Add
490(1)
FileMaker_Command_CompoundFind
490(2)
FileMaker_Command_Delete
492(1)
FileMaker_Command_Duplicate
492(1)
FileMaker_Command_Edit
493(1)
FileMaker_Command_Find
494(2)
FileMaker_Command_FindAll
496(1)
FileMaker_Command_FindAny
496(1)
FileMaker_Command_FindRequest
496(1)
FileMaker_Command_PerformScript
497(1)
FileMaker_Error
497(1)
FileMaker_Error_Validation
498(2)
FileMaker_Field
500(5)
FileMaker_Layout
505(4)
FileMaker_Record
509(4)
FileMaker_RelatedSet
513(2)
FileMaker_Result
515(4)
19 JDBC/ODBC and External SQL Connectivity
519(14)
Setting Up Inbound ODBC and JDBC Connectivity
519(1)
Configuring a Database for ODBC/JDBC Access
519(2)
Enabling ODBC/JDBC Access in FileMaker Pro
521(1)
Enabling ODBC/JDBC Access in FileMaker Server Advanced
521(1)
Setting Up a DSN for External SQL Connectivity
522(1)
Setting Up a DSN for the Mac OS
522(4)
Setting Up a DSN in Windows
526(4)
Using an External Data Source Within FileMaker
530(3)
20 AppleScript Integration
533(10)
The AppleScript Interface
534(3)
About the AppleScript Object Model
537(3)
AppleScript Examples
540(1)
Other Resources
541(2)
Part VII Quick Reference
21 FileMaker Error Codes
543(10)
22 FileMaker Version and Feature History
553(16)
Calculation Functions
553(7)
Script Steps
560(4)
Script Triggers
564(1)
Other Features
565(4)
23 FileMaker Keyboard Shortcuts
569(18)
Essential Shortcuts by Group
569(1)
Keyboard Essentials
569(2)
Navigation
571(1)
Data Entry and Formatting
571(1)
Managing Fields
572(1)
Working with the Relationships Graph
573(1)
Working with Layouts
573(2)
Scripting
575(1)
Navigating the FileMaker Interface
575(1)
Menu Reference
576(1)
File Menu
576(1)
FileMaker Pro Menu (Mac OS Only)
577(3)
Insert Menu
580(2)
Layouts Menu (Layout Mode Only)
582(1)
Records Menu
583(1)
Requests Menu (Find Mode Only)
583(1)
Arrange Menu (Layout Mode Only)
584(1)
Scripts Menu
584(1)
Tools Menu (FileMaker Pro Advanced Only)
585(1)
Window Menu
585(1)
Help Menu
586(1)
24 FileMaker Network Ports
587(2)
25 FileMaker Server Command-Line Reference
589(12)
Administering FileMaker Server from the Command Line
589(1)
FileMaker Server Command-Line Reference
590(11)
Appendix A Additional Resources
601
General Information on Relational Databases
601(1)
Data Modeling and Database Design
602(1)
Project Management, Programming, and Software Development
602(1)
Running a FileMaker Consulting Practice
603(1)
General Resources for Tips and Tricks
603(1)
FileMaker News Sources
604(1)
Plug-ins
605(1)
Developer Tools
606(1)
FileMaker Go and iOS
607(1)
Web Programming
608(1)
XML/XSL
608(1)
PHP
609(1)
SQL
609(1)
ODBC/JDBC
610
Bob Bowers is CEO of Soliant Consulting, a 50-person firm that specializes in custom

database and web application development. He is a recipient of the FileMaker Excellence

Award and has co-authored seven books on FileMaker Pro development. In 2008 he was

inducted into the Chicago Area Entrepreneurship Hall of Fame. After graduating summa









cum laude in Music and English from Wabash College, Bob earned a masters degree in Musicology from the University of Chicago. Bob is also a proud dad of two young children,

an avid banjo player, and an accomplished woodworker.

 





Dawn Heady, a Senior Technical Project Lead for Soliant Consulting, has 20-plus years of FileMaker solution architecting experience during which time shes also been a successful

business owner, served as a CIO in the credit restoration industry, and as Vice President of

a company specializing in FileMaker plug-ins. She is an authorized FileMaker Training

Series instructor, a regular speaker at the annual FileMaker Developer Conference and

FileMaker webinars, and a contributor to the FileMaker Newsletter. In 2004 FileMaker

selected Dawn as a FileMaker 7 Idol finalist for her Interface-RAD solution. Dawn is an

avid fan of the Indianapolis Colts and Indiana Fever, loves to dote on her grandchildren,

and is learning to sail her small wooden boat, Boxy Lady, which was handcrafted by her

loving husband.

 





Steve Lane, Chief Technology Officer of Soliant Consulting, served as Special Projects

Developer at Scott Foreman, a leading K6 Educational publisher. He has written for





FileMaker Advisor magazine, and co-authored six books on FileMaker Pro. He has led training classes in FileMaker technologies all over the country and is authorized to teach the

FileMaker Training Series. He regularly speaks at the annual FileMaker Developer

Conference where in 2003 he was awarded the FileMaker Excellence Award for pushing

the boundaries of FileMaker Pro. When not writing about technology, Steve is likely to

be found being chased about by his children or grumbling over the fingerings of J. S.

Bach. Or just grumbling.

 





Scott Love, Chief Operating Officer of Soliant Consulting, served at Ziff-Davis Interactive

as an online managing editor, served at Apple Computer as its web publishing technology

evangelist, and led the technical marketing team at Macromedia. He has written dozens

of feature and review articles on database and Internet/web topics for a wide range of

computer publications including MacWorld magazine and FileMaker Advisor. He has coauthored

four books: Special Edition Using FileMaker 7, Special Edition Using FileMaker 8,





FileMaker 8 Functions and Scripts Desk Reference, and FileMaker 9 Developer Reference. He is also the producer for Grem Legends, an arcade game on the iOS App Store, and has written

a technical brief on FileMaker Go. He is an authorized FileMaker Training Series

instructor and a regular speaker at the FileMaker Developer Conference. In 2006 he was

awarded the FileMaker Excellence Award for developing outstanding technical and training

resources for FileMaker. Scott lives in the California Bay Area, where his penchant for

gardening can be indulged year round.