Welcome To DwayneWright.com!
FileMaker Developer & Trainer ( formerly known as LeSaux Media Services )


Training Products | Training Classes | Consulting & Support | Solutions | Store | Home



Main | Articles | Movies | Examples

Welcome to my collection of free FileMaker training examples. Many of these examples have associated QuickTime movies. In order to watch movies, you'll need to have QuickTime installed on your machine. If you don't have quicktime ( which works great on both Windows machines and Macintosh machines), click here for a free download of the player.


SELECTED EXAMPLES FROM
THE GUIDE TO FILEMAKER 6 FOUND SET
Exporting Field Labels Along With The Data
View The Found Set In A Portal ( 1 )
View The Found Set In A Portal ( 2 )
Regular, Exact and Field Content Searches
Marking Portal Rows ( single user )
Marking Portal Rows ( multiple users )
Dup A FMP Found Set Via Omit Method
Status Functions Needs Unstored
Find Range
Formatting A Range Between Dates

Date Range Via Future Settings
Finding Invalid Dates
Fixing Dates That Are Formatted Incorrectly

Searching With @
Regular, Exact And Field Content Searches

Counting Duplicates Via A Calculation
I Don't Want To Find
Found Set Flipping

Range Operators In Text Searches
Multiple Find Requests
Multiple Find Request Counter

Constrain Found Set
Constrain Sans The Find

Extend Found Set
Sorting On A Single Field
Sorting On Multiple Fields

Value List Sorting
The Basic Import
Import (Replace Or Match)

Import Folder Full Of Data
Omit In A Multiple Request Search
Duplicate Found Set Of Data (import)
Duplicate Found Set Of Data (omit)

Out Of Control Cascading Delete
Copy All Records
Saving Found Sets Of Records

Search / Replace Command
Lookups Explored
Emulate Search And Replace
Special Find With Symbols

Mimic Record Status Display
Set Range Fails In Scripted Finds
Find Month Via A Calculation

Find Deleted All My Data!
Using A Search Layout
Using A Search Dialog
Saved Search Settings
Creating A Custom Find Windoid

Finds In Portals (unstored parent key)
GTRR - Go To Related Record
Filtered Portals

Found Set In A Portal
Found Set In A Portal (multiple line keys)
Scripted OR Find With Portal Display
AND Searches In A Portal
Revelvance On The Found Set
Selecting Random Records
Menu Control Via Passwords
No Menu Options For Copy, Cut & Paste

A Log In System - Found Set Control
Find Only Field Entry
Email Address Searches
Finding Text In Number Fields

Multiple Page Setups In One Script
Portal Mind Reader

SELECTED EXAMPLES FROM
THE GUIDE TO FILEMAKER 6 SCRIPTING

Layout Buttons With Script Options
Nested IF vs Sequential IF

FileMaker Many To Many Relationships
Scripting Finds / Searches With FileMaker
Tabbing Using The Enter Key In FileMaker
FileMaker's Show Custom Dialog Box Explained
Portal Row Buttons Within Fields
Multiple File Script Linking To Main File

SELECTED EXAMPLES FROM
THE GUIDE TO FMP7 SECURE DESIGN
Record Level Access

SELECTED EXAMPLES FROM

THE GUIDE TO FMP6 RELATIONSHIPS
Moving Data Via A Constant Relationship

SELECTED EXAMPLES FROM
THE GUIDE TO FILEMAKER 6 PORTALS
Portal Row Buttons Within Fields
New Related Record Via Hidden Portal
Sorting Portal With GetField Function
Portal Sorting Via A Calculation
Aggregate Totals In Portal Row
Go To Related Record ( GTRR )
Portal Shows What Has Not Happened
Portal Data As Text
Simple Portal Filter
Value Lists And Portals
Marking Rows For GTRR (single)
Marking Rows For GTRR (multiple)


EXAMPLES FROM
THE FILEMAKER 6
GUIDE TO SECURE DESIGN

