FileMaker Pro 9: The Missing Manual. The Missing Manual

Spis treści ebooka

• FileMaker Pro 9: The Missing Manual
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • Introduction
    • Why FileMaker Pro?
    • Whats New in FileMaker Pro 9
    • The Very Basics
    • About This Book
      • About the Outline
      • Living Examples
      • Macintosh and Windows
      • About These Arrows
      • About Missing Manuals.com
      • Safari Enabled
  • I. Introduction to FileMaker Pro
    • 1. Your First Database
      • 1.1. A Very Quick Database Tour
        • 1.1.1. Content Area
        • 1.1.2. Mode Pop-up Menu
          • 1.1.2.1. Status area and the status area controls
          • 1.1.2.2. Zoom control
          • 1.1.2.3. Scroll bars
      • 1.2. Creating a New Database
        • 1.2.1. Choosing a Starter Solution
      • 1.3. Opening and Closing Database Files
        • 1.3.1. Opening a Database
        • 1.3.2. Closing a Database
      • 1.4. Saving Your Databases
        • 1.4.1. Saving a Copy of Your Database
          • 1.4.1.1. Saving a clone of your database
      • 1.5. Adding Records to Your Database
        • 1.5.1. Creating a Record
        • 1.5.2. Editing a Record
          • 1.5.2.1. Moving between fields
        • 1.5.3. Adding More Records
          • 1.5.3.1. Duplicating a record
          • 1.5.3.2. Deleting records
          • 1.5.3.3. Revert the record
      • 1.6. Navigating Your Database
        • 1.6.1. Navigating Record by Record
        • 1.6.2. Keyboard Shortcuts
        • 1.6.3. Finding Records
          • 1.6.3.1. Performing a find
          • 1.6.3.2. FastMatch
      • 1.7. Same Database, Multiple Windows
        • 1.7.1. Automatically Arranging Windows
        • 1.7.2. Hiding Windows
          • 1.7.2.1. Closing hidden windows
    • 2. Organizing and Editing Records
      • 2.1. Views
        • 2.1.1. Form View
        • 2.1.2. List View
        • 2.1.3. Table View
      • 2.2. Advanced Find Mode
        • 2.2.1. Finding by Omitting
        • 2.2.2. Constraining and Extending the Found Set
          • 2.2.2.1. Constraining the found set
          • 2.2.2.2. Extending the found set
        • 2.2.3. Refining Searches with Find Symbols
          • 2.2.3.1. The wildcard (*)
          • 2.2.3.2. Less Than (<), Less Than or Equal To (<), Greater Than (>), and Greater Than or Equal To (>)
          • 2.2.3.3. Exact Match (=), Literal Text (""), and Field Content Match (= =)
          • 2.2.3.4. Range ()
          • 2.2.3.5. Duplicates (!)
          • 2.2.3.6. Today's Date (//) and Invalid Date or Time (?)
          • 2.2.3.7. One Character (@), One Digit (#), and Zero or More Characters (*)
          • 2.2.3.8. Relaxed Search (~)
        • 2.2.4. Refining a Found Set with Omit Commands
          • 2.2.4.1. Omit Record
          • 2.2.4.2. Omit Multiple
          • 2.2.4.3. Show Omitted Only
      • 2.3. Changing Multiple Records
      • 2.4. Sorting Records
        • 2.4.1. Multiple Sort Fields
      • 2.5. Editing What's in Your Fields
        • 2.5.1. Find and Replace
        • 2.5.2. Fields for Lots of Text
        • 2.5.3. Drag-and-drop Editing
        • 2.5.4. Text Formatting
          • 2.5.4.1. Font
          • 2.5.4.2. Size
          • 2.5.4.3. Style
          • 2.5.4.4. Text Color
          • 2.5.4.5. The Text Format dialog box
      • 2.6. Paragraph Formatting
        • 2.6.1. Align Text
        • 2.6.2. Line Spacing
        • 2.6.3. The Text Ruler
        • 2.6.4. Detailed Formatting in the Paragraph Box
        • 2.6.5. Tabs
          • 2.6.5.1. Setting tabs in the Text Ruler
          • 2.6.5.2. Setting tabs in the Tabs dialog box
          • 2.6.5.3. Editing tab stops in the Tabs dialog box
      • 2.7. Beyond Text: Container Fields
        • 2.7.1. Pictures
          • 2.7.1.1. Copy and paste
          • 2.7.1.2. Insert Picture
        • 2.7.2. QuickTime
        • 2.7.3. Sound
          • 2.7.3.1. Recording sound
        • 2.7.4. File
          • 2.7.4.1. Exporting data from container fields
      • 2.8. Checking Spelling
        • 2.8.1. Spell Checking in One Pass
        • 2.8.2. Spell Checking as You Type
        • 2.8.3. Managing Spelling Dictionaries
          • 2.8.3.1. User dictionaries
      • 2.9. Printing and Preview Mode
    • 3. Building a New Database
      • 3.1. Tables and Fields
        • 3.1.1. Tables: The Foundation of Your Database
        • 3.1.2. Figuring Out What Fields You Need
      • 3.2. Defining Fields
        • 3.2.1. Changing a Field's Name
        • 3.2.2. Duplicating a Field
        • 3.2.3. Deleting a Field
        • 3.2.4. Reordering the Field List
        • 3.2.5. Printing Field Definitions
        • 3.2.6. Field Types
          • 3.2.6.1. Text
          • 3.2.6.2. Number
          • 3.2.6.3. Date
          • 3.2.6.4. Time
          • 3.2.6.5. Timestamp
          • 3.2.6.6. Container
          • 3.2.6.7. Calculation and summary
      • 3.3. Advanced Field Options
        • 3.3.1. Auto-Enter Options
          • 3.3.1.1. Creation values
          • 3.3.1.2. Modification values
          • 3.3.1.3. Serial number
          • 3.3.1.4. Value from last visited record
          • 3.3.1.5. Data
          • 3.3.1.6. Calculated value
          • 3.3.1.7. Looked-up value
          • 3.3.1.8. Prohibit modification of value during data entry
        • 3.3.2. Validation Options
          • 3.3.2.1. When to perform validation
          • 3.3.2.2. Overriding validation
        • 3.3.3. Validation Requirements
          • 3.3.3.1. Strict data type
          • 3.3.3.2. Not empty
          • 3.3.3.3. Unique
          • 3.3.3.4. Existing value
          • 3.3.3.5. Member of value list
          • 3.3.3.6. In range
          • 3.3.3.7. Maximum number of characters
        • 3.3.4. Storage Options
          • 3.3.4.1. Global storage
          • 3.3.4.2. Repeating fields
        • 3.3.5. Indexing
          • 3.3.5.1. Automatic indexing
          • 3.3.5.2. Controlling indexing manually
          • 3.3.5.3. Indexing language
      • 3.4. Bringing It All Together
  • II. Layout Basics
    • 4. Layout Basics
      • 4.1. What Is a Layout?
        • 4.1.1. Types of Layouts
      • 4.2. Switching Between Layouts
      • 4.3. What Makes a Layout
        • 4.3.1. Layout Parts
          • 4.3.1.1. Parts in form view
          • 4.3.1.2. Parts in list view
          • 4.3.1.3. Parts in Preview mode
          • 4.3.1.4. When to use 'em
        • 4.3.2. Layout Objects
          • 4.3.2.1. Text objects
          • 4.3.2.2. Lines and shapes
          • 4.3.2.3. Images
          • 4.3.2.4. Fields
      • 4.4. Layout Mode
        • 4.4.1. The Status Area
        • 4.4.2. View Options
          • 4.4.2.1. Go to Layout
          • 4.4.2.2. Page Margins
          • 4.4.2.3. Graphic Rulers
          • 4.4.2.4. Text Ruler
          • 4.4.2.5. Ruler Lines
          • 4.4.2.6. T-Squares
          • 4.4.2.7. Object Info
          • 4.4.2.8. Buttons
          • 4.4.2.9. Sample Data
          • 4.4.2.10. Text Boundaries
          • 4.4.2.11. Field Boundaries
          • 4.4.2.12. Sliding Objects
          • 4.4.2.13. Non-Printing Objects
          • 4.4.2.14. Tooltips
          • 4.4.2.15. Toolbars
          • 4.4.2.16. Status area
          • 4.4.2.17. Zoom in and out
        • 4.4.3. Layout Setup
          • 4.4.3.1. Layout name
        • 4.4.4. Layout Tools
          • 4.4.4.1. The drawing tools
          • 4.4.4.2. The control tools
          • 4.4.4.3. The field and part tools
          • 4.4.4.4. The line and fill tools
        • 4.4.5. Working with Parts
          • 4.4.5.1. Deleting a part
          • 4.4.5.2. Resizing parts
          • 4.4.5.3. Coloring a part
        • 4.4.6. Adding and Editing Text
          • 4.4.6.1. Adding new text
          • 4.4.6.2. Changing text font, size, and style
          • 4.4.6.3. Editing existing text
        • 4.4.7. Formatting Fields
          • 4.4.7.1. Text formats
          • 4.4.7.2. Other field type formats
        • 4.4.8. Field Controls
          • 4.4.8.1. Field/Control setup
          • 4.4.8.2. Field borders
        • 4.4.9. Laying Out the Layout
          • 4.4.9.1. Resizing objects
          • 4.4.9.2. Aligning objects
          • 4.4.9.3. Moving objects
          • 4.4.9.4. Adding images
        • 4.4.10. Adding a Dividing Line Between Layout Parts
        • 4.4.11. Finishing Touches
        • 4.4.12. Autoresize
          • 4.4.12.1. Anchors
          • 4.4.12.2. Making Autoresize work for your layout
          • 4.4.12.3. Keeping it small
        • 4.4.13. Wrapping up
    • 5. Creating Layouts
      • 5.1. The Lowdown on Layouts
        • 5.1.1. Standard Form
        • 5.1.2. Columnar List/Report
        • 5.1.3. Table View
        • 5.1.4. Labels or Vertical Labels
        • 5.1.5. Envelope
        • 5.1.6. Blank Layout
      • 5.2. Creating a Layout from Scratch
        • 5.2.1. Adding a New Layout
        • 5.2.2. Set Up the Header
          • 5.2.2.1. Matching part sizes with the Object Info palette
          • 5.2.2.2. Matching part sizes with the T-squares
          • 5.2.2.3. Adding the finishing touches
        • 5.2.3. Set Up the Body
          • 5.2.3.1. Making data flow with merge fields
          • 5.2.3.2. Using symbols to show important info
          • 5.2.3.3. Arranging the objects
          • 5.2.3.4. Adding a field
          • 5.2.3.5. Copying formatting with the Format Painter
          • 5.2.3.6. Alternating the body color
        • 5.2.4. Setting Layout View
        • 5.2.5. Setting Anchors in List Layouts
      • 5.3. Creating Layouts for Reports
        • 5.3.1. Visualize the Result Preview Mode
        • 5.3.2. Creating a Report Layout with an Assistant
        • 5.3.3. Print Margins
        • 5.3.4. Improving the Report Layout
          • 5.3.4.1. Tidy up the header
          • 5.3.4.2. Rearrange the body
          • 5.3.4.3. Tweak the footer
        • 5.3.5. Sliding Layout Objects
          • 5.3.5.1. When to use sliding
          • 5.3.5.2. Choosing the objects to slide
          • 5.3.5.3. Setting sliding options
          • 5.3.5.4. The Sliding/Printing dialog box
          • 5.3.5.5. Using sliding on the report layout
        • 5.3.6. Setting Layout Order
    • 6. Advanced Layouts and Reports
      • 6.1. Value Lists
        • 6.1.1. Creating Value Lists
          • 6.1.1.1. Values from a field
          • 6.1.1.2. Value list from another file
        • 6.1.2. Editing Value Lists
      • 6.2. Advanced Field Controls
        • 6.2.1. Edit Box
        • 6.2.2. Drop-down List
        • 6.2.3. Pop-up Menu
        • 6.2.4. Checkbox Set
        • 6.2.5. Radio Button Set
        • 6.2.6. Drop-down Calendar
        • 6.2.7. Auto-Complete
          • 6.2.7.1. Auto-Complete in Edit Boxes
          • 6.2.7.2. Auto-Complete in drop-down lists
        • 6.2.8. Repetitions
        • 6.2.9. Display Data From
      • 6.3. Field Behavior
        • 6.3.1. Field Entry
        • 6.3.2. Select Entire Contents of Field on Entry
        • 6.3.3. Input Method
        • 6.3.4. Field-level Visual Spell Checking
        • 6.3.5. Go To Next Field Using
      • 6.4. Conditional Formatting
        • 6.4.1. Conditional Formatting of Fields
        • 6.4.2. Conditional Formatting of Text Objects
        • 6.4.3. Multiple Conditions
        • 6.4.4. More Formatting Options
        • 6.4.5. Removing Conditional Formatting
      • 6.5. Print-related Layout Options
        • 6.5.1. Non-printing Objects
        • 6.5.2. Columns
      • 6.6. Format the Number/Date/Time/Graphic
        • 6.6.1. Number Formatting
          • 6.6.1.1. General format
          • 6.6.1.2. Leave data formatted as entered
          • 6.6.1.3. Format as Boolean
          • 6.6.1.4. Format as decimal
        • 6.6.2. Date Formatting
          • 6.6.2.1. Leave data formatted as entered
          • 6.6.2.2. Format as
          • 6.6.2.3. Custom
        • 6.6.3. Time Formatting
          • 6.6.3.1. Leave data formatted as entered
          • 6.6.3.2. Format as
        • 6.6.4. Timestamp Formatting
        • 6.6.5. Graphic Formatting
          • 6.6.5.1. Scale
          • 6.6.5.2. Alignment
      • 6.7. Adding Buttons
        • 6.7.1. Creating Buttons with the Button Tool
        • 6.7.2. Turning an Existing Layout Object into a Button
        • 6.7.3. Making a Button Not a Button
        • 6.7.4. Button Actions
          • 6.7.4.1. Go to Layout
          • 6.7.4.2. Go to Record/Request/Page
          • 6.7.4.3. Go to Field
          • 6.7.4.4. Go to Next Field and Go to Previous Field
          • 6.7.4.5. Enter Browse Mode, Enter Find Mode, and Enter Preview Mode
          • 6.7.4.6. Editing actions
          • 6.7.4.7. Field actions
          • 6.7.4.8. Record actions
          • 6.7.4.9. Found Set actions
          • 6.7.4.10. Window actions
          • 6.7.4.11. Print actions
          • 6.7.4.12. Open actions
          • 6.7.4.13. Exiting FileMaker
      • 6.8. Tab Order
        • 6.8.1. Buttons in the Tab Order
        • 6.8.2. Customizing the Tab Order
        • 6.8.3. Fixing the Tab Order in the People Database
        • 6.8.4. Preserving the Automatic Order
      • 6.9. Web Viewer Controls
        • 6.9.1. Putting a Web Viewer on a Layout
        • 6.9.2. Web Viewer Options
          • 6.9.2.1. Allow interaction with Web viewer content
          • 6.9.2.2. Display content in Find mode
          • 6.9.2.3. Display progress bar
          • 6.9.2.4. Display status message
      • 6.10. Tab Controls
        • 6.10.1. Creating a Tab Control
        • 6.10.2. Editing Tab Controls
          • 6.10.2.1. Adding, removing, and reordering tabs
          • 6.10.2.2. Default front tab
          • 6.10.2.3. Tab justification
          • 6.10.2.4. Appearance
          • 6.10.2.5. Tab Width
          • 6.10.2.6. Dismissing the Tab Control Setup dialog box
          • 6.10.2.7. Formatting a tab control
        • 6.10.3. Deleting a Tab Control
      • 6.11. Reports and Summary Fields
        • 6.11.1. Summary Fields
        • 6.11.2. Creating a Summary Report
          • 6.11.2.1. Adding a summary part
          • 6.11.2.2. Sub-summary parts
          • 6.11.2.3. Creating a sub-summary part
        • 6.11.3. Other Summary Field Types
          • 6.11.3.1. Total of
          • 6.11.3.2. Average of
          • 6.11.3.3. Count of
          • 6.11.3.4. Minimum and Maximum
          • 6.11.3.5. Standard Deviation of
          • 6.11.3.6. Fraction of Total
          • 6.11.3.7. Summarizing repetitions
  • III. Multiple Tables and Relationships
    • 7. Multiple Tables and Relationships
      • 7.1. Relational Databases Explained
      • 7.2. Modeling Your Database
        • 7.2.1. Choosing Entities
        • 7.2.2. Finding Relationships
          • 7.2.2.1. One-to-many relationships
          • 7.2.2.2. One-to-one relationships
          • 7.2.2.3. Many-to-many relationships
        • 7.2.3. The Entity-relationship Diagram
          • 7.2.3.1. Creating an ER diagram
        • 7.2.4. Keys
          • 7.2.4.1. Choosing a good key field
          • 7.2.4.2. Primary and foreign keys
        • 7.2.5. Join Tables
      • 7.3. Creating a Relational Database
        • 7.3.1. Creating the Tables
        • 7.3.2. Creating the Fields
          • 7.3.2.1. Adding primary keys
          • 7.3.2.2. Adding foreign keys
        • 7.3.3. Defining the Relationships
        • 7.3.4. Cleaning Up the Relationship Graph
          • 7.3.4.1. Selection tools
          • 7.3.4.2. Arrange the graph
          • 7.3.4.3. Color your table occurrences
          • 7.3.4.4. Adding notes
          • 7.3.4.5. Printing the graph
          • 7.3.4.6. Deleting relationships
        • 7.3.5. Finishing the Field Definitions
          • 7.3.5.1. Customers table fields
          • 7.3.5.2. Jobs table fields
          • 7.3.5.3. Expenses table fields
          • 7.3.5.4. Timeslips table fields
          • 7.3.5.5. Invoices table fields
          • 7.3.5.6. Line Items table fields
          • 7.3.5.7. Payments table fields
      • 7.4. Relational Databases
        • 7.4.1. One Table Occurrence, One Found Set
        • 7.4.2. Viewing Related Fields
        • 7.4.3. Adding or Editing Data with Relationships
        • 7.4.4. Editing Related Data
          • 7.4.4.1. Portals
          • 7.4.4.2. Editing fields through a portal
    • 8. Advanced Relationship Techniques
      • 8.1. Creating Related Records
        • 8.1.1. Value Lists Based on Fields
        • 8.1.2. Creating Related Records Through a Portal
          • 8.1.2.1. Preparing the relationship
          • 8.1.2.2. Adding a portal to a layout
          • 8.1.2.3. Adding records in a portal
        • 8.1.3. Navigating Between Related Records
          • 8.1.3.1. Go to Related Record
          • 8.1.3.2. GTRR with a found set
      • 8.2. Table Occurrences
        • 8.2.1. Understanding Table Occurrences
        • 8.2.2. Relationships with Table Occurrences
          • 8.2.2.1. Adding a new key field to a table
          • 8.2.2.2. Adding a table occurrence
          • 8.2.2.3. Adding fields for new table occurrences
      • 8.3. Managing Data with Data Tunneling
        • 8.3.1. Understanding Data Tunneling
          • 8.3.1.1. What you need in your data tunneling interface
        • 8.3.2. Understanding Table Occurrence Groups
        • 8.3.3. Managing the Relationships Graph
      • 8.4. Building a Data Tunneling Interface
        • 8.4.1. Creating a Global Field
        • 8.4.2. Creating a New Table Occurrence Group
        • 8.4.3. Building a Global Field Layout
          • 8.4.3.1. Using a global pop-up field to change the display in a value list
      • 8.5. Connecting Databases
        • 8.5.1. Adding a Table Occurrence from Another File
        • 8.5.2. Defining Data Sources Using a Path
      • 8.6. Lookups
        • 8.6.1. Creating Lookups
        • 8.6.2. Triggering a Lookup
      • 8.7. Advanced Relationships
        • 8.7.1. Relationships with More than One Criterion
        • 8.7.2. Other Relationship Operators
        • 8.7.3. Creating the Invoice Finder
  • IV. Introduction to Calculations
    • 9. Introduction to Calculations
      • 9.1. Understanding Calculations
        • 9.1.1. Creating a Calculation
      • 9.2. The Structure of a Calculation
        • 9.2.1. Fields
        • 9.2.2. Constants
          • 9.2.2.1. Number constants
          • 9.2.2.2. Text constants
        • 9.2.3. Operators
          • 9.2.3.1. Mathematical operators
          • 9.2.3.2. The concatenation operator
          • 9.2.3.3. Comparison operators
          • 9.2.3.4. Logical operators
          • 9.2.3.5. The ^ Operator
          • 9.2.3.6. Parentheses
        • 9.2.4. Functions
          • 9.2.4.1. Text functions
          • 9.2.4.2. Text formatting functions
          • 9.2.4.3. Number functions
          • 9.2.4.4. Date functions
          • 9.2.4.5. Time functions
          • 9.2.4.6. Timestamp functions
          • 9.2.4.7. Aggregate functions
          • 9.2.4.8. Summary functions
          • 9.2.4.9. Repeating functions
          • 9.2.4.10. Financial functions
          • 9.2.4.11. Trigonometric functions
          • 9.2.4.12. Logical functions
          • 9.2.4.13. Get functions
          • 9.2.4.14. Design functions
          • 9.2.4.15. Custom functions
          • 9.2.4.16. External functions
        • 9.2.5. Expressions
      • 9.3. Creating a Calculation Field
        • 9.3.1. The Specify Calculation Dialog Box
          • 9.3.1.1. Table occurrence context
          • 9.3.1.2. Field list
          • 9.3.1.3. Operators
          • 9.3.1.4. Function list
          • 9.3.1.5. Result type
          • 9.3.1.6. Calculation box
          • 9.3.1.7. Repetitions
      • 9.4. Auto-Enter Calculations
      • 9.5. Validate Data Entry with a Calculation
      • 9.6. Replacing Data Using a Calculation
      • 9.7. Comments
    • 10. Calculations and Data Types
      • 10.1. Number Crunching Calculations
        • 10.1.1. Number Operators
        • 10.1.2. Number Function Types
        • 10.1.3. Precision
      • 10.2. Going Beyond Basic Calculations
        • 10.2.1. Preparing the Data
        • 10.2.2. Building the Calculation Fields
        • 10.2.3. Constructing the Calculation
      • 10.3. Text Parsing Calculations
        • 10.3.1. The Concatenation Operator
        • 10.3.2. Text Function Types
        • 10.3.3. Text Functions
          • 10.3.3.1. Character functions
          • 10.3.3.2. Word functions
          • 10.3.3.3. Text value functions
          • 10.3.3.4. Text counting functions
          • 10.3.3.5. Other text parsing functions
        • 10.3.4. Text Formatting Functions
          • 10.3.4.1. TextColor and RGB
          • 10.3.4.2. TextFont
          • 10.3.4.3. TextSize
          • 10.3.4.4. TextStyleAdd and TextStyleRemove
      • 10.4. Date and Time Calculations
        • 10.4.1. How FileMaker Looks at Time
        • 10.4.2. Math with Dates and Times
          • 10.4.2.1. Dates
          • 10.4.2.2. Times
        • 10.4.3. Parsing Dates and Times
        • 10.4.4. Calculations that Create Dates and Times
          • 10.4.4.1. The secret powers of date
      • 10.5. Aggregate Calculations
        • 10.5.1. Numerical Aggregate Functions
        • 10.5.2. The List Function
      • 10.6. Containers in Calculations
        • 10.6.1. Calculations with Pictures, Sounds, Movies, and Files
        • 10.6.2. Calculations with References
    • 11. Advanced Calculations
      • 11.1. Conditional Formatting
        • 11.1.1. Understanding Boolean Functions
      • 11.2. Using the Self Function
      • 11.3. Stored, Unstored, and Global Fields
        • 11.3.1. Stored and Unstored Calculation Fields
          • 11.3.1.1. Field dependencies
          • 11.3.1.2. Deciding when to store
        • 11.3.2. Global Calculation Fields
      • 11.4. Logical Functions
        • 11.4.1. Conditional Functions
          • 11.4.1.1. The If function
          • 11.4.1.2. The Case function
          • 11.4.1.3. The Choose function
        • 11.4.2. Constructing a Conditional Calculation
          • 11.4.2.1. Total Due calculation #1: Using the If function
          • 11.4.2.2. Total Due calculation #2: Using the Case function
      • 11.5. The Let Function and Variables
        • 11.5.1. Defining Calculation Variables
          • 11.5.1.1. Total Due calculation #3: Using the Let function
        • 11.5.2. The Life of a Variable
          • 11.5.2.1. Local variables
          • 11.5.2.2. Global variables
        • 11.5.3. Nesting Let Functions
    • 12. Extending Calculations
      • 12.1. Custom Functions
        • 12.1.1. Defining a Custom Function
        • 12.1.2. Editing Custom Functions
        • 12.1.3. Recursion
          • 12.1.3.1. Step 1: Solve the first case
          • 12.1.3.2. Step 2: Assume your function already works, and use it
          • 12.1.3.3. Step 3: Find a stopping point
      • 12.2. Plug-ins
        • 12.2.1. Installing Plug-ins
        • 12.2.2. Old and New Plug-ins
        • 12.2.3. Finding Plug-ins
        • 12.2.4. Creating Your Own Plug-ins
  • V. Scripting
    • 13. Scripting Basics
      • 13.1. Your First Script
        • 13.1.1. Preparing the Database
        • 13.1.2. Planning Your Script
        • 13.1.3. Creating Your Script
        • 13.1.4. Improving Your Script
      • 13.2. The Importance of the Layout
        • 13.2.1. When to Switch
      • 13.3. Running Scripts
        • 13.3.1. The Scripts Menu
        • 13.3.2. Defining Buttons
        • 13.3.3. Opening and Closing Scripts
      • 13.4. Understanding ScriptMaker's Windows
      • 13.5. Organizing Your Scripts
        • 13.5.1. Creating Script Groups
        • 13.5.2. Creating Menu Separators
      • 13.6. Branching and Looping in Scripts
        • 13.6.1. Branching with If, Else If, Else, and End If
        • 13.6.2. Testing Multiple Conditions
        • 13.6.3. Looping
          • 13.6.3.1. Using Go to Record/Request/Page to exit a loop
    • 14. Script Steps
      • 14.1. Go to Layout
      • 14.2. Scripting for Fields
        • 14.2.1. Navigating Fields
          • 14.2.1.1. Go to Field
          • 14.2.1.2. Go to Next Field and Go to Previous Field
        • 14.2.2. Editing Commands
        • 14.2.3. Selecting Text
        • 14.2.4. Editing Field Data
          • 14.2.4.1. Avoiding Cut, Copy, and Paste
          • 14.2.4.2. Set Field
          • 14.2.4.3. Insert Calculated Result
          • 14.2.4.4. Inserting other values
          • 14.2.4.5. Putting data in container fields
        • 14.2.5. A Field Script in Action
          • 14.2.5.1. Building the script
        • 14.2.6. Other Steps That Work with Fields
          • 14.2.6.1. Perform Find/Replace
          • 14.2.6.2. Replace Field Contents and Relookup Field Contents
          • 14.2.6.3. Set Next Serial Value
      • 14.3. Working with Records
        • 14.3.1. Creating, Duplicating, and Deleting Records
        • 14.3.2. Navigating Among Records
          • 14.3.2.1. Go to Record/Request/Page
          • 14.3.2.2. Go to Related Record
        • 14.3.3. Opening, Reverting, and Committing Records
          • 14.3.3.1. Open Record/Request
          • 14.3.3.2. Commit Record/Request
          • 14.3.3.3. Revert Record/Request
        • 14.3.4. Copying Records
          • 14.3.4.1. Copy Record/Request
          • 14.3.4.2. Copy All Records/Requests
        • 14.3.5. Working with Portals
          • 14.3.5.1. Go to Portal Row
      • 14.4. Finding Records
        • 14.4.1. Performing the User's Find Requests
        • 14.4.2. Static Find Requests
        • 14.4.3. Dynamic Find Requests
        • 14.4.4. Constraining and Extending the Found Set
        • 14.4.5. Omitting Records
        • 14.4.6. Modify Last Find
        • 14.4.7. Save Records as
          • 14.4.7.1. Save Records as Excel
          • 14.4.7.2. Save Records as PDF
      • 14.5. Sorting Records
      • 14.6. Working with Windows
        • 14.6.1. Creating Windows
        • 14.6.2. Bringing a Window to the Front
        • 14.6.3. Closing a Window
        • 14.6.4. Moving and Resizing Existing Windows
          • 14.6.4.1. Adjust Window
          • 14.6.4.2. Arrange All Windows
          • 14.6.4.3. Move/Resize Window
        • 14.6.5. Other Window-related Script Steps
      • 14.7. Working with Files
        • 14.7.1. Opening and Closing Files
        • 14.7.2. Save a Copy As
        • 14.7.3. Other File-Related Script Steps
      • 14.8. Printing
      • 14.9. Other Script Steps
        • 14.9.1. Open URL
        • 14.9.2. Dial Phone
        • 14.9.3. Set Web Viewer
        • 14.9.4. Send Email
        • 14.9.5. Execute SQL
        • 14.9.6. Flush Cache to Disk
        • 14.9.7. Exit Application
    • 15. Advanced Scripting
      • 15.1. Commenting Scripts
      • 15.2. Asking and Telling the User
        • 15.2.1. Showing a Simple Message
        • 15.2.2. Asking a Simple Question
        • 15.2.3. Asking a Not-so-simple Question
      • 15.3. Organizing Complex Scripts
        • 15.3.1. The Perform Script Script Step
        • 15.3.2. Halt Script and Exit Script
          • 15.3.2.1. Exit Script (Result)
          • 15.3.2.2. Organizing scripts that use Halt or Exit Script
        • 15.3.3. Script Parameters
        • 15.3.4. Script Variables
      • 15.4. Handling Errors
        • 15.4.1. The Set Error Capture Script Step
        • 15.4.2. The Get ( LastError ) Function
        • 15.4.3. The Allow User Abort Script Step
      • 15.5. Putting a Complex Script Together
        • 15.5.1. Planning the Script
        • 15.5.2. Considering Exceptions
        • 15.5.3. Creating Subscripts
          • 15.5.3.1. Creating subscript placeholders
          • 15.5.3.2. Creating skeleton subscripts
        • 15.5.4. Finishing the Subscripts
          • 15.5.4.1. The "-find unbilled activity" subscript
          • 15.5.4.2. Copying and editing existing script steps
        • 15.5.5. Adding a Script Parameter to a Perform Script Step
          • 15.5.5.1. The "-create invoice record" subscript
          • 15.5.5.2. The "-process timeslips" subscript
          • 15.5.5.3. The "-process expenses" subscript
          • 15.5.5.4. Finishing the main script
        • 15.5.6. Testing Scripts
  • VI. Security and Integration
    • 16. Security
      • 16.1. How Security Works
        • 16.1.1. Who Gets Access
        • 16.1.2. What They Can Do
      • 16.2. Privilege Sets
        • 16.2.1. Managing Privilege Sets
          • 16.2.1.1. Creating a new privilege set
        • 16.2.2. Other Privileges
        • 16.2.3. Data Access and Design Privileges
          • 16.2.3.1. Record privileges
          • 16.2.3.2. Creating record-level access
          • 16.2.3.3. Field-level access
          • 16.2.3.4. Layout privileges
          • 16.2.3.5. Value list privileges
          • 16.2.3.6. Script privileges
          • 16.2.3.7. Editing a privilege set
      • 16.3. Managing Accounts
        • 16.3.1. Adding a New Account
        • 16.3.2. External Authentication
      • 16.4. Extended Privileges
        • 16.4.1. Creating an Extended Privilege
        • 16.4.2. Checking for an Extended Privilege
        • 16.4.3. Assigning Extended Privileges
      • 16.5. Scripts and Security
        • 16.5.1. Detecting Privileges in a Script
        • 16.5.2. Handling Security Errors
        • 16.5.3. Running Scripts with Full Access Privileges
        • 16.5.4. Managing Security with Scripts
          • 16.5.4.1. Add Account
          • 16.5.4.2. Delete Account
          • 16.5.4.3. Reset Account Password
          • 16.5.4.4. Change Password
          • 16.5.4.5. Enable Account
          • 16.5.4.6. Re-Login
    • 17. Sharing Data with Other Systems
      • 17.1. Sharing Your Data with Others
        • 17.1.1. Save/Send Records As
          • 17.1.1.1. Saving as Microsoft Excel
          • 17.1.1.2. Saving as Portable Document Format (PDF)
      • 17.2. External SQL Sources
        • 17.2.1. Setting Up ODBC
          • 17.2.1.1. The SQL database server
          • 17.2.1.2. Installing the ODBC driver
          • 17.2.1.3. Configuring the data source
        • 17.2.2. Connecting FileMaker to a SQL Data Source
        • 17.2.3. Adding SQL Tables to a FileMaker Database
          • 17.2.3.1. Creating relationships
          • 17.2.3.2. Shadow tables
        • 17.2.4. Using SQL Tables
      • 17.3. Exporting Data
        • 17.3.1. Exporting Data
          • 17.3.1.1. Grouped exports
          • 17.3.1.2. Export formats
      • 17.4. Importing Data
        • 17.4.1. Importing Over Existing Data
          • 17.4.1.1. Update existing records in found set
          • 17.4.1.2. Update matching records in found set
        • 17.4.2. Creating Tables on Import
        • 17.4.3. Creating a New Database from an Import File
        • 17.4.4. Converting Older FileMaker Files
      • 17.5. Import Data Sources
        • 17.5.1. File
        • 17.5.2. Folder
          • 17.5.2.1. Importing a folder of pictures or movies
          • 17.5.2.2. Importing a folder of text files
        • 17.5.3. Digital Camera
        • 17.5.4. XML Data Source
          • 17.5.4.1. XML export
        • 17.5.5. ODBC Data Sources
      • 17.6. Importing and Exporting in a Script
        • 17.6.1. Save Records Script Steps
        • 17.6.2. The Import Records Script Step
        • 17.6.3. The Export Records Script Step
    • 18. Sharing Your Database
      • 18.1. FileMaker Network Sharing
        • 18.1.1. Setting Up a Host Computer
        • 18.1.2. Opening a Shared File
        • 18.1.3. The Open Remote File Dialog Box
          • 18.1.3.1. Choosing a host computer
          • 18.1.3.2. Choosing a file
      • 18.2. Sharing over the Internet
        • 18.2.1. Turning on Web Sharing
          • 18.2.1.1. Advanced Web Publishing Options
          • 18.2.1.2. Configuring file access
        • 18.2.2. Connecting from a Web Browser
        • 18.2.3. Custom Home Page
      • 18.3. FileMaker Server
        • 18.3.1. File Compatibility
        • 18.3.2. Installing FileMaker Server
          • 18.3.2.1. Single Machine Installation
          • 18.3.2.2. Multiple Machine Installation
          • 18.3.2.3. Configuring Your Server
        • 18.3.3. Administering FileMaker Server
          • 18.3.3.1. Installing a Database
          • 18.3.3.2. Scheduling a Backup
        • 18.3.4. Testing Your Server
      • 18.4. Server Hardware
    • 19. Developer Utilities
      • 19.1. Copying and Pasting Database Structure
        • 19.1.1. Importing Tables and Fields
        • 19.1.2. Copying and Pasting Tables
        • 19.1.3. Copying and Pasting Fields
        • 19.1.4. Copying Scripts and Script Steps
      • 19.2. Script Debugger
        • 19.2.1. Controlling Script Execution
        • 19.2.2. Breakpoints
        • 19.2.3. Examining Errors
        • 19.2.4. Pause on Error
        • 19.2.5. Active Scripts
        • 19.2.6. Working with the Debugger Window
      • 19.3. The Data Viewer
        • 19.3.1. The Current Tab
        • 19.3.2. The Watch Tab
      • 19.4. Disable Script Steps
      • 19.5. The Database Design Report
        • 19.5.1. Generating the DDR
        • 19.5.2. Using the DDR
        • 19.5.3. Finding Broken Elements with the DDR
      • 19.6. Tooltips
      • 19.7. Custom Menus
        • 19.7.1. Editing a Menu
        • 19.7.2. Creating a New Menu
        • 19.7.3. Removing a Menu
        • 19.7.4. Installing Custom Menu Sets
      • 19.8. Developer Utilities
        • 19.8.1. Using the Developer Utilities
          • 19.8.1.1. Renaming files
          • 19.8.1.2. Create Runtime Solution application(s)
          • 19.8.1.3. Remove admin access from files permanently
          • 19.8.1.4. Enable Kiosk mode for non-admin accounts
          • 19.8.1.5. Databases must have a FileMaker file extension
          • 19.8.1.6. Create error log for any processing errors
          • 19.8.1.7. Loading and saving settings
        • 19.8.2. Delivering a Runtime Solution
      • 19.9. File Maintenance
  • VII. Appendixes
    • A. Getting Help
      • A.1. Getting Help from FileMaker Itself
        • A.1.1. The Learning Center
        • A.1.2. FileMaker Pro Help
        • A.1.3. Templates
        • A.1.4. XML Examples
      • A.2. Getting Help from FileMaker, Inc.
        • A.2.1. Updaters and Downloads
        • A.2.2. Documentation and Publications
        • A.2.3. Technical Support
        • A.2.4. FileMaker Applications
        • A.2.5. Developer Programs
      • A.3. Getting Help from the Community
        • A.3.1. Mail Lists and Newsgroups
        • A.3.2. Training/Consultants
        • A.3.3. DevCon
    • B. Filemaker Error Codes
  • Index
  • About the Authors
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje