
FileMaker Pro 8: Advanced
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 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.<p>rn<font color=\"red\">The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 8 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 <a class=\"linkNineAlt\" href=\"http://www.databasepros.com\" target=\"_blank\">www.databasepros.com</a> web site.</font></p>rn<p><i>* 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. </i></p>rn<p><i>** This tutorial is part three in a 3-part FileMaker Pro 8 series. </i></p>
Course content
Introduction5 lessons
Ultimate Find10 lessons
- Why Script a Find?3:441 credit or ad
- Find Layout7:321 credit or ad
- Continue and Cancel6:531 credit or ad
- Modular Scripting4:441 credit or ad
- Error Capture pt. 15:391 credit or ad
- Error Capture pt. 26:031 credit or ad
- Modify Find6:461 credit or ad
- Dynamic Scripting5:541 credit or ad
- Finishing Touches pt. 15:281 credit or ad
- Finishing Touches pt. 24:541 credit or ad
Save a Found Set15 lessons
- Organization pt. 15:571 credit or ad
- Organization pt. 22:481 credit or ad
- Loop with Global5:551 credit or ad
- Loop with Variable pt. 13:141 credit or ad
- Loop with Variable pt. 25:421 credit or ad
- GetNthRecord5:551 credit or ad
- Tail Recursion5:531 credit or ad
- Compare and Contrast6:001 credit or ad
- Save Multiple Found Sets pt. 13:571 credit or ad
- Save Multiple Found Sets pt. 24:301 credit or ad
- Duplicate Set Names4:531 credit or ad
- Restore Multiple Found Sets pt. 13:581 credit or ad
- Restore Multiple Found Sets pt. 26:081 credit or ad
- New Window pt. 15:321 credit or ad
- New Window pt. 24:141 credit or ad
Parsing Text14 lessons
- Text Parsing Features0:571 credit or ad
- Gather Find Criteria pt. 16:421 credit or ad
- Gather Find Criteria pt. 24:031 credit or ad
- Store Find Criteria pt. 14:321 credit or ad
- Store Find Criteria pt. 26:181 credit or ad
- Parse Find Criteria pt. 15:571 credit or ad
- Parse Find Criteria pt. 26:371 credit or ad
- Compare and Contrast4:391 credit or ad
- Parse Email pt. 14:301 credit or ad
- Parse Email pt. 23:141 credit or ad
- Parse Popup Menu7:251 credit or ad
- New Requests Made Easier pt. 17:161 credit or ad
- New Requests Made Easier pt. 25:431 credit or ad
- New Requests Made Easier pt. 35:451 credit or ad
Delete Duplicates12 lessons
- Exclamation Point2:101 credit or ad
- Duplicate Calculation3:181 credit or ad
- Global Loop pt. 13:451 credit or ad
- Global Loop pt. 24:331 credit or ad
- Improving the Loop8:031 credit or ad
- Replace Field Contents5:161 credit or ad
- Export by Group pt. 14:131 credit or ad
- Export by Group pt. 23:411 credit or ad
- Validate on Exit6:341 credit or ad
- Compare and Contrast5:301 credit or ad
- Contacts from Invoices pt. 15:141 credit or ad
- Contacts from Invoices pt. 26:021 credit or ad
Recursive Phone Filter10 lessons
- Native Formula3:091 credit or ad
- Static Case Statement5:461 credit or ad
- Recursive Formula pt. 14:091 credit or ad
- Recursive Formula pt. 23:361 credit or ad
- Faster and Easier to Read4:381 credit or ad
- Global Preferences7:141 credit or ad
- Other Global Preferences pt. 16:441 credit or ad
- Other Global Preferences pt. 24:461 credit or ad
- Multi-User Preferences pt. 15:491 credit or ad
- Multi-User Preferences pt. 23:111 credit or ad
Back Button11 lessons
- Mimic Web Browser1:211 credit or ad
- Storing Layouts pt. 14:101 credit or ad
- Storing Layouts pt. 24:151 credit or ad
- Back Layout7:271 credit or ad
- Forward Layout6:041 credit or ad
- Back Record & Window pt. 17:191 credit or ad
- Back Record & Window pt. 25:571 credit or ad
- Visual Interface Cue7:111 credit or ad
- Dimmed Buttons Structure pt. 13:431 credit or ad
- Dimmed Buttons Structure pt. 25:571 credit or ad
- Dimmed Buttons Script5:591 credit or ad
Custom Form Letters14 lessons
- Why Spend the Time?3:541 credit or ad
- Form Letter Fields7:031 credit or ad
- Form Letter Interface pt. 14:071 credit or ad
- Form Letter Interface pt. 25:011 credit or ad
- Print Layout6:081 credit or ad
- Print Script pt. 15:381 credit or ad
- Print Script pt. 23:441 credit or ad
- Save and Insert Letters pt. 16:461 credit or ad
- Save and Insert Letters pt. 24:501 credit or ad
- Save and Insert Letters pt. 33:111 credit or ad
- Changing Text Style3:121 credit or ad
- Text Attribute Script pt. 16:021 credit or ad
- Text Attribute Script pt. 25:491 credit or ad
- Text Attribute Script pt. 32:361 credit or ad
Final Touches8 lessons
- Delete Portal Row pt. 15:481 credit or ad
- Delete Portal Row pt. 25:581 credit or ad
- Hidden Notes pt. 15:141 credit or ad
- Hidden Notes pt. 24:091 credit or ad
- Menu Button Change6:001 credit or ad
- Print as PDF Dynamically7:291 credit or ad
- Better List to Form4:081 credit or ad
- Final Adjustments4:051 credit or ad