The Philosophy of FileMaker - Part 1

Master FileMaker Pro with scripting, calculations, and relationships. Learn from expert John Mark Osborne and enhance your skills through practical examples.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is all about diving into FileMaker Pro with expert John Mark Osborne. You’ll learn to script, calculate, and manage relationships while building a handy invoicing system from the ground up. It’s practical, it’s fun, and it’s perfect for grasping those tricky concepts.

Key Points

  • Learn from John Mark Osborne, the author of Scriptology: FileMaker Pro Demystified.
  • Focus on intermediate and advanced techniques in FileMaker Pro.
  • Build an invoicing solution from scratch to apply what you learn.
  • Understand different types of relationships: one-to-many, many-to-one, one-to-one, and many-to-many.
  • Create an Entity-Relationship diagram (ERD) for better visual understanding.

Learning Outcomes

  • Master intermediate scripting techniques in FileMaker Pro.
  • Design a solid multi-user database solution.
  • Understand and create various types of relationships in databases.
  • Build and utilize an Entity-Relationship diagram (ERD).
  • Finish with a fully functional invoicing system.

About This Course

Intermediate FileMaker Pro 15 Scripting, Calculations, Relationships and Reporting

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.

  • Design a multi-user solution

  • Identify and create one-to-many, many-to-one, one-to-one and many-to-many relationships

  • Create an Entity-Relationship diagram (ERD)

Course Curriculum

1 Lectures

Instructor

Profile photo of John Mark Osborne
John Mark Osborne

John Mark Osborne has been working with FileMaker Pro for over 20 years. He earned his FileMaker Pro degree working on the frontlines of Claris technical support. John was the Technical Lead for FileMaker, serving as an escalation path for other technical support representatives and writing a large portion of TechInfo (now called Knowledgebase), their technical information reference. John also...

Review
4.9 course rating
4K ratings
ui-avatar of Hans van derWaal
Hans V. D.
5.0
2 years ago

I am becoming 80 this month. Have wordking experience with computers from the Hollerith machine, IBM 360, IBM370, IBM 1401-mini computers DEC, HP, and IBM36 and then of course the PC starting with the first IBM PC. I have a financial business economics background was controller, business analist for the marketing department, financial director with industrial companies and in the harbour business. Developed a lot of systems as a system analist and project leader. Programmed myself in RPG, Cobol and later Basic, DBase, Foxpro, and MS Access in combination with Visual Basic. In recent years I learned myself by books Ruby and Python. The introduction of how to set up a project and do good preperations by design is from my experience 200% correct. And also very important not yet mentioned in the ontroduction is that after the actual programming has been done you do thorough testing and test every possibility what may go wrong I call that dummy testing. That is very important because you avoid in this way frustations from end users and their cries "it does not work" and by doing so avoid negative sentiment from the start and remember new things are always looked upon with scepcism. The introduction assured me that I have a teacher with a lot of practical experience as what he told match entirely my long experience in the field. I did already some things in filemaker and find it promising as a younger friend with whom I did a lot of complicated projects with in the past already told me. But the philosophy of Filemaker is different from MsAccess and SQL so I though it wise to take a thorough course. I go crisscross through the course and am building a database for a whosale packaging company. If I am stuck somewhere I look in the course for the topic I need so it is more a reference for me then that I am following the course lesson by lesson. But it works!

  • Helpful
  • Not helpful
ui-avatar of Sriram D
Sriram D.
5.0
2 years ago

The teaching was best and in depth of the file maker concept.

  • Helpful
  • Not helpful
ui-avatar of Ilambarithi P
Ilambarithi P.
5.0
2 years ago

I like the way he started from basic and most important things needed

  • Helpful
  • Not helpful
ui-avatar of Emrah Cetinkaya
Emrah C.
5.0
2 years ago

One of the greatest (maybe the best) courses about Filemaker basics. some topics may not be explained enough but you sure will get them when you experience them while creating your own solution.. if you are new to this or you are already in it but want to learn some different techniques I strongly suggest you to take this course.

  • Helpful
  • Not helpful
ui-avatar of Robin Reid
Robin R.
4.0
2 years ago

I'm a little beyond this, since I have a B.S. in Computer Information Systems and was focused on relational databases in college. However, since I am self-taught when it comes to FileMaker specifically, I wanted to review and make sure I've "filled the gaps". Also, a refresher couldn't hurt.

  • Helpful
  • Not helpful
ui-avatar of Ramakrishnan Kalyana Raman
Ramakrishnan K. R.
4.5
2 years ago

great tutorials. watching non-stop very informative.

  • Helpful
  • Not helpful
ui-avatar of Lee McDonald
Lee M.
5.0
2 years ago

Very thorough.

  • Helpful
  • Not helpful
ui-avatar of Rob Vermeulen
Rob V.
5.0
3 years ago

Great course, learning a lot

  • Helpful
  • Not helpful
ui-avatar of Gordon H. Aronson
Gordon H. A.
4.5
4 years ago

lots of new info

  • Helpful
  • Not helpful
ui-avatar of Khanchi .
Khanchi ..
5.0
4 years ago

It’s promising

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses