Getting Started with Calculations
In this chapter
Understanding How and Where Calculations Are Used 218
Exploring the Calculation Dialog Box 221
Essential Functions 228
Using Conditional Functions 238
Aggregate Functions 239
Learning About the Environment 240
Troubleshooting 243
FileMaker Extra: Tips for Becoming a Calculation Master 244
Understanding How and Where Calculations Are Used |
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
