Home Page Icon
Home Page
Table of Contents for
II. Developing Solutions with FileMaker
Close
II. Developing Solutions with FileMaker
by Jesse Feiler
FileMaker® 12 In Depth
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
Best of Three Worlds
How This Book Is Organized
Who Should Use This Book
I. Getting Started with FileMaker 12
1. FileMaker Overview
FileMaker and Its Marketplace
Introduction to Database Software
Overview of the FileMaker Product Line
FileMaker Deployment Options
Technical Specifications
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
Working Under the Hood
Working with Tables
Working with Fields
Working with Field Types
Working with Field Options
Troubleshooting
FileMaker Extra: Indexing in FileMaker
4. Working with Layouts
What’s a Layout?
Using Multiple Layouts Automatically
Creating and Managing Layouts
Working with Parts
Working with the Layout Status Toolbar
Using the Inspector
Working with Objects on a Layout
Working with the Tab Control Object
Working with Fields
Troubleshooting
II. Developing Solutions with FileMaker
5. Relational Database Design
Understanding Database Design
Database Analysis
Working with Entities and Attributes
Understanding Relationships
Understanding the Role of Keys in Database Design
Many-to-Many Relationships
Normalizing Data: What Goes Where
FileMaker Extra: Complex Many-to-Many Relationships
6. Working with Multiple Tables
Multitable Systems in FileMaker Pro
Creating a One-to-Many Relationship in FileMaker
Working with Related Data
Creating a Many-to-Many Relationship
Rapid Multitable Development
Troubleshooting
7. Working with Relationships
Relationships Graphs and ERDs
Relationships as Queries
Creating Self-Relationships
Creating a Relationship with a Global Value
Creating Cross-Product Relationships
Working with Multiple Files
Troubleshooting
FileMaker Extra: Managing the Relationships Graph
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
Scripts in FileMaker Pro
Creating Scripts
Managing the Scripts Menu
Common Scripting Topics
Starting and Triggering Scripts
Working with Buttons on Layouts
Naming Scripts
Troubleshooting
FileMaker Extra: Creating a Script Library
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
Developing for Multiple Users
Sessions in FileMaker Pro
Concurrency
Launch Files
Troubleshooting
FileMaker Extra: Development with a Team
12. Implementing Security
Approaching Security
User-Level Internal Security
File-Level Access Security
Troubleshooting
FileMaker Extra: Working with Multiple Files
13. Using the Web Viewer
Introducing the Web Viewer
Creating and Editing a Web Viewer
Setting Web Viewer Options
Controlling the Web Viewer with the SET WEB VIEWER Script Step
FileMaker Extra: Using the Web Viewer for Files
14. Advanced Interface Techniques
What’s New in the Interface World
Working with Themes
Using Styles and States
Using FileMaker Formatting Tools
Using GetLayoutObjectAttribute
Working with Custom Menus
Providing Accessibility
FileMaker Extra: User Interface Heuristics
15. Advanced Calculation Techniques
Logical Functions
Text Formatting Functions
Array Functions
The “Filter”-ing Functions
Custom Functions
GetNthRecord
Troubleshooting
FileMaker Extra: Creating a Custom Function Library
16. Advanced Scripting Techniques
What Is Advanced Scripting?
Script Parameters
Script Results
Script Variables
FileMaker Extra: Recursive Scripts
17. Working with FileMaker Triggers
Introducing FileMaker Triggers
Attaching Triggers
Using a Timer
Trigger Functions
FileMaker Extra: Using Triggers for an Interactive Interface
18. Advanced FileMaker Solution Architecture
Window Management Techniques
Multiwindow Interfaces
Creating a Modal Dialog Using a Script Pause State
Go to Related Record
Dedicated Find Layouts
Troubleshooting
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
Updating and Upgrading FileMaker Software
Migrating to New FileMaker File Formats
Planning the Conversion
Preconversion Tasks
Converting Files
IV. Data Integration and Publishing
21. Connecting to External SQL Data Sources
ODBC Basics
Setting Up FileMaker Databases for ODBC
Setting Up and Administering ODBC
Importing ODBC Data into FileMaker
Using External ODBC Data Sources with the Relationships Graph
Troubleshooting
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
Getting Out What You Put In
The Basic Mechanics of Exporting
Export File Formats
Formatting Exported Data
Exporting Related Fields
Exporting Grouped Data
Exporting to Fixed-Width Formats
Working with Large Fields and Container Fields
Scripted Exports
24. Instant Web Publishing
Overview of Instant Web Publishing
Enabling and Configuring IWP
Designing for IWP Deployment
Troubleshooting
25. Custom Web Publishing with PHP and XML
About Custom Web Publishing
Custom Web Publishing Versus Instant Web Publishing
Preparing for Custom Web Publishing
Choosing a Custom Web Publishing Technology
Using Custom Web Publishing with PHP
Using Custom Web Publishing with XML
About Sessions
Troubleshooting
V. Deploying a FileMaker Solution
26. Deploying and Extending FileMaker
FileMaker Deployment Options
Renaming Files
Runtime Solutions
Developing Kiosk Solutions
Plug-Ins
Troubleshooting
27. FileMaker Server and Server Advanced
About FileMaker Server
Installing and Deploying FileMaker Server
Running FileMaker Server
Using Admin Console
FileMaker Extra: Best Practices Checklist
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
4. Working with Layouts
Next
Next Chapter
5. Relational Database Design
II. Developing Solutions with FileMaker
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset