
FileMaker Pro 11: Intermediate
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.
Course content
Introduction12 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
Interface Design21 lessons
- Recap Previous Course6:281 credit or ad
- Screen Size7:271 credit or ad
- Background pt. 14:401 credit or ad
- Background pt. 25:411 credit or ad
- Tabs/Bars & Buttons pt. 14:461 credit or ad
- Tabs/Bars & Buttons pt. 23:571 credit or ad
- Tabs/Bars & Buttons pt. 34:021 credit or ad
- Field Outlines7:351 credit or ad
- Sub-Areas6:431 credit or ad
- Buttons5:531 credit or ad
- Finishing Touches pt. 13:581 credit or ad
- Finishing Touches pt. 24:501 credit or ad
- Tabbed Buttons pt. 15:051 credit or ad
- Tabbed Buttons pt. 24:461 credit or ad
- Notes Layout pt. 16:011 credit or ad
- Notes Layout pt. 28:291 credit or ad
- List View pt. 15:531 credit or ad
- List View pt. 26:331 credit or ad
- List View pt. 37:071 credit or ad
- Auto-Resize5:201 credit or ad
- Design Considerations4:401 credit or ad
Relationships22 lessons
- Relational Theory5:101 credit or ad
- Data Modeling pt. 16:201 credit or ad
- Data Modeling pt. 27:311 credit or ad
- Entity-Relationship Diagrams (ERD) pt. 14:571 credit or ad
- Entity-Relationship Diagrams (ERD) pt. 23:431 credit or ad
- Invoicing ERD4:131 credit or ad
- Creating a Relationship6:521 credit or ad
- Related Fields7:381 credit or ad
- Populating a Foreign Key pt. 15:461 credit or ad
- Populating a Foreign Key pt. 25:011 credit or ad
- Live Links6:311 credit or ad
- Many-To-Many Relationship pt. 14:281 credit or ad
- Many-To-Many Relationship pt. 27:171 credit or ad
- Creating a Portal8:171 credit or ad
- How the Join Works3:421 credit or ad
- Portal Improvements6:421 credit or ad
- Aggregating Portals5:281 credit or ad
- Two-Way Relationships6:301 credit or ad
- Start & End6:431 credit or ad
- Go to Related Record3:591 credit or ad
- Organizing Layouts8:571 credit or ad
- Completing the Interface7:331 credit or ad
Table Occurrences18 lessons
- What are Table Occurrences?8:091 credit or ad
- Where are Table Occurrences Used?7:311 credit or ad
- Portal Filtering pt. 15:011 credit or ad
- Portal Filtering pt. 24:301 credit or ad
- Filtered Relationships pt. 15:071 credit or ad
- Filtered Relationships pt. 25:221 credit or ad
- Filtered Relationships pt. 36:001 credit or ad
- Portal Filtering Discussion4:581 credit or ad
- Calculated Portals6:081 credit or ad
- Date Range Portals8:151 credit or ad
- Self-Relationships7:131 credit or ad
- Table Occurrence Tricks pt. 16:221 credit or ad
- Table Occurrence Tricks pt. 24:131 credit or ad
- Conditional Value Lists pt. 12:321 credit or ad
- Conditional Value Lists pt. 25:081 credit or ad
- Scripts & Calculations7:161 credit or ad
- Organizing the Graph6:421 credit or ad
- Table Occurrence Groups3:171 credit or ad
Security26 lessons
- Overview pt. 17:041 credit or ad
- Overview pt. 24:381 credit or ad
- Complete Approach6:411 credit or ad
- Accounts pt. 14:291 credit or ad
- Accounts pt. 24:571 credit or ad
- Other Privileges7:081 credit or ad
- Data Access & Design pt. 15:101 credit or ad
- Data Access & Design pt. 23:001 credit or ad
- Record Level Access4:001 credit or ad
- Extended Privileges5:291 credit or ad
- External File Protection5:571 credit or ad
- No Access Layout pt. 13:401 credit or ad
- No Access Layout pt. 25:321 credit or ad
- Bits & Pieces pt. 14:561 credit or ad
- Bits & Pieces pt. 23:051 credit or ad
- Overdue Invoices pt. 17:011 credit or ad
- Overdue Invoices pt. 26:321 credit or ad
- Capturing Errors6:431 credit or ad
- Add Account7:201 credit or ad
- Delete Account7:401 credit or ad
- Multiple Files5:591 credit or ad
- Random Passwords pt. 13:571 credit or ad
- Random Passwords pt. 24:551 credit or ad
- Miscellaneous Features6:561 credit or ad
- Manager Override pt. 15:381 credit or ad
- Manager Override pt. 26:321 credit or ad
Scripting20 lessons
- Send Email pt. 14:161 credit or ad
- Send Email pt. 23:591 credit or ad
- Menu Button pt. 14:511 credit or ad
- Menu Button pt. 25:041 credit or ad
- Script Parameters6:241 credit or ad
- Find Rolodex pt. 16:021 credit or ad
- Find Rolodex pt. 22:361 credit or ad
- Dynamic Messages7:231 credit or ad
- Duplicate Invoices pt. 15:421 credit or ad
- Duplicate Invoices pt. 26:561 credit or ad
- Dynamic Layouts6:501 credit or ad
- Print Invoice Layout pt. 17:061 credit or ad
- Print Invoice Layout pt. 27:341 credit or ad
- Print Invoice Script5:041 credit or ad
- Batch Print Invoices6:411 credit or ad
- Inventory Control Add7:421 credit or ad
- Inventory Control Subtract5:231 credit or ad
- Deleting Portal Rows pt. 15:431 credit or ad
- Deleting Portal Rows pt. 23:581 credit or ad
- Quick Find Script6:231 credit or ad
Calculations17 lessons
- Sales Tax pt. 13:421 credit or ad
- Sales Tax pt. 24:261 credit or ad
- Grand Total5:531 credit or ad
- Basic Phone Filter pt. 17:271 credit or ad
- Basic Phone Filter pt. 24:561 credit or ad
- Phone Number Validation5:181 credit or ad
- Remove Text Formatting6:341 credit or ad
- Overdue Invoice Display5:341 credit or ad
- Parsing Text Basics7:451 credit or ad
- Importing Multiple Records6:221 credit or ad
- Scripts vs. Calculations6:401 credit or ad
- Parsing Text Advanced7:351 credit or ad
- Field Level Tracking6:301 credit or ad
- Field Level Tracking Advanced pt. 14:161 credit or ad
- Field Level Tracking Advanced pt. 24:171 credit or ad
- True Modification Timestamp6:571 credit or ad
- GetNthRecord Tooltip7:331 credit or ad
FileMaker Pro Advanced22 lessons
- Advanced Features pt. 16:441 credit or ad
- Advanced Features pt. 22:221 credit or ad
- Advanced Features pt. 36:351 credit or ad
- Recover pt. 14:511 credit or ad
- Recover pt. 24:081 credit or ad
- Recover pt. 34:141 credit or ad
- Configuring Plug-Ins pt. 15:181 credit or ad
- Configuring Plug-Ins pt. 23:071 credit or ad
- Plug-In Examples pt. 16:471 credit or ad
- Plug-In Examples pt. 22:011 credit or ad
- Plug-In Examples pt. 36:401 credit or ad
- Database Design Report4:061 credit or ad
- Developer Utilities4:541 credit or ad
- File Maintenance4:051 credit or ad
- Debugging Scripts pt. 16:121 credit or ad
- Debugging Scripts pt. 27:101 credit or ad
- Debugging Scripts pt. 31:221 credit or ad
- Custom Functions pt. 15:141 credit or ad
- Custom Functions pt. 23:231 credit or ad
- Recursive Custom Functions6:421 credit or ad
- Custom Menus Layout Driven6:001 credit or ad
- Custom Menus Scripted7:021 credit or ad
Multi-User Solutions15 lessons
- Hosts & Guests pt. 16:231 credit or ad
- Hosts & Guests pt. 21:231 credit or ad
- Sharing a File5:271 credit or ad
- Record Locking Defined5:221 credit or ad
- Global Fields & Script Variables6:161 credit or ad
- Scripting for a Locked Record pt. 16:501 credit or ad
- Scripting for a Locked Record pt. 25:391 credit or ad
- Scripting for Multiple Locked Records pt. 16:551 credit or ad
- Scripting for Multiple Locked Records pt. 27:211 credit or ad
- Marking Records pt. 14:571 credit or ad
- Marking Records pt. 23:541 credit or ad
- Marking Records pt. 36:501 credit or ad
- Saving a Found Set pt. 14:091 credit or ad
- Saving a Found Set pt. 25:531 credit or ad
- Retrieving a Found Set7:151 credit or ad