Dwayne Wright - FileMaker Developer

MY FILEMAKER MOVIES
I have always considered the power of a developer / trainer to produce tutorial movies a wonderful thing. I have created and sold movie collections in the past and have created tutorial movies for customers on how new feature I created for them can been used. Here is a collection of past movies I've done. I plan on updating my recording equipment in the future, so please the occasional audio pop on some of these older tutorials.

InBiz SOHO Movies	movie comments		date created
InBizness SOHO 2.2 - "Under The Hood"	shows a number of the schema design elements in this solution		04/01/2008

FileMaker 8.5 And Higher Movies	movie comments	date created
Using Script Arrays For Duplicate Found Sets	about 30 minutes in duration, shows pratical use of script arrays and looping	05/12/2008
Very Simple GTRR Example	shows a brief example of GTRR with a filtered portal	03/08/2008
Import A Folder Full Of Data	shows off how to use an example file from my example blog	02/26/2008
FileMaker 9 - Append To PDF Documents	shows off the append to existing pdf feature in FileMaker 9	12/23/2007
Tabbing Within A Tab Panel	shows the ability to navigate tab panels without using a mouse	12/06/2007

FileMaker 6 Archive Movies (originally created between 2003 and 2005
I literally pulled these from the trash bin. I created these movies back when I was doing FileMaker 6 classroom training. I wanted something the student could take with them after class. I also sold these as CD collections for those that could not attend a class but wanted the movies. I had forgotten about them until a blog reader mentioned they could not find FileMaker 5 / FileMaker 6 video training resources. So I found these, dusted them off and decided to put them up here for no charge. They were created on the original bondi blue iMac with the cheap little microphone that come with it. There are over 350 movies in total.

FileMaker 6 Basics (49 Movies)
This collection of movies was designed to introduce a new user / developer.
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.

Title	Movie Length
What Makes Up The Screen?	0:09:32
What Are FileMaker Modes?	0:05:14
What Is Under The File Menu?	0:10:22
Under The Edit Menu?	0:09:00
Under The View Menu?	0:10:42
Under The Insert Menu?	0:05:59
Under The Format Menu?	0:03:47
Under The Records Menu?	0:13:27
Under The Scripts Menu?	0:02:43
Under The Window Menu?	0:01:12
Under The Help Menu?	0:04:24
Open, Close & Quit	0:03:38
New Files & Save A Copy As	0:05:10
Form & List Views	0:03:47
Navigating Records	0:03:26
Overview Of Finds	0:06:22
The Found Set	0:03:36
AND Finds vs. OR Finds	0:03:41
Refining Searches With Symbols	0:22:45
New, Modified & Duplicate Requests	0:02:58
Omitting Records & The Found Set	0:03:50
Deleting Records	0:03:51
Sorting Records	0:06:13
Spell Checking & Dictionary Setup	0:10:21
Spell Check Word As You Type	0:03:53

Title	Movie Length
Conversion Of FileMaker Types	0:07:34
Importing Basics	0:06:02
Exporting Basics	0:07:10
Recovery Process Basics	0:03:12
Creating Fields	0:05:43
Auto Enter Field Options	0:07:04
Validation Field Options	0:08:14
Storage Options For Fields	0:12:28
Basics Of Value Lists	0:10:42
Calculation Dialog Box	0:10:28
Functions and Parameters	0:04:27
Working With Functions	0:14:46
Number Functions ( longer )	0:09:13
Date Function Basics	0:10:53
Time Functions	0:04:43
Intro To Layout Types	0:03:28
Create New Standard Layout	0:03:42
More About Layouts	0:07:30
Form Letters And Merge Fields	0:05:26
Form Letters And Insert Specials	0:06:56
Intro To Layout Parts	0:06:54
Layout Parts & Reports	0:06:54
Layouts And Fields	0:06:47
Field Tab Orders On Layouts	0:04:54

FileMaker 6 Finds And The Found Set (70 Movies)
Developed for introducing FMP6 users to the power of the search and the found set.
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.

Title	Movie Length
Text Fields	0:02:11
Number Fields	0:04:05
Date Fields	0:06:43
Time Fields	0:04:49
Calculation Fields	0:02:16
Global Fields	0:02:54
Indexing	0:07:03
Status Functions Need To Be Unstored	0:04:39
Find Mode Explored	0:02:53
FIND SYMBOLS / SEARCH OPERATORS	0:07:18
Formatting A Range Between Two Dates	0:10:12
Find Range	0:03:54
Fixing Dates That Are Formatted Incorrectly	0:05:39
Date Range Via Future Settings	0:05:03
Finding Invalid Dates	0:09:32
Searching With @	0:03:38
Regular, Exact & Field Content	0:03:31
I Don’t Want To Find	0:02:39
Adding Omit To Searches	0:02:03
Found Set Flipping	0:04:22
Range Operators In Text Searches	0:03:17
Multiple Find Requests	0:03:49
Multiple Find Request Counter	0:03:38
Constrain Found Set	0:07:14
Constrain Sans The Find	0:05:23
Extend Found Set	0:03:37
Enter Find Mode Script Step	0:03:42
Simple Sort	0:01:56
Sorting On Multiple Fields	0:03:00
Value List Sorting	0:06:45
The Basic Import	0:04:14
Import ( Replace Or Match )	0:13:20
Import Folder Full Of Data	0:09:53
Duplicate Found Set ( Import )	0:05:52
Omit In A Multiple Request Search	0:02:35

Title	Movie Length
Duplicate Found Set ( Omit )	0:03:21
Counting Duplicates Via Aggregate Functions	0:08:44
Out Of Control Cascading Deletes	0:04:24
Copy All Records	0:03:39
Saving Found Sets Of Data	0:12:02
Search Replace Command	0:08:04
Lookup	0:02:36
Emulate Search And Replace	0:02:14
Special Find With Symbols	0:03:01
Mimic Record Status Display	0:02:15
Set Range Fails In Scripted Finds	0:03:36
Find Month Via Calculation	0:08:45
Find Deleted All My Data	0:05:34
Using A Search Layout	0:09:02
Using A Search Dialog	0:04:07
Saved Search Settings	0:05:40
Creating A Custom Find Windoid	0:08:50
Finds In Portals ( Unstored Parent Keys )	0:02:46
Found Set Shows Up In A Portal 1	0:05:47
Found Set Shows Up In A Portal 2	0:08:25
Scripted Or Find With Portal Display	0:04:28
Marked Portal Rows	0:05:00
Marked Portal Rows ( Multi-user)	0:09:08
AND Searches In A Portal	0:05:30
Relevance On Found Set	0:08:12
Selecting Random Records	0:08:43
No Menu Options For Copy, Cut And Paste	0:02:17
Menu Control Via Passwords	0:03:47
A Login System / Found Set Control	0:09:43
Find Mode Only Field Entry	0:03:38
Email Address Searches	0:02:48
Finding Text In Number Fields	0:07:09
Portal Mind Reader	0:04:05
Multiple Page Setups In 1 Script	0:04:20
Record Level Access	0:04:18

FileMaker 6 Calculations & Functions (38 Movies)
Developed for introducing FMP6 users to the power of the calculation.
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.

Title	Movie Length
Calculate Current Age	0:08:16
Bar Charts With Text Functions	0:04:28
Text Color Via Calculation	0:02:16
Remove Leading / Trailing Returns	0:03:54
Remove Unwanted Returns	0:05:16
Checks To Normal Text	0:11:08
Amount Due Via Aggregates	0:06:42
Platform Functions	0:03:17
Currency Display Calc Control	0:04:04
Case Vs Choice	0:03:35
Dynamic Lists Via GetField	0:05:52
Where The Empty Fields Are	0:01:32
Exporting Field Names	0:03:29
Field Info Recorder	0:06:37
Number Functions Explored	0:05:23
Text Functions Explored	0:16:01
Sort Portals Via GetField	0:04:16
Rounding To The Half	0:04:26
Calc Last Day Of Month	0:03:40

Title	Movie Length
Exact Function Explored	0:03:06
When Is Monday	0:01:44
Returning Value Lists - Part 1	0:04:54
Returning Value Lists - Part 2	0:09:05
All Records For Previous Month	0:06:25
All Records For Previous Month 2	0:05:30
What Quarter Date Is In	0:07:01
Layout Nav Via Screen Resolution	0:01:08
Shift Key Shows Hidden Features	0:02:20
Exit Or Pause Via Shift Key	0:01:29
Validate SS Number	0:10:08
Upper Case Detection	0:05:09
What Is The Monday Of The Week	0:07:14
Fixing Date Format Woes	0:06:40
Date Range Fomatting	0:06:21
Count Dups Via Aggregates	0:07:33
Date Functions Explored	0:06:22
Emulate Search And Replace	0:02:07
Special Find With Symbols	0:03:02

FileMaker 6 Relationships & Portals (55 Movies)
Developed for introducing FMP6 users to the power of the relationship and portal.
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.

Title	Movie Length
Aggregate Totals In Portal Row	0:06:13
Portal Used As A Button Dock	0:05:59
Navigate Portal Rows Via Buttons	0:02:23
Portal Row Buttons	0:02:32
Changing Child Data In A Portal	0:02:01
Dubl Click Reorder - Single Click Light Up	0:03:20
Duplicating Related Records	0:04:59
Dynamic Portal Information	0:03:54
Exporting Portal Row Data	0:03:57
Get Field - Filtering Portals	0:01:33
GetField Sort ASC / DESC With Color	0:02:51
Get Field Function Sorting Portals With Color	0:02:37
Globals Making New Portal Rows	0:05:48
GTRR and Print	0:03:05
Go To Related Record - GTRR	0:00:56
Portals Only In Find Mode	0:02:55
Hidden Port	0:03:57
Move Portal Row Data	0:06:20
Multiple Portals But Only One Child File	0:03:20
New Portal Row At The Top	0:08:08
Portals When Nothing Happened	0:03:07
Each Field Is A Related Record	0:09:53
Portal Date Ranges Via Date Popups	0:06:37
Portal Lookup Failure	0:04:36
Page Up / Down Portal Rows Via Buttons	0:04:02
Show With / Without Portal Snap	0:04:10
Portal Data As Text	0:07:03
Portal Buttons Within Fields	0:05:19

Title	Movie Length
Repeating Fields To Portal Rows	0:03:42
Repeating Fields To Portal Rows ( 2 )	0:02:07
Counting Portal Rows	0:02:49
New Portal Row Failure ( calc )	0:02:32
New Portal Row Failure ( security )	0:03:50
Set Field Via Portal	0:01:25
Simple Filter	0:01:50
Single Character Filter With All Option	0:05:26
Portal Sort Via Calculation	0:03:22
Split Screen	0:02:37
Go To Particular Portal Row	0:06:37
Scripting Related Records	0:10:16
Universal Pick List	0:03:21
Universal Move Data	0:02:12
Unique Only Values	0:08:19
Value Lists And Portals	0:09:10
A Week Calendar Via 7 Portals	0:04:00
Copy And Paste A Portal Row	0:04:11
Found Set Shows Up In A Portal	0:05:46
Found Set Shows Up In A Portal 2	0:08:25
Portal Sort Via Calculation	0:04:08
Mark Portal Rows	0:04:59
Mark Multiple User	0:09:09
Portal Mind Reader	0:04:05
Finds In Portals ( unstored parent keys )	0:02:47
Scripted OR Find With Portal Display	0:04:32
Script Looping Portal Rows	0:03:05

FileMaker 6 Scripts & ScriptMaker (106 Movies)
Developed for introducing FMP6 users to the power of the FileMaker script.
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.

Title	Movie Length
Say Hello To Scriptmaker	0:04:30
Script Overview Dialog Box	0:06:42
Script Definition Builder Dialog	0:06:45
Script Definition Hints	0:06:10
Layout Buttons	0:04:57
Buttons With Script Options	0:09:15
Modular Script Design	0:06:25
Scriptmaker Steps	0:04:15
Perform Script Step	0:02:29
Pause / Resume Script Step	0:04:10
Enter Key Tabbing	0:03:27
Exit And Halt Script Steps	0:02:02
If, Else, And End If Script Steps	0:06:01
Looping Script Steps	0:03:20
Exit Loop If	0:04:00
Allow User Abort	0:06:22
None Found Status Enhanced *	0:08:59
Go To Layout	0:02:48
Go To Record / Request / Page	0:07:03
Go To Record / Request *	0:06:50
Go To Related Record	0:02:28
Go To Portal Row	0:07:18
Last Of Navigation Steps	0:05:28
Sort Script Steps	0:03:45
Show All And Omit	0:05:11
Perform Find Script Step	0:07:43
Page Setup & Print	0:04:26
Editing Script Steps	0:04:40
Copy / Paste Failure	0:02:28
Set Field	0:02:28
Script Log	0:05:39
Insert Text	0:08:44
More Insert Options	0:05:57
Intro To Records Script Steps	0:06:56
More About Records Script Steps	0:05:32
Delete, Replace & Relookup	0:11:51
Windows Script Steps	0:02:18
Windows Script Steps Continued	0:05:16
Files Script Steps	0:07:43
Spelling Script Steps	0:03:59
Show Message Script Step	0:03:28
Show Custom Dialog Script Step	0:09:30
Speak, Beep & Toolbars	0:03:25
Open Url & Send Mail	0:06:36
About Calculations In Use	0:05:52
Send Mail Script Step	0:06:10
The Calculation Dialog Box	0:07:07
Basic Introduction To Functions	0:06:05
Nested Functions	0:03:17
Types Of Functions	0:05:44
Text Functions	0:16:03
Number Functions ( shorter )	0:05:23
Date Functions	0:06:22

Title	Movie Length
Time Functions	0:02:53
Aggregate Functions	0:02:23
If, Case And Choose Functions	0:09:47
IsEmpty And Isvalid	0:03:02
Get Field Function	0:05:53
Status Functions	0:12:22
Design Functions	0:06:27
Intro To Relationships	0:06:58
One To Many Plus	0:02:04
Many To Many Relationship	0:05:17
Universal Or Constant Relationship	0:02:10
Filtered Relationship	0:04:18
Steps To Defining A Relationship	0:06:12
About Lookup Fields	0:05:55
Intro To Portals	0:07:14
Adding Fields And Other Objects To A Portal	0:05:42
Portal Row Buttons	0:02:31
Portal Buttons Within Fields	0:05:18
Portal Used As A Button Dock	0:05:59
Globals Making New Portal Rows	0:05:48
Portal Row At The Top	0:08:08
Marking Portal Rows	0:05:00
Marked Portal Rows ( Multi-user)	0:09:08
Found Set Shows Up In A Portal 1	0:05:46
Found Set Shows Up In A Portal 2	0:08:25
Copy And Paste A Portal Row	0:04:12
Scripted Or Find With Portal Display	0:04:28
Show With / Without Portal Snap	0:04:10
Nested If Vs Sequential	0:13:00
Script For Show Message Branching	0:02:56
Script For Custom Dialog Branching	0:06:39
Auto Layout Navigation	0:01:08
Status(current Error)	0:06:17
Build Hidden Features Via The Shift Key	0:02:21
Security By Password Group	0:10:23
Multi-file Linking Scripts To Main File	0:04:11
Introducing Looping Scripts	0:02:00
Tell Scriptmaker When To Exit A Loop	0:01:30
Organized Notes Via Scriptmaker	0:02:50
Script Looping Portal Rows	0:03:03
Scripted Record Duplication	0:05:00
Scripted Finds Need Inserted Find Ranges	0:03:36
Potential Cross Platform Problems	0:03:17
Page Setup, Sort, Find, Import / Export Scripting	0:04:20
Portal Lookup Failure	0:04:35
Security Settings Breaking Scripts	0:03:27
No Export Breaks Copy All	0:03:38
Talk To Me Troubleshooting	0:04:03
Eternally In A Script	0:06:45
Go Back Navigation	0:02:56
Scripting Related Record Creation	0:10:16
Emulate Search And Replace	0:02:07
Exporting Field Names	0:03:29

FileMaker 6 Secure Design (37 Movies)
Designed To Complement My FileMaker 6 Secure Guide And Training Classes
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.

Title	Movie Length
Random Passwords V2	0:02:39
Random Passwords V1	0:03:32
Password Control Actions	0:05:18
Taking Away Menu Options	0:05:16
No Edit Can Break Scripts