Advanced Calculation Techniques
In this chapter
What's an Advanced Calculation Technique? 392
Logical Functions 392
Text Formatting Functions 409
Array Functions 414
The "Filter"-ing Functions 418
Custom Functions 420
GetNthRecord 430
Troubleshooting 432
FileMaker Extra: Creating a Custom Function Library 434
Part I: Getting Started with FileMaker 8
FileMaker Overview
- FileMaker Overview
- FileMaker and Its Marketplace
- Introduction to Database Software
- FileMaker Deployment Options
- Whats New in FileMaker Pro 8
Using FileMaker Pro
- Getting Started
- Working in FileMaker Pro
- Troubleshooting
- FileMaker Extra: Becoming a FileMaker Pro Power User
Defining and Working with Fields
- Defining and Working with Fields
- Working Under the Hood
- Working with Fields
- Working with Field Types
- Assigning Field Options
- Troubleshooting
- FileMaker Extra: Indexing in FileMaker
Working with Layouts
- Working with Layouts
- Whats a Layout?
- Creating and Managing Layouts
- Working with Parts
- Working with Objects on a Layout
- Working with the Tab Control Object
- Working with Fields
- Portals
- Troubleshooting
- FileMaker Extra: Designing Cross-PlatformFriendly Layouts
Part II: Developing Solutions with FileMaker
Relational Database Design
- Relational Database Design
- Understanding Database Design
- Database Analysis
- Working with Entities and Attributes
- Understanding Relationships
- Relationship Optionality
- Understanding the Role of Keys in Database Design
- Many-to-Many Relationships: Solving the Puzzle
- The Basics of Process Analysis
- FileMaker Extra: Complex Many-to-Many Relationships
Working with Multiple Tables
- Working with Multiple Tables
- Multitable Systems in FileMaker Pro
- Creating a One-to-Many Relationship in FileMaker
- Working with Keys and Match Fields
- Understanding Table Context
- Working with Related Data
- Creating a Many-to-Many Relationship
- Relational Integrity
- Rapid Multitable Development
- Troubleshooting
- FileMaker Extra: Building a Three-Way Join
Working with Relationships
- Working with Relationships
- Relationships Graphs and ERDs
- Relationships as Queries
- Creating Self-Relationships
- Creating Ranged Relationships
- Creating Cross-Product Relationships
- Working with Data from Distant Tables
- Working with Multiple Files
- How and When to Use Multiple Files
- Troubleshooting
- FileMaker Extra: Managing the Relationships Graph
Getting Started with Calculations
- Getting Started with Calculations
- Understanding How and Where Calculations Are Used
- Exploring the Calculation Dialog Box
- Essential Functions
- Using Conditional Functions
- Aggregate Functions
- Learning About the Environment
- Troubleshooting
- FileMaker Extra: Tips for Becoming a Calculation Master
Getting Started with Scripting
- Getting Started with Scripting
- Scripts in FileMaker Pro
- Creating Scripts
- Common Scripting Topics
- Triggering Scripts
- Working with Buttons on Layouts
- Troubleshooting
- FileMaker Extra: Creating a Script Library
Getting Started with Reporting
- Getting Started with Reporting
- Deriving Meaning from Data
- Working with Lists of Data
- Summarized Reports
- Delivering Reports
- Troubleshooting
- FileMaker Extra: Incorporating Reports into the Workflow
Part III: Developer Techniques
Developing for Multiuser Deployment
- Developing for Multiuser Deployment
- Developing for Multiple Users
- Sessions in FileMaker Pro
- Concurrency
- Audit Trails in FileMaker Pro
- Launch Files
- Troubleshooting
- FileMaker Extra: Development with a Team
Implementing Security
- Approaching Security
- User-Level Internal Security
- File-Level Access Security
- Troubleshooting
- FileMaker Extra: Working with Multiple Files
Advanced Interface Techniques
- Advanced Interface Techniques
- User Interfaces in FileMaker Pro
- Navigation
- Multiwindow Interfaces
- Working with Custom Menus
- Showing/Hiding Layout Elements
- Dedicated Find Layouts
- Data Presentation
- Working with Table View
- Troubleshooting
- FileMaker Extra: User Interface Heuristics
Advanced Calculation Techniques
- Advanced Calculation Techniques
- Whats an Advanced Calculation Technique?
- Logical Functions
- Text Formatting Functions
- Array Functions
- The Filter-ing Functions
- Custom Functions
- GetNthRecord
- Troubleshooting
- FileMaker Extra: Creating a Custom Function Library
Advanced Scripting Techniques
- Advanced Scripting Techniques
- What Is Advanced Scripting?
- Script Parameters and Script Results
- Script Variables
- Window Management Techniques
- Go to Related Record
- Troubleshooting
- FileMaker Extra: Recursive Scripts
Advanced Portal Techniques
- Advanced Portal Techniques
- Portals in FileMaker Pro
- Portal Basics
- New Record Only Relationships
- Horizontal Portals
- Using Portals to Create Calendars
- Selection Portals
- Filtered Portals
- Dynamic Portal Sorting
- Troubleshooting
- FileMaker Extra: Portals and Record Locking
Debugging and Troubleshooting
- 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
- FileMaker Extra: Other Tools of the Trade
Converting Systems from Previous Versions of FileMaker Pro
- Converting Systems from Previous Versions of FileMaker Pro
- Migration Choices
- Converting Files
- Pre-Conversion Tasks
- Post-Conversion Tasks
- Troubleshooting
- FileMaker Extra: Converting Web-Enabled Databases
Part IV: Data Integration and Publishing
Importing Data into FileMaker Pro
- Importing Data into FileMaker Pro
- Working with External Data
- Flat-File Data Sources
- Importing Multiple Files from a Folder
- Importing Photos from a Digital Camera
- Importing from an ODBC Data Source
- Importing from an XML Data Source
- Using a Script to Import Data
- Troubleshooting
- FileMaker Extra: Exploiting the FileMaker-to-FileMaker Import
Exporting Data from FileMaker
- 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
- Accessing FileMaker Data Using ODBC and JDBC
- Using FileMaker Pro as an ODBC Client
- Troubleshooting
- FileMaker Extra: Accessing FileMaker Data via JDBC
Instant Web Publishing
- Instant Web Publishing
- An Overview of Instant Web Publishing
- Enabling and Configuring IWP
- Designing for IWP Deployment
- Using an IWP Solution
- Troubleshooting
- FileMaker Extra: Building Your Own Next and Previous Page Buttons
FileMaker and Web Services
- FileMaker and Web Services
- About Web Services
- FileMaker and XML
- Transforming XML
- XML Import: Understanding Web Services
- Working with Web Services
- Troubleshooting
- FileMaker Extra: Write Your Own Web Services
Custom Web Publishing
- Custom Web Publishing
- About Custom Web Publishing
- Custom Web Publishing Versus Instant Web Publishing
- Custom Web Publishing Versus XML Export
- Getting Your Databases Ready for Custom Web Publishing
- Publishing FileMaker Data as XML
- Using XSLT with Custom Web Publishing
- Building Web Applications with XSLT-CWP
- Other Custom Web Publishing Commands and Parameters
- About the FileMaker XSLT Extensions
- Troubleshooting
- FileMaker Extra: About the Custom Web Publishing Tools
Part V: Deploying a FileMaker Solution
Deploying and Extending FileMaker
- Deploying and Extending FileMaker
- FileMaker Deployment Options
- Single User
- Peer-to-Peer Hosting
- FileMaker Server
- Web Publishing
- ODBC/JDBC
- Citrix/Terminal Services
- Runtime Solutions
- Deploying to Handheld Devices
- Customized Deployment Options
- Troubleshooting
- FileMaker Extra: The Limits of Customization
FileMaker Server and Server Advanced
- FileMaker Server and Server Advanced
- About FileMaker Server
- Installing FileMaker Server
- Running FileMaker Server
- Using the Server Administration Tool
- Configuring and Administering FileMaker Server Using the SAT
- Managing Clients
- Managing Databases
- Administration from the Command Line
- Working with External Services
- Automatically Updating Plug-ins
- Scheduled Tasks
- Monitoring FileMaker Server
- Troubleshooting
- FileMaker Extra: Best Practices Checklist
FileMaker Mobile
- FileMaker Mobile
- FileMaker Mobile 8 Overview
- Using FileMaker Mobile on Your Handheld Device
- Troubleshooting
- FileMaker Extra: Publishing Related Data
Documenting Your FileMaker Solutions
- Documenting Your FileMaker Solutions
- Why Is Documentation Important?
- Developing Naming Conventions
- Using Comments Effectively
- Documenting the Relationships Graph
- Using the Database Design Report
- Using Third-Party Documentation Tools
- Putting the Finishing Touches on Your Documentation
- Final Thoughts on Documentation
- FileMaker Extra: Soliant Development Standards
Special Edition Using FileMaker 8
ISBN: 0789735121
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 296
Pages: 296
Authors: Scott Love, Steve Lane
