Book description
FileMaker® 12 In Depth
Do more in less time!
FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features.
• Use
themes to build solutions for FileMaker Pro on Windows and OS X,
FileMaker Go
on iOS, and Instant Web Publishing
• Get the most out of new container field technology
• Quickly become a FileMaker 12 power user
• Make the most of FileMaker fields, tables, layouts, and parts
• Iteratively design reliable, high-performance FileMaker relational databases
• Work with relationships, including self-joins and cross-product relationships
• Write calculation formulas and use functions
• Use event-driven scripts to make databases more interactive
• Build clear and usable reports, publish them, and incorporate them into workflows
• Secure
applications with user accounts, privileges, file-level access,
network security,
and authentication
• Use FileMaker’s Web Viewer to access live web-based data
• Convert systems from older versions of FileMaker, and troubleshoot successfully
• Share, exchange, export, and publish data via SQL and XML
• Instantly publish databases on the web, and use advanced Custom Web Publishing techniques
• Trigger automated behaviors whenever specific events occur
• Extend FileMaker’s functionality with plug-ins
• Set up, configure, tune, and secure FileMaker Server
All In Depth books offer
• Comprehensive coverage with detailed solutions
• Troubleshooting help for tough problems you can’t fix on your own
• Outstanding authors recognized worldwide for their expertise and teaching style
Learning, reference, problem-solving... the only FileMaker 12 book you need!
Table of contents
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction: Welcome to FileMaker 12
-
I. Getting Started with FileMaker 12
- 1. FileMaker Overview
-
2. Using FileMaker Pro
- Getting Started
- Understanding FileMaker Pro Features
- Using the Status Toolbar
- Working in FileMaker Pro
- Working with Records
- Working with Fields
- Working with Related Data
- Finding Data with FileMaker
- Sorting
- Printing
- Importing and Exporting Data
- Using the Web Viewer
- Troubleshooting
- FileMaker Extra: Becoming a FileMaker Pro Power User
- 3. Defining and Working with Fields and Tables
- 4. Working with Layouts
-
II. Developing Solutions with FileMaker
- 5. Relational Database Design
- 6. Working with Multiple Tables
- 7. Working with Relationships
-
8. Getting Started with Calculations
- Understanding How and Where Calculations Are Used
- Exploring the Specify Calculation Dialog
- Essential Functions
- Using Conditional Functions
- Aggregate Functions
- Learning About the Environment: Introspective Functions
- Device Identification Functions
- Mobile Functions
- Troubleshooting
- FileMaker Extra: Tips for Becoming a Calculation Master
- 9. Getting Started with Scripting
-
10. Getting Started with Reporting and Charting
- Reporting in FileMaker Pro
- Deriving Meaning from Data
- Working with Reports, Layouts, View As Options, and Modes
- Working with Lists of Data
- Using the New Layout/Report Assistant
- Using Summarized Reports
- Modifying Table Views
- Customizing Layouts and Reports
- Delivering Reports
- Introducing Charting
- Troubleshooting
- FileMaker Extra: Incorporating Reports into the Workflow
-
III. Developer Techniques
- 11. Developing for Multiuser Deployment
- 12. Implementing Security
- 13. Using the Web Viewer
- 14. Advanced Interface Techniques
- 15. Advanced Calculation Techniques
- 16. Advanced Scripting Techniques
- 17. Working with FileMaker Triggers
- 18. Advanced FileMaker Solution Architecture
-
19. Debugging and Troubleshooting
- What Is Troubleshooting?
- Staying Out of Trouble
- Planning for Trouble
- Troubleshooting Scripts and Calculations
- Troubleshooting in Specific Areas: Performance, Context, Connectivity, and Globals
- File Maintenance and Recovery
- Using the Database Design Report
- Using the Script Debugger
- Using the Data Viewer
- 20. Converting Systems from Previous Versions of FileMaker Pro
-
IV. Data Integration and Publishing
- 21. Connecting to External SQL Data Sources
-
22. Importing Data into FileMaker Pro
- Working with External Data
- Flat-File Data Sources
- Importing from a Microsoft Excel File
- Setting Import Options and Reviewing Status
- Importing Multiple Files from a Folder
- Scripting Imports with FileMaker
- Using Bento Data Sources
- Troubleshooting
- FileMaker Extra: Exploiting the FileMaker-to-FileMaker Import
- 23. Exporting Data from FileMaker
- 24. Instant Web Publishing
- 25. Custom Web Publishing with PHP and XML
- V. Deploying a FileMaker Solution
- Index
Product information
- Title: FileMaker® 12 In Depth
- Author(s):
- Release date: May 2012
- Publisher(s): Que
- ISBN: 9780132983952
You might also like
book
Mixing Secrets
Discover how to achieve release-quality mixes even in the smallest studios by applying power-user techniques from …
book
Systems Thinking, 3rd Edition
Systems Thinking, Third Edition combines systems theory and interactive design to provide an operational methodology for …
audiobook
HBR's 10 Must Reads 2022
A year's worth of management wisdom, all in one place. We've combed through the ideas, insights, …
book
Sams Teach Yourself TCP/IP in 24 Hours
Sams Teach Yourself TCP/IP in 24 Hours, Sixth Edition is a practical guide to the simple …