FileMaker Pro 3-4

Starting Out

Introduction
Installation
Opening FileMaker
Moving Around FileMaker
Files, Records, Fields
All About Layouts
Sorting Information
Finding Information
More on Modes
Previewing and Printing
Creating & Deleting Records
Adding & Modifying Fields
Intro to Buttons & Scripts
The Integrated Solution

Contact Database

Planning your structure
Defining Fields
Types of Fields
Entry Options
Working on the layout
Field Formatting
Creating a layout
Importing data
Creating a goto button
Creating Mail merge Letters
Creating Labels
Making it all look pretty
Adding Graphics
Turn Graphics into Buttons
Simple Scripting
Use full List View Button
List View Sorting button

Invoicing

Repetitive fields/page eak
Calculations
HiddenFields
Deleting records/serial numbers
Relationships and Look-ups
Sliding fields on printing
Summary Totals
Copying Layouts
Two way relationships

Product Database

More on formatting layouts
Importing Pictures
Creating catalogs
Sub-Summaries
Export/export with sum

Line Items

Product Look-ups
Create Line Items database
Three database relationship
Creating and using Portals
Calculations across databases

Creating reports

Create Invoice report
Line Item Report
Exporting information
Copy data to another app.

Refining Databases

Navigating between databases
Navigating between records
Sharing Common Data
Field Tab Order
Layout Order and Display
Using Look-ups for value
Using Replace command
Paste Special-Date & Time
Tab and Paragraph control

Even More Databases

Tech Support Database
Activities Database
Customer Database Additions

Miscellaneous

Access Privileges
Sharing and Network Access
Recover damaged Databases
FileMaker Pro Preferences
Spelling
View as Form/List
Find Symbols
Multiple Finds
Paste from Index
Control Key pop-up menu

Whats New in FileMaker Pro 4

Web Features
HTML Export
GIF & JPEG Import
Sorting Portal Records
Text and Item Rotation
Excel conversion
New Preferences
Value Lists
Find Exact Matching Fields
New Scripts & Functions

Instant Web Publishing

Setting it all Up
Changing the Views
Web Companion Configuration
Security
Remote Administration

Custom Web Publishing

CDML Tool and Basics
Adding Hidden Fields
Dynamic Scripting
Resources

Control Scripts

Script Maker Basics
Perform Script, Sub-script
Pause/Resume
If, Else, End If
Loop/End Loop
Halt, Exit, Exit Loop if
User abort/error capture

Navigation Scripts

Goto Layout
Goto record/request/page
Goto related record
Goto portal row
Goto Field
Goto Next/Previous field
Goto Browse/Find/Preview

Sort, Find and Print Scripts

Sort/Unsort
Find all, Find Omitted, Omit
Perform Find
Modify last Find
Page Setup and Print
Editing Commands

Fields and Records Scripts

Set Field
Set Literal
Paste result
Paste From Index
Paste from Last Record
Paste Date, Time, User Name
New/Duplicate/Delete/Revert
Copy record/Copy all records
Replace
Delete all Records
Re-lookup

Windows and Import/Export

Freeze/Refresh Window
Scroll Window
Toggle Window/Hide Window
Show/Hide/Lock Status Area
Show/Hide Text Ruler
Set Zoom Level
View As Form/List
Export Records
Import Records

Files Scripts

New, Open, Close
Change Password
Set Use System Formats
Save a Copy As
Recover
Spelling

Miscellaneous Scripts

Show Message
Beep and Speak
Dial Phone
Open Help
Define Fields/Relationship
Open Script maker
Perform Apple script
Comment
Flush Cache to Disk
Quit Application

Text Functions 1

Basics of Functions
Exact
Left
Left Words
Length
Lower
Middle
Middle Words
Pattern Count
Position
Proper
Replace
Right
Right Words

Text Functions 2

Substitute
Text To Date
Text To Num
Text To Time
Trim
Upper
Word Count

Number Functions

Abs
Exp
Int.
Mod
Num To Text
Random
Round
Sign
Sqrt
Truncate

Date Functions

Date
Date To Text
Day & Day Name
Day of Week, Day of Year
Month & Month Name
Today
Week of Year
Week of Year Fiscal
Year

Time Functions

Hour, Minute, Seconds
Time
Time To Text

Aggregate Functions

Average
Count
Max
Min
StDev
StDevP
Sum
Get Summary

Repeating Functions

Extend
Get Repetition
Last

Financial Functions

FV
NPV
PMT
PV

Trigonometric Functions

Atan
Cos
Degrees
Ln
Log
PI
Radians
Sin

Logical Functions

Case
Choose
If
Is Empty
Is Valid

Status Functions 1

Current App. Version
Current Date
Current Error
Current Field Name
Current File Name
Current File Size
Current Found Count
Current Host Name
Current Language
Current Layout Count
Current Layout Name
Current Layout Number
Current Message Choice
Current Mode

Status Functions 2

Current Multi-User Status
Current Page Number
Current Platform
Current Portal Row
Current Printer Name
Current Record Count
Current Record Number
Current Repetition Number
Current Request Count
Current Screen Depth
Current Screen Height/Width
Current Script Name
Current Sort Status
Current System Version

Status Functions 3

Current Time
Current User Count
Current User Name