Skip to content
Write a review
UdemySQLPaid courseIntermediate levelCertificate

Constructing a Complete FileMaker 16 CRM - Part 1 (Udemy.com)

Learn FileMaker 16 Scripting, Calculations, Relationships and Reporting while building a Contact Manager

4.6
133 reviews

Created by: John Mark Osborne

Last updated June 2017

icon
What you will learn

  • 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)
  • Design according to the principals of anchor-buoy relational design
  • Translate business systems from real-life to electronic using data modeling
  • Create portals, filtered portals and filtered relationships
  • Learn how to print properly in a multi-table environment
  • Work with columns, merge fields, labels and a variety of other print mediums
  • Create reports using sub summary parts and summary fields
  • Learn how to script complex automations with decision making intelligence
  • Create adaptive or dynamic scripts
  • Work with modular scripting
  • Capture errors and redirect programming with error analysis
  • Save and restore found sets for a better user experience

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.6 out of 5higher than 69% of them
  • Reviews133#329 of 389 by number of reviews
  • Length9.5 hourslonger than 68% of them
  • Last updatedJune 2017earlier than 84% of them

icon
Course Description

Learn FileMaker 16 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 Contact Manager or CRM 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.
Intermediate Intermediate Level product length iconTime: 9.5h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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 acted as a liaison between the technical support department and the FileMaker development team, reporting bugs, attending product meetings and acting as resource for the development team.

John Mark is best known as the author of the popular FileMaker Pro web site Database Pros. The Database Pros web site has been on the internet for 20 years and gets over 35,000 hits a day by offering free FileMaker Pro tips, tricks and techniques.

John Mark is also well known as the co-author of the wildly popular Scriptology book and CD ROM. John Mark launched a hands-on training class based on his Scriptology book and it has become so popular that it is now taught at MacWorld Exposition in San Francisco and New York. Most recently, John Mark was one of twelve trainers in the United States authorized to teach their new FileMaker Training Series of classes.

John Mark has been a featured speaker at the FileMaker Developer Conference for 15 years. At the 1999 Developer Conference, he was awarded the FileMaker Pro Excellence award for "creation of outstanding te

icon
More courses by John Mark Osborne

$69.99

All courses by John Mark Osborne

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.6

133 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By B.B. Imamura on 1/20/2026

I liked his way of presenting and it is very easy to follow and understand. I really appreciate his contents.

By Dirk Westerhoff on 3/31/2024

Ich bin begeistert! Mehr kann ich zu diesem frühen Zeitpunkt noch nicht dazu sagen, weil dieser Kurs sehr umfangreich ist. John Mark geht auf jeden Punkt bei der Entwicklung einer FileMaker Lösung allgemein ein. Insbesondere der Abschnitt 3 "Firm Foundation" ist für mich sehr hilfreich und empfehlenswert für jeden der FileMaker Lösungen entwickeln will. 01.04.2023 Mir fällt es aufgrund meiner nicht so guten englischen Sprachkenntnisse nicht immer leicht John Mark zu folgen, aber auch das ist ein angenehmer Nebeneffekt, meine Sprachkenntnisse werden hier aufgefrischt :o).

By Thomas Uttendorfer on 3/28/2024

I admit, I can skip all the intro videos, but I feel a sense of completion when I watch them however, I will admit there is a lot of intro on this course. I would rather just start lessons rather than watch the intros, but that’s just my opinion.

By *harriet * on 4/12/2020

Building this database from scratch is the best way for me to learn Filemaker, and I'm so grateful for John Mark Osborne's commitment to this method. He explains the how and why of each step and feature of Filemaker. He is a truly gifted teacher. I am learning a ton.

By Marcos Leite on 1/29/2020

So far it is great. Super professional and does not waste time in teaching using a reference-guide style (which I hate). He builds upon a tutorial and even at the very beginning shows tips and tricks that are really important and useful

By David Coutts on 8/6/2018

As usual JMO has come up with something - from my point of view - amazing (for me anyway) It was very informative , good explanations - his mistakes were left in !!! and explained how to get out of them again ! Plus Point there - Only problem i have , even though my Mother tongue is english (properUK english) JMO could possibly slow down a wee bit !!!!! It is not very nice to hear him speak with a speed of only 50%

By Jon Nordland on 1/14/2018

The course is broken in to 3 parts. When you add them all up, they cost more than the Filemaker software itself! Makes it really bad value, nomather how good the presentation is.

By James Sneddon on 1/1/2018

I.ve watched Marks videos in the past. Maybe FMv7 I like that we have a complete application. Iv'e watched other course that teach you a concept but no practical examples

By Horst Neuschl on 10/8/2017

Das scheint das Beste zu sein, was es hier zum Thema Filemaker gibt. Der Osborne hat wirklich Erfahrung mit dieser Software. Andere mögen zwar preisgünstiger sein, aber der ist halt besser. Das muss jeder selber wissen, ob er beim Geld oder bei der Zeit seine Prioritäten setzt. Mit dem Osborne kommt man jedenfalls sehr schnell dem Ziel näher, die Filemaker Geschichte zu beherrschen, und das auf durchaus professionellen Niveau.

By C Helm on 7/14/2017

Course is comprehensive. Excellent for beginners or for veterans looking to adapt to the latest version of FileMaker.

Showing all 10 reviews on CourseDuck

Read all 133 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

Constructing a Complete FileMaker 16 CRM - Part 1
Visit course on Udemy Write a review
  • Video Duration: icon 9.5h
  • Price: $74.99
  • Provider: icon Udemy
  • Updated: icon June 2017
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com