Title Language  : 

Find a Course... Try for Free!

 

FileMaker Pro 9: Advanced Tutorials

Course Content
FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical "how to" course by FileMaker expert John Mark Osborne, starts from advanced level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5 and 9 features and techniques including the Ultimate Find, saving a found set of records for future retrieval, saving find criteria for future use, text parsing to create features, making new requests easier for users, parsing web form generated emails, five methods for deleting duplicates, recursive phone filter, creating preferences in a single-user and multi-user scenario, web-like back and forward buttons, conditional buttons, custom form letters, changing text attributes with scripts and many more techniques with an emphasis on adaptive scripting and calculations. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. To begin learning today, simply click on one of the FileMaker Pro 9: Advanced links.

The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 9 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution. If you would like to purchase the completed invoicing solution, please visit the www.databasepros.com web site.

* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary.

** This tutorial is part three in a 3-part FileMaker Pro 9 series.

*** Captions not yet available on CD version.

QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Introduction
 About John Mark Osborne (04:19)
 FileMaker 9 Family of Products pt. 1 (05:15)
 FileMaker 9 Family of Products pt. 2 (04:46)
 About the Tutorial Series pt. 1 (06:01)
 About the Tutorial Series pt. 2 (03:32)
 Why an Invoicing Solution? pt. 1 (07:15)
 Why an Invoicing Solution? pt. 2 (04:09)
 Accounts & Passwords (01:10)
Ultimate Find
 Why Script a Find? (04:10)
 Find Layout (06:43)
 Continue & Cancel (06:52)
 Modular Scripting (05:36)
 No Records Found (04:38)
 No Find Criteria (07:41)
 Modify Find (07:02)
 Dynamic Scripting (05:34)
 List Versus Form (04:17)
 Save by Table Occurrence pt. 1 (07:14)
 Save by Table Occurrence pt. 2 (03:12)
Save a Found Set
 Organization pt. 1 (05:43)
 Organization pt. 2 (04:28)
 Loop with Global (06:54)
 Loop with Variable (06:08)
 Speed Testing (04:51)
 GetNthRecord Recursion (07:25)
 Compare & Contrast (06:02)
 Save Multiple Found Sets (07:27)
 Duplicate Set Names (05:33)
 Restore Multiple Found Sets pt. 1 (06:16)
 Restore Multiple Found Sets pt. 2 (07:12)
 User Interface (06:13)
Parsing Text
 Advanced Text Parsing Techniques (05:36)
 Store Find Criteria (07:11)
 Save Find Criteria (05:49)
 Restore Find Criteria pt. 1 (05:36)
 Restore Find Criteria pt. 2 (06:08)
 Compare & Contrast (04:13)
 Parse E-mail (06:47)
 Parse Pop-up Menu pt. 1 (03:16)
 Parse Pop-up Menu pt. 2 (04:08)
 New Requests Interface pt. 1 (04:28)
 New Requests Interface pt. 2 (03:30)
 New Requests Script (06:19)
Delete Duplicates
 Basic Duplicate Search (05:33)
 Global Loop pt. 1 (04:16)
 Global Loop pt. 2 (03:37)
 Improving the Loop (04:47)
 Replace Field Contents (08:25)
 Export by Group pt. 1 (03:34)
 Export by Group pt. 2 (04:16)
 Validate on Exit (06:01)
 Compare & Contrast (06:34)
 Contacts from Invoices pt. 1 (04:46)
 Contacts from Invoices pt. 2 (03:06)
 Contacts from Invoices pt. 3 (03:49)
Recursive Phone Filter
 Native Formula (02:00)
 Static Case Statement (05:13)
 Recursive Formula (06:52)
 Global Preferences (05:59)
 Startup Layout (03:18)
 Personal Information (05:55)
 Auto Enter (03:21)
 Multi-User Preferences pt. 1 (03:34)
 Multi-User Preferences pt. 2 (04:12)
 Multi-User Preferences pt. 3 (07:07)
Back Button
 Mimic Web Browser (02:08)
 Storing Layouts pt. 1 (03:45)
 Storing Layouts pt. 2 (04:09)
 Back Layout pt. 1 (03:50)
 Back Layout pt. 2 (03:54)
 Forward Layout (07:03)
 Back Record & Window pt. 1 (03:32)
 Back Record & Window pt. 2 (04:48)
 Visual Interface Cue (06:33)
 Dimmed Buttons Structure pt. 1 (04:03)
 Dimmed Buttons Structure pt. 2 (04:33)
 Dimmed Buttons Script (07:20)
Custom Form Letters
 Flexible Form Letters (03:30)
 Form Letter Fields pt. 1 (03:13)
 Form Letter Fields pt. 2 (04:39)
 Form Letter Interface (07:58)
 Print Layout (05:47)
 Print Script pt. 1 (06:06)
 Print Script pt. 2 (04:42)
 Save Letter (07:24)
 Insert Letter pt. 1 (05:05)
 Insert Letter pt. 2 (02:39)
 Changing Text Style (02:39)
 Text Attribute Script pt. 1 (05:11)
 Text Attribute Script pt. 2 (06:07)
FileMaker 9 Techniques
 Conditional Formatting Basics pt. 1 (03:22)
 Conditional Formatting Basics pt. 2 (05:06)
 Change Background (04:01)
 Field Highlight (02:22)
 Better List View? (07:03)
 Record Highlight (08:02)
 Hidden Field Labels (04:43)
 Portal Resize (06:41)
 Sorting Portals (05:34)
 Highlight Portal Row (04:38)
Final Touches
 Delete Portal Row pt. 1 (05:35)
 Delete Portal Row pt. 2 (06:50)
 Hidden Notes pt. 1 (04:43)
 Hidden Notes pt. 2 (03:39)
 Menu Button Change (06:09)
 Print as PDF Dynamically pt. 1 (06:15)
 Print as PDF Dynamically pt. 2 (04:41)
 Better List to Form (03:43)
 Check List (05:53)
Working with John Mark Osborne
 Free Resources pt. 1 (04:47)
 Free Resources pt. 2 (03:42)
 Training (05:21)
 Consulting & Meta-Consulting (02:21)
 Solutions (06:04)
 Contacting John Mark Osborne (01:55)


Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: FileMaker Pro 9: Advanced
Author: John Mark Osborne
SKU: 33824
ISBN: 1-934743-32-1
Duration: 10 hrs / 115 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products