Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software FileMaker

Learning FileMaker 17 - Complete Course

Build FileMaker Custom Apps, Tune Performance, and share on the Cloud...Like a BOSS
Rating: 4.1 out of 54.1 (157 ratings)
512 students
Created by Richard Carlton
Last updated 3/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn to build and deploy FileMaker 17 solutions
  • Learn to organize and design a database (aka custom application)
  • Learn to create buttons, and customize layouts
  • Learn to build scalable databases (make it go fast!)
  • Learn the basics behind SMTP, and email plugins
  • Learn how to Install and Manage FileMaker Server
  • Learn how to Install and Manage FileMaker Cloud
  • Learn about security and encryption
  • You will learn so much, your head will explode!

Requirements

  • This course assumes the user has FileMaker Pro 17 installed on their computer. Additional free software will be recommended and is optional to download.

Description

Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 28 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions, while keeping an eye on customizing your own copy of a FREE Starter Solution! 

  • Learn basic skills such as adding fields and managing layouts.
  • Learn intermediate skills, like script triggers, relationally connecting tables, and mastering the relationship graph.
  • Learn advanced skills like configuration and security of FileMaker Server.
  • Learn to setup and configure FileMaker Cloud on AWS.
  • Learning about deploying and hosting the database for hundreds of simultaneous users

The work file for this software is a copy of FM Starting Point, which is a completely free and unlocked CRM. This free database works on Macs, Windows, iPads, iPhone and Android devices. We'll teach you how to customize it for your business needs while learning important FileMaker skills.

We spend some time discussing the FileMaker certification test and recommendations related to that.

For maximum awesomeness... this course will reference a number of third party products, a couple of books, etc. I make NO money in these references. During this course, we will also reference the use of FM Starting Point... to use as a free software... to anchor the development of your internal systems. You will be required to input your personal information to get this free software.

Who this course is for:

  • This course is a big course that covers topics for basic, intermediate and advanced skills.
  • No programming knowledge is required.
  • Intermediate users will learn a great deal, moving them into the "Expert" category.
  • Advanced users will benefit from learning techniques that they probably missed because they did not attend the annual FileMaker Developer's conference.
  • People with simple skills, like basic Excel skills will learn a tremendous amount from this course
  • People who want to learn how to manage FileMaker Server
  • People who want to learn how to manage FileMaker Cloud

Course content

