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