Learning FileMaker Pro 15 - Volume 2
4.8 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
137 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning FileMaker Pro 15 - Volume 2 to your Wishlist.

Add to Wishlist

Learning FileMaker Pro 15 - Volume 2

Complete Course for Mastering FileMaker Pro
4.8 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
137 students enrolled
Created by Richard Carlton
Last updated 12/2016
English
Price: $35
30-Day Money-Back Guarantee
Includes:
  • 25 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn to organize and design a database
  • Learn to to build and deploy FileMaker 15 solutions
  • Learn to enable security and passwords as well as encryption
  • Learn beginning, Intermediate, and advanced FileMaker skills
  • Learn about performance tuning... so a database can be shared with a dozen people or a hundred people.
  • Learn How to write scripts ranging in complexity easy to hard
View Curriculum
Requirements
  • This course assumes the user has FileMaker Pro 15 installed on their computer. Additional free software will be recommended and is optional to download.
Description

PART II

Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 25 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 intermediate skills, like script triggers, relationally connecting tables, and mastering the relationship graph.
  • Learning to write scripts... that can do anything... like automatically create Reports, and then send them out via email.
  • Learn advanced skills like configuration and security of FileMaker Server.
  • 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.

This course is a good step toward getting your FileMaker Certification.

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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
143 Lectures
25:10:04
+
0900 - Writing Scripts
37 Lectures 05:23:54

Introduction and Context...

Writing Code and understanding where the FileMaker Client "is at" the moment the code is executing ... is called context.  What layout and record is the FileMaker Client viewing?  What is the found set and sort order?   You will need to keep these items in mind when writing scripts.

Preview 10:11

Basic intro to this new Development Environment

This was introduced in 14, with some improvements in 15... and it's heavily loaded with Keyboard shortcuts.

* New Feature for checking for "Obvious Problem" in red.   Does not find subtle errors in scripts.

* Show Compatibly .., will show which FileMaker clients... the script steps will work with.

Preview 12:35

If you like a mouse... then skip this video

* Basic Keyboard shortcuts

* Comment your code!!  This is a sign of a good developer. Use the hash tag to start a comment.

* Inline scripts coding can be done for SOME script steps.   IF...THEN ...statements support inline editting.

Preview 11:08

Your first script...

We will be covering script creation, adding comments to scripts, and the difference between Set Field and Copy/Paste.  We also build our first button and use it to activate the script.   We did skip over the Table Occurrence conversation because we deal with that in our Relationship videos.  So if you want to know about TOs... then please skip to that video.

0904 - Set fields vs. Copy, Paste
16:48

Set Field works against fields not visible on layout....

Set Field works against fields not visible on layout... as long as they do exist on the table for the active layout.   Copy/Paste/Cut will only work on fields if they are visible on the current layout.

0905 - Set fields & Context
02:40

And detailed discussion of FMSP Navigational Scripts & Modifier Keys

We talk about one button scripts, which are almost worthless.   We will also cover how the navigational scripts in FMSP can pop-up a new window if the user holds down a modifier key.   Super cool!!!   We use this capability all the time when juggling a busy schedule!   The modifier key function is omitted from GO and WebDirect for various reasons.  The reasons range from "it just won't work" to.... both of these technologies use a "Single Document Interface"... unlike FM Pro. Popping Multiple Windows.

0906 - Buttons run one Command
08:40

Navigating between records too...

Resizing a window to refit the content size.


0907 - Navigation
03:34

Making Logical Decisions in FileMaker

If Then... go together everywhere... but you can also use ELSE then... and ELSE IF

0908 - IF...THEN...decisions
06:41

Great tools for capturing and holding bits of data...

Global fields go way back... before variables were added to the FileMaker platform.  Mastering both is important for good scripting skills.

To see global or local variables that are defined and in use while a script is running... pop open the Data Viewer!

Path names for files must use variables.

0909 - Variables vs. Globals
06:15

There is more than one way to script a Find...

You can script your finds using several different techniques.  One is somewhat succinct ... and the other is somewhat more verbose.

0910 - Performing Finds
09:17

Learn the Basic of Trapping for finds.

Discussion of how Error Capture in FileMaker is NOT historical in nature and only tracks the LAST error generated by a script step.   Finds, GTRR (Go To Related Records), and other similar commands that are prone to failure MUST be trapped.    Also, Finds can be trapped by using more than one technique.

0911 - Basic Error Capture
10:37

Learning to "call" or activate scripts... i.e. pieces of "code" to save time...

You can call a common process... that repeats a behavior many times.   Write the code once in a script... then reference on other scripts as necessary.

Defining terms: Script, Subscript, Script Parameter

Demo: We take apart the Sent Email Script for FMSP from the contact module, script #0783

0912 - Calling Subscripts - Script Parameters
09:10

Passing data back and forth between scripts...buttons to scripts too...

Advanced Info:   Passing values from multiple fields can be concatenated, and loaded into a script parameter or script result.   Use the List function to make things much more simple.

GetValue Function is used to extract data.

0913 - Advanced Script Parameters & Script Results
04:19

Loop and EndLoop are Great Tools to add to your skill set...

Looping a script is a great way to process a group of records... or to perform some sort of maintenance on the records, etc.   We have been using some sort of looping capabilities since FileMaker Pro 2... in 1990.   A million uses.

