The Philosophy of FileMaker - Part 1
Learn FileMaker Pro Scripting, Calculations & Relational Design
Learn FileMaker Scripting, Calculations, Relationships and Reporting from the guy who actually wrote the book, Scriptology: FileMaker Pro Demystified. With over two decades of experience teaching FileMaker, John Mark Osborne will help you understand tough FileMaker concepts with ease. Intermediate and advanced FileMaker techniques will be taught throughout the three part tutorial series. In order to better understand every nut and bolt that goes into designing a solution, a single file will be created from scratch. The chosen solution is an invoicing solution for its familiarity to a wide audience and flexibility of applying techniques to other solutions. The completed FileMaker file at each stage is provided to assist with the learning process.
John Mark Osborne
About John Mark Osborne
About the Tutorial Series
Why an Invoicing Solution?
Touring the Completed Solution
FREE PREVIEWWork Files
Planning your Solution
New Empty File
Housekeeping Fields
FREE PREVIEWData Entry Fields
Primary Key
Adding Fields to the Layout
Arranging the Fields
Title and Merge Fields
Shipping Fields
Window Size
FREE PREVIEWNavigation Buttons
Status Toolbar
Button Bar
Tab Control
Choosing a Theme
Autosizing
List View
Navigating between Layouts
Completed Invoicing File
Import Data
Sample Requirements Document
Data Modeling
Relational Theory
Entity-Relationship Diagrams
Creating Tables
Creating Relationships
Anchor Buoy
FREE PREVIEWAnchor Layouts
Anchor Layouts 2
Populating a Foreign Key
Many-To-Many Relationship
Adding Records to the Portal
Finishing the Portal
How the Join Works
Aggregating Portals
Two-Way Relationships
Start and End
Totaling from Customers
Go to Related Record
Completed Invoicing Solution
What are Table Occurrences?
Where are Table Occurrences Used?
Basic Portal Filtering
Global Fields
Portal Filtering with Globals
FREE PREVIEWTotaling Filtered Portals
Totaling with ExecuteSQL
Complicated Filtered Portals
Filtered Portals with Multiple Globals
Updating the SQL
Filtered Relationships
Complex Filtered Relationships
Filtering Discussion
Self-Relationships
Conditional Value Lists
Calculated Value Lists
Conditional Value Lists Revisited
Scripts and Calculations
Organizing the Graph
Completed Invoicing Solution
Printing Philosophy
Customer List
Improved Customer List
Exporting Customers
Labels
Merge Letters
Marbles
Building a Report
FREE PREVIEWSophisticated Reporting
Exporting a Report
Printing an Invoice
Finishing the Invoice
Completed Invoicing Solution
Scripting Defined
Anatomy of the Workspace
The Good, the Bad and the Ugly
Send Email and Open URL
New Invoice from Customers
FREE PREVIEWNew Portal Row
Rolodex Find
Upcoming Birthdays
Duplicating Invoices
Batch Print Invoices
Inventory Control
Inventory Control Scripted
Leveling Once and Returns
Sub-Summaries in Browse
Naming Conventions
Completed Invoicing Solution
Revamped Data Viewer Calculation Dialog
Data Viewer Example File
Layout Objects Window
No Example for Layout Objects Window
Window Cards
Window Cards Example File
Awesome !!!!
Awesome !!!!
Read LessThis course was interesting and easy to follow. Best of all, I knew more when I reached the end of the course than when I started.
This course was interesting and easy to follow. Best of all, I knew more when I reached the end of the course than when I started.
Read LessAt last, a training program that starts with the basics and does not assume any prior knowledge. I have wasted an unbelievable amount of time and money on ...
Read MoreAt last, a training program that starts with the basics and does not assume any prior knowledge. I have wasted an unbelievable amount of time and money on Filemaker training and support in the past. Your Philosophy of Filemaker series is that far ahead of anything else that it should be promoted by Filemaker as the best starting point for any aspirant Filemaker developer. I appreciate: The many basic concepts which are built upon as one goes from subject to subject. Your clear instructions and explanations. The way you have broken the series up into manageable chunks. The fact that you are not trying to impress with your knowledge but continuously bring it back to the delivery of great solutions. I love the way you introduce really important basic concepts as you cover each topic. These are overlooked and ignored in the official Filemaker material. Why are trainers (the others) unable to write or present in understandable language. There is a concept called the "fog index” which if applied to some of the Filemaker books and training notes indicate the material is beyond the scope of P.Hd’s My only regret is that it has taken me so long to find your material. You are indeed not just a Master of Filemaker but a Master trainer. I am having a ball working through each topic!!! I cannot thank you enough for what you have put together!!!
Read LessThe training is very well constructed and allows you step by step to understand filemaker, its subtleties, and to develop your own database yourself.
The training is very well constructed and allows you step by step to understand filemaker, its subtleties, and to develop your own database yourself.
Read LessHave been struggling with learning aspects of Filemaker Pro and purchased many other video lessons. Then found 'The Philosophy of Filemaker' on Youtube and...
Read MoreHave been struggling with learning aspects of Filemaker Pro and purchased many other video lessons. Then found 'The Philosophy of Filemaker' on Youtube and watched one of the lessons, went and purchased Part 1 to Part 4. Spent 1 hour going thru a couple of lessons which related exactly to what I was trying to do . . . and amazing . . resolved. Thank you will enjoy the rest of the videos and recommend this amazing resource and learning . . .well worth the purchase . . . saves lots and lots of time and frustration and I have only just started.
Read LessThere's always more to learn. This course covers stuff I should have known since starting with FM7 and earlier, thank you John Mark.
There's always more to learn. This course covers stuff I should have known since starting with FM7 and earlier, thank you John Mark.
Read LessI cannot put into words that will express the learning excitement that one experiences from these skillfully crafted videos and supportive example files.. I...
Read MoreI cannot put into words that will express the learning excitement that one experiences from these skillfully crafted videos and supportive example files.. I really need to take more time and go through the complete Course again, as it does have sophistication with complete clarity. Thank You, Mr. John Marc Osborne. Bravo!
Read LessJohn is simply the best at explaining the ins & outs of FileMaker. There is a competitor with engineers in multiple cities who has a free template with t...
Read MoreJohn is simply the best at explaining the ins & outs of FileMaker. There is a competitor with engineers in multiple cities who has a free template with training. There are tons of numbered table occurrences, numbered layouts, numbered scripts, etc., etc. John has a much simpler and well reasoned approach. At the same time - you get a deeper understanding of FileMaker. I highly recommend any of his courses.
Read LessThis course is helping me tremendously to improve my FileMaker Pro Skills. John, I have viewed many You tube videos on how to do something in FM. None have...
Read MoreThis course is helping me tremendously to improve my FileMaker Pro Skills. John, I have viewed many You tube videos on how to do something in FM. None have been near as good as your explanations. I am so excited about the improvement I am making. I am learning so much it is hard to remember everything I am seeing. I have looked at many lessons more than once. Thanks for putting this training together.
Read LessThe way you explain things is very good. Been developing for FileMaker since version 5, stopped at version 13. But picking it up again with 16. Only halfwa...
Read MoreThe way you explain things is very good. Been developing for FileMaker since version 5, stopped at version 13. But picking it up again with 16. Only halfway trough part 1 and already learned great tricks :)
Read LessThe must to have in learning FileMaker philosophy developing. Thank You
The must to have in learning FileMaker philosophy developing. Thank You
Read LessThis was the best course I have ever attended.
This was the best course I have ever attended.
Read Less