26 sections • 336 lectures • 56h 51m total length

  • Preview03:48
  • Preview08:18
  • 0103 - FMSP, Samples, and Work Files
    04:05
  • 0105 - The FileMaker Platform - Summary
    09:13
  • 0107 - Product Positioning
    10:37
  • 0110 - What kind of Solutions can be made with FMSP?
    06:30
  • 0115 - New Features Brain Dump for New and Intermediate Users
    13:30
  • 0125 - Upgrading 12, 13, 14, 15, or 16 Solutions to FM17
    09:54
  • 0127 - FM Pro Vs. Pro Advanced
    03:12

  • 0201 - Quick Overview of FMSP's use in this course.
    02:53
  • 0205 - What's new in FMSP 6?
    04:48
  • 0206 - What's new in FMSP 5?
    07:04
  • 0208 - FMSP Device Support & Layout Organization
    05:07
  • 0210 - Script Numbering and Organization
    03:51
  • 0212 - FMSP Walkthrough - Intro
    09:24
  • 0214 - FMSP Complexity Theory
    06:46
  • 0218 - FMSP Account & Contacts Walkthrough
    17:35
  • 0219 - FMSP Invoice Walkthrough
    08:18
  • 0220 - FMSP Contacts Email Template Walkthrough
    05:06
  • 0231 - FMSP Sales Followups
    14:15
  • 0232 - FMSP Invoice - New Line Items - Advanced
    14:42
  • 0233 - FMSP Estimate to Invoice Transfer Button
    11:37
  • 0234 - FMSP Calculating Margin and Markup in Invoices
    09:34
  • 0236 - FMSP Unlimited Related Digital Document Upgrade
    08:51
  • 0241 - Tab Controls with Calculations
    04:33
  • 0245 - Super New Action Calendar
    04:18
  • 0246 - Calendar Under the Hood
    17:51
  • 0250 - Dashboard Charts Part #1
    11:36
  • 0251 - Dashboard Charts Part #2 - Scripting
    25:32
  • 0252 - Dashboard Charts Part #3 - Performance
    05:13
  • 0255 - Managing Primary Keys - Auto Script in FMSP
    07:05
  • 0260 - Default Tax Rates in FileMaker 16 Invoices - Auto Enter Values
    11:15
  • 0265 - Startup Bug in FMSP - FM 16 Warning... 5.0.1 - 5.0.8
    02:36

  • 0272 - Calendar Under the Hood Part 1 - Old
    09:50
  • 0273 - Calendar Under the Hood Part 2 - Old
    12:58

  • 0301 - Opening Files ... for New Users
    07:21
  • 0304 - What is a Database - Part 1
    06:01
  • 0305 - What is a Database - Part 2
    04:41
  • 0307 - Modes in FileMaker
    05:50
  • 0308 - Browse Mode, and the Delete menu item
    06:29
  • 0309 - Saving Data
    02:12
  • 0310 - Converting from .fp7 to .fmp12 file formats
    10:58
  • 0312 - Converting from .fp5 to .fp7 file formats
    11:36
  • 0313 - How to make a Copy of a FM Database
    05:10
  • 0315 - What is a Relationship (Very Basic Video)
    18:48
  • 0330 - Basics of Sharing a Database
    13:49

  • 0401 - Finding Records - Basics
    05:52
  • 0402 - Finding - Multiple Requests
    11:13
  • 0403 - Finding Ranges of Dates
    05:35
  • 0404 - Finds with Special Operators
    08:50
  • 0405 - Finds and Indexing and Performance, Stored Calcs
    06:26
  • 0406 - Finds Constrain and Extend
    04:36
  • 0407 - Sorting Records
    07:50
  • 0408 - Custom Sort Orders
    07:53

  • 0501 - Layouts - Available tools
    16:42
  • 0502 - Tour of the Inspector Pane - Right Side
    14:55
  • 0503 - Tour of the Object Pane - Left Side
    08:09
  • 0504 - Intro to Adding Fields to Database (Text and Number)
    10:24
  • 0505 - Added Calc fields and Hiding Objects
    11:26
  • 0506 - Creating a Survey, Tab Panels & Value Lists
    13:14
  • 0507 - Value Lists - Under the hood
    09:57
  • 0508 - Hiding Objects & Conditional Formatting
    10:45
  • 0509 - Text Fields with User Specified Formatting
    09:40
  • 0510 - Merge Fields
    04:40
  • 0511 - Stored Vs Unstored Calculations
    12:02
  • 0512 - 3 Types of Buttons and One Glyph - Icon
    09:45
  • 0513 - Button Bar as New Data Input Control Style
    04:25
  • 0514 - Inline Field Labels
    06:41
  • 0515 - Tabs vs. Slide Controls
    06:13
  • 0516 - Popovers and New Window Command
    09:53
  • 0517 - Auto-Enter Options for Fields
    08:05
  • 0519 - Introduction to Single-User vs. Multi-User databases
    08:42
  • 0520 - Record Locking Basics
    05:27
  • 0522 - Global Fields
    10:55
  • 0523 - Tooltips
    07:06
  • 0524 - Object Flags, or Badges
    07:42
  • 0525 - Object Alignment tools
    10:49
  • 0526 - Creating a new iOS Layout from Scratch - Stencils
    07:08
  • 0527 - Field Validation Options
    13:06
  • 0528 - Repeating Fields
    09:42
  • 0530 - Layout Badge Tooltips
    02:44
  • 0539 - Custom Currency in FMSP
    04:14
  • 0540 - Formatting Currency - When it goes into a Text Field
    09:06
  • 0545 - Hamburger Menus
    06:14

  • 0551 - Container Field Introduction
    08:44
  • 0552 - Thumbnailing - Under the Hood
    04:04
  • 0553 - Interactive Containers
    12:02
  • 0556 - Fixing Interactive Containers - Which are not Interactive
    15:42
  • 0560 - Containers in FMSP
    06:50
  • 0580 - When Container Storage goes Bad... Recovery Plan...
    08:50

  • 0601 - Making Layouts load 200% faster in FM 16 - Performance
    07:32
  • 0602 - 200% faster Part 2 - Performance
    10:39
  • 0603 - 200% faster Part 3 - Performance
    03:06
  • 0604 - Grouping with Slide Panels to Hide Objects
    05:55
  • 0605 - Get Object Attribute for Hidden Objects
    03:03
  • 0614 - What is a Virtual List? *** Advanced ***
    14:20
  • 0615 - Hierarchical Portal for Navigation *** Advanced ***
    17:01
  • 0622 - FileMaker 14 SVG Icon Helper Tool
    19:34
  • 0630 - Web Viewers
    07:30

  • 0801 - Calculation Engine & Work Space
    13:31
  • 0802 - Calculation Engine & Work Space Part 2
    05:24
  • 0810 - Parsing Text with Calcs - Part 1
    12:19
  • 0811 - Parsing Text with Calcs - Part 2
    11:44
  • 0812 - Detecting Window Mode and Filter Function
    11:18
  • 0813 - Date Calcs
    05:22
  • 0814 - Detecting Device & Platform Types
    03:34
  • 0820 - Get Functions Walkthrough - Part 1
    10:48
  • 0821 - Get Functions Walkthrough - Part 2
    11:58
  • 0822 - Get Functions Walkthrough - Part 3
    10:34
  • 0823 - Get Functions Walkthrough - Part 4
    10:49
  • 0824 - GetLayoutAttribute
    05:38
  • 0825 - GetContainerAttribute
    05:28
  • 0826 - Get(UUID) and Get(PersistentID)
    08:23
  • 0840 - List Function, Summary List, and GetValue
    08:11
  • 0842 - SortValues and UniqueValues
    01:50
  • 0845 - Get (ScriptName) - Understand Timing Issues...
    09:21

  • 0901 - Scripting
    10:45
  • 0902 - Intro to Script Workspace
    11:00
  • 0903 - Workspace Keyboard Shortcuts
    08:32
  • 0904 - Set fields vs. Copy, Paste
    16:48
  • 0905 - Set fields & Context
    02:40
  • 0906 - Buttons run one Command
    15:15
  • 0907 - Navigation
    03:36
  • 0908 - IF...THEN...decisions
    06:41
  • 0909 - Variables vs. Globals
    06:15
  • 0910 - Performing Finds
    09:15
  • 0911 - Basic Error Capture
    10:37
  • 0912 - Calling Subscripts - Script Parameters
    10:38
  • 0913 - Advanced Script Parameters & Script Results
    05:13
  • 0914 - Looping Scripts
    03:22
  • 0917 - Preserving User Context when running a Script
    07:34
  • 0918 - New Window - Script Step
    14:15
  • 0920 - Script Debugger - Part 1
    21:06
  • 0921 - Script Debugger - Part 2
    03:27
  • 0924 - Data Viewer
    13:44
  • 0932 - UI Indicators for Database Activity
    11:06
  • 0943 - Perform Script on Server - PSOS
    20:21
  • 0945 - PSOS in FMSP
    07:24
  • 0946 - Testing for PSOS Availability
    12:54
  • 0948 - Case Statement
    02:20
  • 0950 - Deduplicating Records, the Plan
    08:08
  • 0951 - Replace Command - A Tiger Loose at the Zoo
    08:15
  • 0953 - Landmines in FileMaker
    10:01
  • 0955 - Testing to Make Sure Your Script has Access to a Record
    07:52
  • 0957 - Testing to See if a Field or variable contains ONLY a number / Trim Funct
    05:28
  • 0965 - One Use Loop Technique
    06:09
  • 0968 - Go To Object
    12:29
  • 0970 - Go to Related Record - GTRR
    24:18

Instructor

Richard Carlton
CEO & Senior Engineer
Richard Carlton
  • 4.3 Instructor Rating
  • 966 Reviews
  • 12,948 Students
  • 16 Courses

Richard Carlton
CEO & Senior Engineer
Richard Carlton Consulting Inc
LearningFileMaker
Senior Trainer and Platform Advocate

Richard Carlton is the CEO, and a Senior Engineer at Richard Carlton Consulting Inc. and its subsidiaries.

Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard is a frequent speaker at the FileMaker Developers Conference on a variety of topics involving mobile application development, and client server integration.

Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

Richard has previously worked with VTC as a Video Training Author, and then later, started a new video publishing company, dedicated to the needs of the FileMaker community. LearningFileMaker is a publisher of FileMaker training videos, and numerous printed book available on Amazon.

Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to enhanced business development.

RCC and LearningFileMaker are headquartered in Santa Clara, CA.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.