0914 - Looping Scripts
03:27

New Windows Script Step is really helpful!

Popping a new Window and working in that can preserve the users context.   Popping the new with -2000 points off to the left side of the screen also hides this window... so users don't see a bunch of flashing.   A diagnostic check... in the script for the get modifier key can help you decide to make the window visible for running it through the script debugger

0917 - Preserving User Context when running a Script
07:34

Secret Agent Tracking Device for Your Scripts in FileMaker

The Script debugger is probably the biggest justification for buying FileMaker Pro Advanced.   Script debugger doesn't come with "regular FileMaker Pro."  This tool is a like a leash for your dog... or 3 year old. child.   Whatever works for you.  Its great!

Get demo of firing a sequence of script triggers in scripts.   Totally invisible.

0920a - Script Debugger - Part 1
09:32

Secret Agent Tracking Device for Your Scripts in FileMaker

The Script debugger is probably the biggest justification for buying FileMaker Pro Advanced.   Script debugger doesn't come with "regular FileMaker Pro."  This tool is a like a leash for your dog... or 3 year old. child.   Whatever works for you.  Its great!

Get demo of firing a sequence of script triggers in scripts.   Totally invisible.

0920b - Script Debugger - Part 1
11:42

The less used features...

Step Out, Triggers OFF/ON, Break Points, etc

0921 - Script Debugger - Part 2
03:27

How to spy on fields and variables... in realtime...

Learn how the variables and fields can be reviewed in real time while a script executes.   Current tab will show the fields and variable being acted upon by the current script.   The dots to the left tell you which field or variable is being affected by the current script step.

0924 - Data Viewer
13:50

Viewer Requested "How to Video", review video 0528 first

Want to hijack some container fields... with open, insert, and delete buttons, and copy them to another screen or layout?   Well a viewer had problems with this... so we made this video to walk you through the steps.  We talk about Slide Panels, Tab Panels, Container fields, Script Parameters, Variables, Repeating fields... aka Arrays.

0930 - HiJacking Containers in FM Starting Point
17:19

When your documents become unlinked or missing.

Container problems ... what generally happens and how we at RCC solve them.

0931 - When Container Storage goes Bad... Recovery Plan...
08:54

Notify your customers about things in the db...

Adding a check mark graphic to a button can save you alot of time and stress.

0932 - UI Indicators for Database Activity
11:08

One Big Cohesive Plan

A quick overview of the best videos to watch and in what order to tackle your database performance issue.

0940- Database Performance Optimization Overview
05:55

How many users can your database service?

Making a database that can work with 100 simultaneous users is not something that can be easily done by novice developers, but we have given you a good start in the right direction with FM Starting Point 4.6 This video provides a bit more direction on the topic.

0941- Making Scalable Databases
11:46

Unload your client's burden...

Learn how a new script step can run your process-heavy scripts on the server... allowing your client to run more efficiently.

*** IMPORTANT *** If the process that runs the scripts crashes or quits running on FileMaker Server.... you can restart the process with the command line:

fmsadmin restart fmse

*No Animals were mistreated while filming this video

0943a - Perform Script on Server - PSOS
10:13

Unload your client's burden...

Learn how a new script step can run your process-heavy scripts on the server... allowing your client to run more efficiently.

*** IMPORTANT *** If the process that runs the scripts crashes or quits running on FileMaker Server.... you can restart the process with the command line:

fmsadmin restart fmse

*No Animals were mistreated while filming this video

0943b - Perform Script on Server - PSOS
10:17

Important Things with PSOS...

SASE and PSOS tend to act like Clients even though they are not.  There are some important things you need to know about how they perform.

0945 - PSOS in FMSP
07:23

PSOS, are you there?

Just because your using FileMaker Server 14... doesn't mean you have access to PSOS.   We should actually test to make sure its available... especially if we are calling it "blind". 

To Reset PSOS the Server enter the FileMaker Server Admin Command Line: fmsadmin restart fmse

0946 - Testing for PSOS Availability
12:40

Let Server help your Client...

Server Assisted Script Execution is very powerful.  The function is very similar to PSOS with one major difference...

0947 - SASE
10:14

Can be easier to understand than "If, Then"

Power users and developers use Case statements regularly.  They have the same functionality as an If statement, but are cleaner and more concise.

0948 - Case Statement
02:20

Purge your records of duplicates

Take a look at how RCC has wired in a way to eliminate duplicate records by some smart scripting.

0950 - Deduplicating Records, the Plan
08:09

Have you watch relationship videos yet???

This command can be activated manually or via a script step.  It is exceptionally powerful... and also dangerous.   Kinda like a tiger in the zoo.  If you don't know what you're doing, you're going to accidentally turn it loose... and it's going to start eating people.

0951 - Replace Command - A Tiger Loose at the Zoo
08:15

Have you watch relationship videos yet???

This command can be activated manually or via a script step.  It is exceptionally powerful... and also dangerous.   It is different than Relookup, but also is pretty awesome if used properly.  Used improperly... well, data is going to die somewhere.

Roadrunner / Coyote Sales Demo.

0952 - Relookup Command - Updating One Time Relationships
08:21

Beware of accidental script trigger detonation...

Unplanned detonations in the script can cause problems in the future... you'll defintly not want to deal with anything spawned by the script splosion.

0953 - Landmines in FileMaker
10:03

Error Capture - Lock Sync Error Testing ...

 Using error capture ... AKA testing your script checking to make sure your code works under any situation

0955 - Testing to Make Sure Your Script has Access to a Record
07:52

Simple and Clever use of the Filter and Trim Function

You can use this technique to specifically test if the contents of a field are... what you expect... a number, a block of text, etc.   Very Cool!  Also, a quick explanation of the Trim function.

0957 - Testing to See if a Field or variable contains ONLY a number / Trim Funct
05:28

Check out this handy script technique involving Loops.

FileMaker’s version of “Try and Capture” is a one use loop technique.

0965 - One Use Loop Technique
06:10
+
1000 - Calculations
17 Lectures 02:23:14

Calc Engine ... Super Powerful

The calculation engine in FileMaker is super powerful, and it is available in a ton of places.  Time for an overview.  We will be covering concatenating text; If then functions; IsEmpty functions; IsFull Functions (which don't exist); and Get(Thumbnail) function.  FileMaker Experts generally never memorize all the functions because there are too many.  The best strategy is to be familiar with the available capabilities, and then hunt for what you need.  Also discussed:creation of Calculated container fields.

Preview 13:32

Calc Engine... the continuation 

Calc Engine pt.2 and how its UI can be more easily worked with.

1002 - Calculation Engine & New Work Space Part 2
05:27

Extracting the text we want... from a Block

* FileMaker has... Character based functions

* FileMaker has... Word based functions

* FileMaker has... Value list Management

* Middle (text), PatternCounts, and Position Functions

Isolating an Email address

* How To extract an email out of a block of text.

* Sample File here is not available as part of this training

* We use the Data Viewer as part of FileMaker Pro Advanced

* PatternCount allows you to search for a single character... or a "string" of characters... in a block of text.

* Middle, allows you to extract one or more characters   from anywhere in a block of text.

* Calculate the length of  string of characters.

1010 - Parsing Text with Calcs - Part 1
12:19

Word functions and Value List Functions.

Learning to clean up blocks of text, and parse into individual fields. This video focuses on entire lines in a Value List or evaluating entire words.

* ValueCount

* RightValues

* LeftValue

* GetValue

Save copies of the scripts in versions... in case you need to go back and check some previous calc.  When you totally done... then delete the unneeded scripts.

1011 - Parsing Text with Calcs - Part 2
11:45

Learn to detect When the user is in Find Mode...or Browse...

Creating a reliable search method... when dealing with phone number fields.   Get(windowmode) and Filter functions are useful or improving the User Interface for people who do not understand how things should look.

1012 - Detecting Window Mode and Filter Function
11:29

Lots of Cool Date Related Function to get your Job Done...

Adding numbers to a date... adds days...

1013 - Date Calcs
05:23

Learn to detect what type of device a user is running

Two different get functions ... now complement each other to really identify the type of client and type of device being used by the users.  Plus we have a good script sample, and instructions on where to find it.   FMSP uses some of this to send the users to the correct set of layouts when it starts up.

1014 - Detecting Device & Platform Types
03:39

A high speed walk through....

Get Functions 101

1020 - Get Functions Walkthrough - Part 1
09:03

A high speed walk through....

Get Functions pt.2

1021 - Get Functions Walkthrough - Part 2
07:28

A high speed walk through....

Get Functions pt.3

1022 - Get Functions Walkthrough - Part 3
03:50

A high speed walk through....Specific for 14

Get Functions wrap-up

1023 - Get Functions Walkthrough - Part 4
05:26

Universal tool for returning data on layout objects...

Will return info on all sorts of objects, but it is more useful on certain types of objects.   Very handy for Web Viewers.  Very handy for managing Slide or Tab panels.

1024 - GetLayoutAttribute
05:38

Universal tool for returning data on container fields...

Will return all kinds of info from container fields, related to images, photos, PDFs, barcodes, and signatures.  It is especially useful in finding out whether a signature is a valid signature or not.

1025 - GetContainerAttribute
05:28

Handy tools for generating unique serials...

These two Get functions can help you uniquely determine users and machines that are running your database.

http://filemakerstandards.org/display/bp/Key+values

1026 - Get(UUID) and Get(PersistentID)
08:23

Pretty Awesome stuff... and we use it everywhere

Practical discussion of generating an Email from Invoices with line items purchased in text body of email, using List function.

1040 - List Function, Summary List, and GetValue
08:11

Double Click Sample File by Excelisys

Andy Persons, from Excelisys, has created an amazing free tool that helps you.

Sample file is in the Training Work Files.

1041 - Get (ScriptName) - Understand Timing Issues...
09:21

XML Formatting and working around it

When A block of XML text is created its very difficult to understand for basic users/developers this video is all about.

1045 - Parsing XML
16:52
+
1100 - Relationships
17 Lectures 02:48:34

Relationships and keyfields

Relationships should help you model... the "real world" into a database.  Relationships are not abstract.  The same relationships between parts of your business... may need to be defined and set up in your FileMaker database.  Use serial numbers in primary key fields.  Definitely don't use fields that can change, or that might be unique.  Names are not unique.

Preview 09:38

and more on Keyfields for Beginners

TOs are a MAJOR part of the FileMaker relational model.  TOs are not the same as a table... AKA "Base Table".  You can connect two "Key" fields together.  A Primary key on the parent side... will typically auto populate with a serial number.   A foreign key on the child side, will typically NOT auto populate with a serial number.

1102 - Table Occurrences Basics
12:04

What the heck is this... and what are the elements.

What is the difference between a FileMaker Relational Diagram and conventional Database Entity Relationship Diagrams.   Remember,  you can put many TOs from the same Base Table on a Relational Diagram.  It is all about your little Lego® Guy.   No circular references.

1103 - Relationship Graph & ERDs
12:35

One to many Relationships

Without a portal... a relationship will only show you the first created related record... (assuming no sort setup in the relationship).

1104 - What is a Portal... and a One to Many Relationship?
06:54

The "AND" Relationship ... Advanced Kung-Fu

Multiple fields can be used together to create more advanced relationships... where both fields have to match before the relationship works.

1105 - Multi-Predicate Relationships
08:54

The "OR" Relationship ... Advanced Kung-Fu

Use value lists with a text field on one side to establish a multi-key.   We also show the inherent benefit of using a date "type" field... and the automatic intelligence of this field.

1106 - Multi-Key Relationships
11:15

Connecting A Relationship

Checking this box in the relational dialog allows FileMaker to create a related record automatically by... (1) Create New Record, and then (2) auto-populate a foreign key with the value from the Primary Key.  Cool Stuff!

1107 - Cascading Adds
07:38

Don't auto-destruct your starship... unless you have a really good reason

Cascading Deletes can be useful for making sure that children records get deleted when the parent records are removed from a database.   But deleting is a dangerous tool... and about the time you have everything dialed in... you going to get a complaint from someone that records are randomly disappearing.   Then you have to go through and trouble shoot all your "delete" scripts and relationships.

1108 - Cascading Deletes
06:24

Filter & Sort are just a couple of the options that await you.

These additional portal dialog options are cool but they come at a price.  Sorting can be a performance problem for users who access a solution across the Wide-Area-Network... AKA WAN... AKA Internet.   Filter is a bit funky, because it won't generally update itself... unless you beat the portal with a stick.   We'll show you how to do that.

1111 - Portal Dialog Options
16:59

You can use Sum Calc function to Get Portal Totals

OK there are several "Gotchas" with getting summary totals of Dollars amounts on a Portal. 

Gotcha #1:  Sum Calc won't reflect a "filtered" portal found set if you use the Filter option in the portal dialog.  The Sum calc uses the portal relationship

Gotcha #2:  Sum Calcs can be slow... for WAN connections... i.e. remote users.  That's why we do not use them in FMSP.

1112 - Portal Summary Sum Totals
07:27

Learning to Filter Records Dynamically with a Relationship...

We're showing a real world example of filtering with both single criteria with a radio button and multi criteria with a check box.  This technique uses a relationship... and NOT the Filter check box option in the portal dialog.

1114 - Filtering Portals - Radio Buttons
07:41

Search as your type... portal filtering... 

This technique requires a practical application of script triggers to actually force a refresh of the portal.   Without the refresh... it will only work when you click out of the search field... which makes the solution goofy and non-usable.

The Portal Filtering Option REQUIRES a COMMIT before the portal will update.

1115 - Filtering Portals - Dynamic Search - Script Trigger
08:11

Use these for Preserving "Historically important" data.

The lookup is old... and still a super critical feature of FileMaker.  Use Lookups to grab data through a relationship... and effectively copy and paste it from one location to another.   Use Lookups to grab data that must be *** Historically preserved ***.  Look ups have been frequently used in the Past with Repeating Fields... see video #0527

1120 - Lookup Values
13:24

How to structure a relational graph...

This video covers setting up a relational graph... for beginners and intermediate users.  This proven design methodology has been around for a while.  It keeps things simple, understandable ... and easy to reverse engineer. 

1130 - Anchor Buoy Design Methodology Part 1
09:37

Naming Conventions for the Relational Graph

Half the job of structuring the relational diagram is some sort of useful naming conventions.  Seems like everyone has their own naming convention.  Here is one that we used with FM Starting Point that works fairly well. 

1131 - Anchor Buoy Design Methodology Part 2
07:44

1132 - Many to Many Relationships
14:50

1135 - Preference Table in your Solution
07:19
+
1200 - Security
16 Lectures 03:26:11

Security Features Summary

FM Starting Point ships with no security enabled, but once you're getting comfortable... it's time to "raise shields" and protect your database.    New FileMaker files have a basic "admin" account setup with no password.  Also, FileMaker can be set to auto-login with a specific username and password.  FM Starting Point is setup this way, just like a new FileMaker file.  Admin/{no password}

1201 - Security in FileMaker Overview
05:33

Username and passwords... and privileges

FileMaker defaults new files... to "admin/{no password}.   Auto enter options are set for this for new files... so new users can get into a file and make customizations... without understanding that they are already logged in as an "admin."   Once you change the admin account to have a password, the auto enter won't work anymore... or you can update it.   But having Admin auto login... is a huge security breach.   So keep all this in mind.

1202 - Accounts and Privileges
12:31

Extending Access to other Technologies

Extended Privileges allow for access control to WebDirect, PHP, ODBC, XML, etc.  It also allows the users to set up the time delay before a inactive iPhone or iPad user has to log back in.

1203 - Extended Privledges...the Basics
08:50

Attach a pit bull to your database....

If you could lock your database in steel safe and then surround with it hungry pit bull dogs... that would basically be EAR.   No one will be able to mess with it.

1204 - Encryption at Rest (EAR)
09:20

Unload your client's burden...

Learn how a new script step can run your process-heavy scripts on the server... allowing your client to run more efficiently.

*** IMPORTANT *** If the process that runs the scripts crashes or quits running on FileMaker Server.... you can restart the process with the command line:

fmsadmin restart fmse

*No Animals were mistreated while filming this video

1205a - Point to Point Encryption - SSL Certificates
17:16

Unload your client's burden...

Learn how a new script step can run your process-heavy scripts on the server... allowing your client to run more efficiently.

*** IMPORTANT *** If the process that runs the scripts crashes or quits running on FileMaker Server.... you can restart the process with the command line:

fmsadmin restart fmse

*No Animals were mistreated while filming this video

1205b - Point to Point Encryption - SSL Certificates
17:44

Unload your client's burden...

Learn how a new script step can run your process-heavy scripts on the server... allowing your client to run more efficiently.

*** IMPORTANT *** If the process that runs the scripts crashes or quits running on FileMaker Server.... you can restart the process with the command line:

fmsadmin restart fmse

*No Animals were mistreated while filming this video

1205c - Point to Point Encryption - SSL Certificates
17:45

Logging everyone's Actions...

Audit trails are NOT built into FileMaker as a default feature... so you need to build your own.   Part 1 of 2.

1207 - Audit Trails - Part 1 - Overview
12:39

Taking Part Ultra Log V1.0

Lets learn the basics of Audit Logs.... from this great free demo from KnightWing Enterprises.

1208 - Audit Trails - Part 2 - Technical
11:58

Bolting in Audit Trail in FMSP.

We decided to bolt in the Ultra Log 1.0 into FMSP... but we made some design changes so audit logs would be updated immediately with a script trigger.

1209 - Audit Trails - Audits in FMSP Part 1
09:26

Audit Trail in FMSP... with PSOS

We made some performance enhancements by leveraging Server performed scripts... or PSOS.   These improvements are available starting in FMSP release 4.2v3.

1210 - Audit Trails - Audits in FMSP Part 2
18:10

Learn about Summary Fields with List Option Enabled

Add some additional functionality to make your audit trails tighter and HIPAA compliant.

Details of the Summary Function using the List options set to the Individual option... which is AWESOME!!!!

1211 - Audit Trails - Logging Records viewed - HIPAA
19:42

Quick and Dirty... it can also be easily hacked...

Well... my daughter... who doesn't do much with FileMaker... can get around most basic security that a new user might try to build themselves.  Imagine if you have a real hacker type trying to get inside your database.

1213 - Security through Obscurity
08:07

Restrict access between groups of staff

Get(RecordAccess) You will need to restrict to just to a layout... and then test to see if you can access it.  0 = No Access, 1 = Read Only, and 2 = Read/Write

1214 - Record Level Security
13:43

2 Techniques covered here...one with External Priv

Get(LayoutAccess).  You will need to restrict to just to a layout... and then test to see if you can access it.  0 = No Access, 1 = Read Only, and 2 = Read/Write

Pattern count function is used too.

Get (AccountExtendedPrivileges)

Also notice that Admin accounts do NOT have access to everything... unless you set it up that way.

1215 - Layout and Process Access Controls - Restricting Staff
15:20

Putting on your FileMaker White Hat

Finding the in's and outs for A FileMaker file.  How to protect your important info and everything important related to your customers or employees.

1216 - Hacking a FileMaker File... and Protecting It
08:07
+
1300 - FileMaker Server
10 Lectures 02:31:40

Don't Cheap Out

Small businesses like to find ways to save money. Cheaping out, and not using FileMaker Server is a bad idea, and you will pay dearly for it later.   You have been warned.

1301 - Deployment & Sharing
16:18

Take a stroll through the Admin Console

Why are we training on FMS?  Well to load databases on it to share with our teams.  But also... to practice for when things go bad.

1302 - FMS Admin Walkthrough
18:49

You need to setup your backups... or you will pay!

3 Types of Backups... Bootable, Scheduled, and Offsite.  You need them all.

(MAC Users) Sync2Folders... is the old shareware version.  They now have a updated professional app... called "Sync Folders Pro" on the Apple App Store for $7.99... which works pretty well.   This App will not Zip the files during Sync.

(MAC Users) "Get Back 2" is a similar App... but compresses the backup during the transfer.   Very clever. 

1303 - Scheduling Backups
14:52

AKA Incremental Backups... Super fast!!!

These backups are highly automated and result in FileMaker only saving "changes" to databases during a backup... and not entire copies of a database.   So if a 4 gig database has 20K of new data... a progressive backups will only write 20K of data instead of the whole 4 gigs... so its super fast!!!

1304 - Progressive Backups
04:55

When FMS Blows Chunks, Also Discuss Hard Linking

There is a specific procedure for restoring from a crash on FileMaker Server.  You may want to create your own variation of this procedure for your organization... but keep your eye on the fundamentals.  Always restore from the last good backup.  DO NOT USE crashed databases.

We discuss Hard Links used during backups.

1305 - Restoring from a Crash
18:49

Proper Cache Settings, Loafing versus Choking...

This is a crazy good video.   Not a lot of explosions...

1306a - Server Performance Improvements 14 - Nick Lightbody
17:31

Proper Cache Settings, Loafing versus Choking...

This is a crazy good video.   Not a lot of explosions...

1306b - Server Performance Improvements 14 - Nick Lightbody
17:17

Proper Cache Settings, Loafing versus Choking...

This is a crazy good video.   Not a lot of explosions...

1306c - Server Performance Improvements 14 - Nick Lightbody
10:54

8% faster than 14... and much better recovery from overload...

* Testing FileMaker Server 15 using a standardized benchmarking tool

* Great Server comparison tool... uses PSOS robots to test server.

* SSD Hard Drives work MUCH better than Hybrid or regular spinning drives.

1307a - Server Performance Improvements 15 - Nick Lightbody
15:35

8% faster than 14... and much better recovery from overload...

* Testing FileMaker Server 15 using a standardized benchmarking tool

* Great Server comparison tool... uses PSOS robots to test server.

* SSD Hard Drives work MUCH better than Hybrid or regular spinning drives.

1307b - Server Performance Improvements 15 - Nick Lightbody
16:40
+
1400 - Printing & Report Creation
11 Lectures 01:55:22

Introduction to Sub Summaries and Planning

Planning... what does a customer want on a report?   How is a report displayed?  Printed?  PDF?  Onscreen?  How is the report activated... via a button, or automatic?   Think about using different layouts for reports... so the layout can be tuned to the printer, etc.

1401 - Printing and PDF Generation
13:49

Free flowing data entry does make for good reports

Make sure that as users input data into fields, that you limit their options based upon your reports needs.  Text fields with unlimited data entry are very difficult to report on.

1402 - Structuring your data so it is reportable
04:44

Right-Clicking on columns gives you options

Table View is not supporting on Web Direct.  Navigational Parts.

Limited version of Table View is supported on FileMaker Go.   We discuss maintenance layouts in FMSP. 

1403 - List View for Ad-Hoc Reporting
04:22

Different parts of a layout behave differently...

Header, body, footer, subsummary, etc.

Headers and Footers are on the top and bottom of every page or screen.  Good for interface control.

Grand Leading Header or Grand Trailing Footer will be displayed ONCE.   Grand Leading Header at the TOP ... is good for information or instructions...on the very first page.  Grand Trailing Footer is at the VERY Bottom of the List and is good for totals on the last page.

1404 - Layout Parts on List View - for Beginners
09:56

FileMaker Assistant for Building a Report

The Report wizard is your go-to tool for generating customizable reports for your DB

1405 - FileMaker Report Wizard - Very Cool
10:32

3 Ways to do this... Scanning might be useful

Discusses scanning documents, rebuilding documents, and layering of layout objects.

1406 - Printing & Reporting on Government Forms
07:16

The Magic of organizing list View

Subsummaries are just another slightly more advanced way of organizing your the way you view your FileMaker DB

1407 - Subsummaries in Detail
11:38

Built in Charting will get you charting Plugin when try to create finely tuned charts.

You need to consider Google Chart, Fusions Charts, or a 3rd party charting Plugin when try to create finely tuned charts... or when trying to pack in tightly spaced dashboard charts.   Also keep in mind there is ZERO support for a progress bar, so go and watch our "Progress Bar" video... to make sure you have the gap covered in your skill set.

1420 - State of Charting in FileMaker
13:12

Warning... Colorful Language... So watch out...

2 Ways to create a FileMaker Chart Objects... and the data has to be one of 3 different methods.  We do cover this in this video, but we probably need to shoot some additional demo videos.

1421 - Built-in Charting Overview
19:45

Warning... Colorful Language... So watch out...

2 Ways to create a FileMaker Chart Objects... and the data has to be one of 3 different methods.  We do cover this in this video, but we probably need to shoot some additional demo videos.

1422 - Google Charts
12:28

Inside the Event Management Starter Solution...

The Event Management Starter Solution is a great demonstration of how to append multiple pages to a single PDF.

1425 - MultiPage Append to PDF
07:40
+
1600 - WebDirect
1 Lecture 28:24

Overview of the Revamped WebDirect - rebuilt in 14

Off the hook.... and totally awesome.  FileMaker says that this is 25% faster than 13, and is not certified on Android phones.    I consider this grossly inaccurate.  This video easily shows WebDirect 14 is 100% faster performance (twice as fast) as WebDirect 13.   Also... while FMI has not "certified" WebDirect for Droid Phones... that's just window dressing.

Might just want to ignore their official comments and listen to your old coach here.  WebDirect 2.0 rocks.   The previous technology sucked.

1601 - Overview WebDirect - Android Client for FileMaker
28:24
+
1700 - MISC
8 Lectures 02:11:40
1701 - Performance Improvements in 14 - Advanced
09:00

1702 - FileMaker Server 14 Performance Tuning with Nick Lightbody
54:28

1704 - 3 Areas of Performance Improvement in Pro 15
10:17

Down and Dirty

What it takes to strap everything to your Asset database to get the most out of it.

1708 - How to make an Asset Database in 5 Minutes
08:11

Duplicating Estimates to make a PO (Purchase Orders) #1

* We use the term "module"... but it is NOT a technical term.

* We are taking the Layout for Estimates and Duplicate it... with all the scheme under neither it...and turn it into a Purchase Order.

* Understand we are doing this in the "correct order"... but it backwards from what a typical new new will do.

* Step #1... Understand your Business Needs

* Step #2... Confirm we are duplicating ... and not simply relabeling the Estimates Modules. 

* Step #3... Duplicate Tables, and rename

* Step #4... Rename Fields... that are obviously wrong.

1720 - Duplicate Module in FMSP Part 1
07:21

Duplicating Estimates to make a PO (Purchase Orders) #2

* Step #4... Rename Fields... that are obviously wrong.

* Step #5... Duplicate the TOG... of Estimate ... so we can repurpose this for the PO's.

* Step #6... Relabel the Buoy TOs

1721 - Duplicate Module in FMSP Part 2
14:55

Duplicating Estimates to make a PO (Purchase Orders) #3

* Step #7... Go back to the relationships, and check everything... some the relationships needs help...

1722 - Duplicate Module in FMSP Part 3
15:02

Duplicating Estimates to make a PO (Purchase Orders) #4

* Step #8... Duplicate the Layout of the Estimate Data Entry

* Step #9... Re-attach the Layout to the NEW PO Anchor Table Occurrence.

* Step #10... Work through EACH field and re-attach to the correct field in the correct Anchor TO.

* Step #11... Carefully reconnect the Portal...and the fields that are in the Portal. 

* Step #12... Check out all button on the PO data entry screen.  THey are probably broke.  Work you way through these and fix... or REMOVE if you do NOT need them.

1723 - Duplicate Module in FMSP Part 4
12:26
+
1800 - FileMaker Cloud!!!
19 Lectures 03:02:07

• Minimize Costs

* Easy Maintenance

* Runs on Amazon's AWS, limited data center availability initially.

* FMC is a new Option in addition to FMS

1801 - 90 Second Overview
01:37

* Less than 5 Users... Maybe use Amazon t2.small

* 5 full-time Users... Use Amazon t2.medium

* 10 Users ... Use Amazon t2.large

* 20-30 Users ... Use Amazon c4.xlarge

* 50 Users ... Use Amazon c4.xlarge (low end) or m4.xlarge

* 100 Users ... you need to test and see what happens.  Start with m4.2xlarge...and move up if needed.

* Instance Pricing Tool: http://bit.ly/2doXFiy


1802 - Detailed Comparison With Regular FileMaker Server
17:34

• Logical decision making sequence of whether or not FMC is right for you

•Are you using a custom FM App? Are you already hosting your file on FMS? 

• Is FMC available in your region?

• Need support for Windows Active Directory?

• Do you need PHP Access?

• Do you need server-side plug-ins?

• Does your current solution use ESS?

• Does your current solution use PSOS or SASE?

• Your solution been optimized for deployment on WAN?

• Consider list carefully before grabbing FMC

* Instance Pricing Tool: http://bit.ly/2doXFiy

1803 - Is FileMaker Cloud Right For You?
08:49

* Learning about FMC in a high speed brain dump. 

*The video Assumes your already a highly experience FileMaker Developer

* Instance Pricing Tool: http://bit.ly/2doXFiy

1804 - Brain Dump For Experienced FileMaker Developers
18:40

* A Step by Step Walk through of purchasing Step by Step.

* You will need first to step up an AWS Account.

* Create Keypair

* Go to Amazon marketplace and File the FileMaker offering you want

* Accept Terms

* Press the Usage Instructions and Select the Instance

* Wait for Email, then press link and Finish setup.

* Instance Pricing Tool: http://bit.ly/2doXFiy

FMC

1805 - How to Buy FMC - Direct from AWS - New Users
18:43

* A Step by Step Walk through of purchasing Step by Step

* You will need first to step up an AWS Account.

* Create Keypair

* Go to Amazon marketplace and File the FileMaker offering you want

* Accept Terms

* Press the Usage Instructions and Select the Instance

* Wait for Email, then press link and Finish setup.

* Visit FileMaker Inc Setup and Choose New License or Existing License

* Instance Pricing Tool: http://bit.ly/2doXFiy

FMC

1806 - How to Buy FileMaker Cloud - BYOL - Annual Licenses
17:40

* EAT Encryption is required on Files.

* FMC will guide you through the process on enabling EAR when the admin tries to open the file.

* Instance Pricing Tool: http://bit.ly/2doXFiy

1807 - Uploading files to FileMaker Cloud
07:28

* Less than 5 Users... Maybe use Amazon t2.small

* 5 full-time Users... Use Amazon t2.medium

* 10 Users ... Use Amazon t2.large

* 20-30 Users ... Use Amazon c4.xlarge

* 50 Users ... Use Amazon c4.xlarge (low end) or m4.xlarge

* 100 Users ... you need to test and see what happens.  Start with m4.2xlarge...and move up if needed.

* Instance Pricing Tool: http://bit.ly/2doXFiy

FMC

1809 - Picking the right size of Amazon Server
09:54

* Instance Rental, Plus Hard Drive Storage plus data Transfer fees.

* FMC Software fees are in addition to the hardware fees

* Instance Pricing Tool: http://bit.ly/2doXFiy

1811 - Understand Amazon's Total Cost
14:44

90%+ of the Cost is tied into the instance rental. 

Instances can be rented at as substantial discount

"On Demand"

"Reserved for 1 Year"

"Reserved for 3 Years"

http://www.ec2instances.info

1812 - How to Save 50% to 75% on Amazon Instance
07:55

* FMC allows for reserve instances to be pre-paid or partially pad to save a lot of money

* Instance Pricing Tool: http://bit.ly/2doXFiy

1813 - FMI Hourly Costs...with AWS...Switch to Annual
03:23

* FMC will restore all files and replace the instance

* FMC does not allow for easy replacement of single files.

* Instance Pricing Tool: http://bit.ly/2doXFiy

1815 - Restoring from a Backup
06:27

* Robot DB looks for 90% CPU usage

* Robot DB looks for 90% EBS usage

* Robot DB looks for 90% RAM usage

* Robot DB runs nightly Maintenance

* Instance Pricing Tool: http://bit.ly/2doXFiy



1816 - Robot DB & Notifications
04:59

• Managed by Robot DB.

• Attempts to run 12 midnight - 3AM...if NO ONE is logged into the server.

• If people are logged in, the Process will NOT run.

* Automatic Maintenance is the ONLY way to get Reliable daily "Preserved Backups"

* Having staff who just leave FileMaker Open...connected to a database on the server... will prevent the auto maint from running.

* Without Automatic Maintenance, you will only have one week worth of backups without ANY backups older than that.

* Auto Maint will clean up cache files on machine and run diagnostics check.

* A consistency check or database verification is also run as part of the Auto Maint.

* Instance Pricing Tool: http://bit.ly/2doXFiy

* FMC

1817 - Automated Maintenance
08:21

90%+ of the Cost is tied into the instance rental. 

Instances can be rented 

"On Demand"

"Reserved for 1 Year"

"Reserved for 3 Years"

"Spot Pricing"

FMC

1818 - EBS & Backups
07:44

Change the Size of Server... to fit your needs and to Save Money.

* Instance Pricing Tool: http://bit.ly/2doXFiy

FMC

1820 - Supersize my Server!
07:57

Get(Host) Functions on FileMaker Cloud

Making sure your scripts work with FileMaker Cloud.

FMC

1822 - Detecting When a File is running on FileMaker Cloud
05:12

In case of Fire, break glass...

* Emergency Refresh of FileMaker Server - FMC

1824 - Instance Refresh & Emergency Procedures Part 1
11:01

• How to unsubscribe from FileMaker Cloud and Amazon

• This needs to be done in a specific order or else you'll end up still paying for things

1830 -Offboarding FileMaker Cloud
03:59
+
1900 - FileMaker's Certification Test
6 Lectures 55:43

A multiple choice computer generated test...

* Provides a baseline test for FileMaker Developer.

* Test is about 120 minutes

* These videos will NOT provide actual questions and answers.

Preview 01:39

Who can take the test...and pass it?

* Test is about 60 multiple choice questions... no essay or "fill in the blank questions."

* A developer with 4 or 5 years of experience may be able to take and pass the test.

* Test questions and inside info cannot be shared between people.

* FMI has a detailed certification website.

* Senior developers with 7+ years of experience... who have used all features of the product...should be able to pass.

* I have talked to people who have passed the test with a 68% score.  So a D+ may be good enough.

Preview 08:13

* Items on the test...must be documented and published by FMI... somewhere.  Simply being published by a 3rd party...doesn't make it testable.

* For Example:  QuickBooks Integration is NOT documented by FMI... so it won't be tested.

* For Example: ODBC connectivity... is covered it the FTS Advanced documentation, so it could possibly be on the test.

1903 - If its not Canon... it doesn't exist...
05:41

FMI has a actual detailed Checklist of items to study...

* Spend more time of FMI's official Certification website

* Exam overview document PDF... should be largely the same between 14 and 15.

* First page of PDF is excessively goofy...and doesn't help you.  Its all the standard legal boiler plate stuff.

* Page 3 has good information!!!

* Know the technical specifications

* Knowing database Schema... Tables, TO, Fields, Records, etc.

* Knowing Validation Options and Auto Enter Options.

* Building Layouts

* Understanding Core (most common) calculations.

1904 - What is FMI's Official Study List Part #1
12:57

FMI has a actual detailed Checklist of items to study...

• Understanding Core Script skills.

* Understanding error capture

* Understanding Multi-user Solutions

* Understand Security

* Understand Point to Point Encryption

* Understand "File Protection"

* Understand Encryption at Rest

* Understand PSOS and SASE.

Preview 16:13

Watch out for Fake Answers....Decoys and Mayhem...

* Certification test is multiple choice... NOT essay.

* Test is on a Windows Computer... with a very simple test App.

* To Throw you off, FMI... will put fake answers on test...that look good, but are wrong.

* FMI will also show you an answer... that would be "correct" under "other" circumstances.

* To get the correct answer... try to eliminate answers...that you know are wrong... to narrow down your choices to find the correct answer.

1906 - Final Test Taking Tips...
11:00
1 More Section
About the Instructor
Richard Carlton
4.3 Average rating
324 Reviews
3,942 Students
7 Courses
CEO & Senior Engineer

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 new startup, and is dedicated to the FileMaker Platform, with hundreds of videos and upwards of 50 hours of recorded content available for free.

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.