Building Random Passwords
Building Random Real Word Passwords
Bypass Log In
Controlling A Calculated Result Via A Group
Controlling A Script Via An Access Group
Copy All Records Step
Current User Logging
Encrypt Folder- Invoice, Psold & Prices
Enter Into A Field If
Eternally In A Script With Global Submits
Example Of No Password Access
Export Record Setting Danger
Go To Hidden Layout Via Entered Password
Hide Area With Container
Hiding Password Text
Holding Down Modifier Keys
Indexing Sees All
Launch Example
Log In System - Found Set Control
Menu Control Via Passwords
Mimic Record Status Display
New Record Access And Layouts
No Edit Can Break Scripts
No Menu Options For Cut, Copy & Paste
Out Of Control Cascading Deletes
Record Locking Via Validation
Relationship Breakage
Record Level Access
Script Log
Serial Numbers
Splash Screen Only Access
Storage Options For Status Functions
Time Bomb By Date
Time Bomb By Date First Opened
Time Bomb By Number Of Records
Time Bomb By Number Of Times Opened

Timed Log In
Value List Danger

SELECTED EXAMPLES FROM GUIDE TO
FILEMAKER 6
CALCULATIONS

FileMaker Text Functions Explored
FileMaker Number Functions Explored
Field Info Recorder
Count Dups Via Aggregates
Dynamically Change Fields In A Column
Upper Case Detection

Removing Leading/Trailing Carriage Returns
Creating A Bar Chart With Text Functions
Using Functions To Remove Carriage Returns
Return Values Lists ( 2 )
Upper Case Detection

Emulate Search And Replace
Using The Exact Function
Validate Social Security Number
Rounding To The Half
Formatting Currency

When Is The Monday Of The Week?
Calculating A Persons Age
Calculating The Last Day Of The Month
Calculating The Number Of Work Days

Fixing Dates That Are Formatted Incorrectly
Formatting A Range Between Two Dates
Show All Records For A Previous Month

Show All Records For A Previous Month (2)
Military Time vs Regular Time Display
Counting Duplicates Via Aggregate Functions
Dynamic List View (get field function)
Filtered Portals (get field function)

Change Text Color Via A Calculation
Display Text For Empty Fields
Exit Or Pause A Script With The Shift Key
Troubles Printing In Cross Platform Settings
Build Hidden Features With Shift Key

IN DEPTH TRAINING TUTORIALS
These tutorials go into much greater depth than an example. They normally contain an example file, a multiple page pdf guide and QuickTime training movies.

Building Navigation Tab Interfaces With FileMaker 7 Features


SHAREWARE SOLUTIONS COMPATIBLE WITH FILEMAKER 7 AND FILEMAKER 8
These solutions are SHAREWARE, so please respect the shareware rights attached to them. If you decide to use them, please pay the $5.00 shareware fee and I'll have a pizza in your honor!

InBizness Real Estate

SHAREWARE SOLUTIONS COMPATIBLE WITH FILEMAKER 6 TO FILEMAKER 5
These solutions are dated, in fact the most recent ones are at least 4 years old. However, I get requests for them all the time. Here they are and if you decide to use them, please pay the $5.00 shareware fee.

Bank Deposit Recorder
The Training Database
Used Cars
Applicant Interview Rating
Cashiers Till
Checkbook 99
Church Business
Classifieds
Designers Log 2000
Designers Log Classic
eSend & eBatch
eTrain 3.0
InBizness Clients
InBizness Employee
InBizness Equipment
InBizness Fund Raiser
InBizness Fund Raiser Lite
InBizness Support
Mystery Caller
Office Expenses
Pledge and Pay
Position, Hire, Employee
Professional Support
Profit and Loss
Script Runner
The Book Group
The Runz



Unauthorized reproduction in any form is strictly prohibited without prior permission. The material on this website is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this site. WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded.