
FileMaker Pro 11: 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 7, 8, 8.5, 9, 10 and 11 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, script triggers 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 the movie links.
Course content
Introduction13 lessons
- About John Mark Osborne3:35Free
- System Requirements3:41Free
- FileMaker 11 Family of Products pt. 16:02Free
- FileMaker 11 Family of Products pt. 25:07Free
- About the Tutorial Series pt. 16:23Free
- About the Tutorial Series pt. 25:51Free
- Why an Invoicing Solution? pt. 14:54Free
- Why an Invoicing Solution? pt. 25:39Free
- What is a Database? pt. 15:04Free
- What is a Database? pt. 23:31Free
- Planning Your Solution7:03Free
- New FileMaker 11 Features7:38Free
- IMPORTANT: Work File Passwords3:17Free
Ultimate Find16 lessons
- Why Script a Find?6:261 credit or ad
- Find Layout7:061 credit or ad
- Basic Find Script with Button7:091 credit or ad
- Continue & Cancel pt. 16:021 credit or ad
- Continue & Cancel pt. 22:311 credit or ad
- Cancel Improved2:571 credit or ad
- Modular Scripting5:151 credit or ad
- No Records Found6:421 credit or ad
- No Find Criteria4:231 credit or ad
- Errors in Memory5:341 credit or ad
- Modify Find7:571 credit or ad
- Dynamic Scripting6:131 credit or ad
- List vs. Form5:151 credit or ad
- Save by Table Occurrence pt. 15:531 credit or ad
- Save by Table Occurrence pt. 24:141 credit or ad
- Save by Table Occurrence pt. 37:221 credit or ad
Save a Found Set17 lessons
- Organization pt. 16:551 credit or ad
- Organization pt. 22:461 credit or ad
- Loop with Global pt. 14:201 credit or ad
- Loop with Global pt. 24:011 credit or ad
- Loop with Variable4:401 credit or ad
- Speed Testing6:091 credit or ad
- GetNthRecord Recursion7:281 credit or ad
- Compare & Contrast pt. 14:321 credit or ad
- Compare & Contrast pt. 24:071 credit or ad
- Save Multiple Found Sets7:071 credit or ad
- Duplicate Set Names5:091 credit or ad
- Restore Multiple Found Sets Layout5:001 credit or ad
- Restore Multiple Found Sets Script5:431 credit or ad
- Completing the Interface6:131 credit or ad
- Account Aware Found Sets5:261 credit or ad
- Save with Snapshot Link5:221 credit or ad
- Restore with Snapshot Link6:441 credit or ad
Parsing Text13 lessons
- Advanced Text Parsing Techniques6:171 credit or ad
- Gathering Find Criteria5:441 credit or ad
- Saving Find Criteria7:341 credit or ad
- Restoring Find Criteria pt. 14:321 credit or ad
- Restoring Find Criteria pt. 25:531 credit or ad
- Restoring Find Criteria pt. 34:191 credit or ad
- Compare & Contrast8:261 credit or ad
- Parse Web Form7:501 credit or ad
- Parse Popup Menu7:481 credit or ad
- New Requests Interface5:581 credit or ad
- New Requests Script pt. 15:011 credit or ad
- New Requests Script pt. 25:581 credit or ad
- Charting with Delimited Data6:351 credit or ad
Delete Duplicates15 lessons
- Basic Duplicate Search5:481 credit or ad
- Global Loop pt. 14:511 credit or ad
- Global Loop pt. 22:551 credit or ad
- Improving the Loop5:531 credit or ad
- Replace Field Contents7:171 credit or ad
- Improving Replace Technique3:511 credit or ad
- Export by Group7:191 credit or ad
- Merging Duplicate Records6:241 credit or ad
- Validating Duplicates4:591 credit or ad
- Compare & Contrast5:401 credit or ad
- Scripted Duplicates Defined6:011 credit or ad
- Scripted Duplicates Interface7:211 credit or ad
- Scripted Duplicates Scripts pt. 14:191 credit or ad
- Scripted Duplicates Scripts pt. 24:261 credit or ad
- Scripted Duplicates Scripts pt. 37:111 credit or ad
Recursive Phone Filter16 lessons
- Why Recursion?7:551 credit or ad
- Recursive Formula7:171 credit or ad
- Global Preferences pt. 14:201 credit or ad
- Global Preferences pt. 26:041 credit or ad
- Startup Layout4:151 credit or ad
- Personal Information5:481 credit or ad
- Auto Enter pt. 13:031 credit or ad
- Auto Enter pt. 25:451 credit or ad
- Multi-User Preferences pt. 16:171 credit or ad
- Multi-User Preferences pt. 24:221 credit or ad
- Multi-User Preferences pt. 34:041 credit or ad
- Multi-User Preferences pt. 46:071 credit or ad
- Multi-User Preferences pt. 53:171 credit or ad
- Multi-User Preferences without Accounts pt. 16:581 credit or ad
- Multi-User Preferences without Accounts pt. 25:341 credit or ad
- Revisiting Validation7:001 credit or ad
Back Button11 lessons
- Mimic Web Browser3:101 credit or ad
- Storing Layouts6:571 credit or ad
- Back Layout pt. 14:431 credit or ad
- Back Layout pt. 23:171 credit or ad
- Forward Layout5:411 credit or ad
- Back Record & Window7:201 credit or ad
- Visual Interface Cue7:251 credit or ad
- Dimmed Buttons Structure5:121 credit or ad
- Dimmed Buttons Interface6:491 credit or ad
- Dimmed Buttons Script6:031 credit or ad
- Dimmed Buttons for Multiple Tables7:181 credit or ad
Custom Form Letters12 lessons
- Flexible Form Letters4:071 credit or ad
- Form Letter Fields6:211 credit or ad
- Form Letter Interface pt. 15:491 credit or ad
- Form Letter Interface pt. 22:301 credit or ad
- Print Layout5:491 credit or ad
- Print Script7:241 credit or ad
- Record Locking Issue3:371 credit or ad
- Save Letter8:121 credit or ad
- Insert Letter5:511 credit or ad
- Changing Text Style Components5:261 credit or ad
- Changing Text Style Interface5:311 credit or ad
- Changing Text Style Script7:271 credit or ad
Miscellaneous Techniques11 lessons
- Conditional Formatting Basics4:541 credit or ad
- Dimmed Buttons4:501 credit or ad
- Field Highlight3:321 credit or ad
- Better List View5:441 credit or ad
- Hidden Field Labels4:371 credit or ad
- Portal Resize2:121 credit or ad
- Sorting Portals8:121 credit or ad
- Totaling to Zero1:091 credit or ad
- Highlight Portal Row4:421 credit or ad
- Cross-Tab Reports5:541 credit or ad
- Transaction Processing6:201 credit or ad
Event Driven Scripting22 lessons
- Overview & Considerations pt. 16:381 credit or ad
- Overview & Considerations pt. 23:361 credit or ad
- Definitions pt. 14:341 credit or ad
- Definitions pt. 24:421 credit or ad
- Simple Yet Powerful Triggers4:101 credit or ad
- Resetting Globals4:071 credit or ad
- Using the Toolbar6:361 credit or ad
- Validating Duplicates Revisited pt. 17:141 credit or ad
- Validating Duplicates Revisited pt. 22:031 credit or ad
- Portal Refresh6:471 credit or ad
- Custom Quick Find6:021 credit or ad
- Highlight Quick Find6:261 credit or ad
- Commit Record6:131 credit or ad
- Save/Revert Record6:281 credit or ad
- No Field Selected pt. 14:201 credit or ad
- No Field Selected pt. 24:321 credit or ad
- Prevent Carriage Return6:091 credit or ad
- Highlight Record6:361 credit or ad
- Automatic History pt. 15:051 credit or ad
- Automatic History pt. 27:331 credit or ad
- Interaction Between Multiple Triggers4:401 credit or ad
- Revisit Back Button2:211 credit or ad