Learning FileMaker Pro 14
4.6 (100 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.
278 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning FileMaker Pro 14 to your Wishlist.

Add to Wishlist

Learning FileMaker Pro 14

Complete Course for Mastering FileMaker Pro
4.6 (100 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.
278 students enrolled
Last updated 12/2015
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 37.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn to to build and deploy FileMaker 14 solutions
Learn to organize and design a database
Learn to create buttons, and write scripts
Learn to enable security and passwords as well as encryption
Learn beginning, Intermediate, and advanced FileMaker skills
Learn to build scalable databases
Learn about performance tuning... so a database can be shared with a dozen people or a hundred people.
Learn how configure FileMaker Server, to set backups etc.
Learn to build a new database... by started with a FREE starter solution... not by starting from scratch.
View Curriculum
Requirements
  • This course assumes the user has FileMaker Pro 14 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 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 basic skills such as adding fields and managing layouts.
  • 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
Expand All 219 Lectures Collapse All 219 Lectures 37:25:26
+
0100 - Introductions - Overview
10 Lectures 01:27:34

Quick Course Summary

This training course focuses on FileMaker 14 and FM Starting Point 4.5, but is largely applicable to FM 13, 12, and 11. There are corresponding versions of FM Starting point for these versions of FileMaker.

Preview 05:12

FileMaker is a Box of Tools!

The FileMaker platform consists of many powerful products that allow you to build any type of custom solution you need... to solve any type of business need.

Preview 07:16

0103 - What kind of Solutions can be made with FMSP?
05:29

Operating System Compatibility issues, etc

A guide to understanding what devices and operating systems are needed to run various versions of FileMaker. Also, for those with older operating systems.... you can purchase the current versions of FileMaker... and then "downgrade."

0104 - Installing FileMaker and FMSP
09:19

Which FileMaker product(s) should I purchase?

Picking the right mix of FileMaker products is critical for successful business deployment. THe current product lineup: One Server, and 3 types of clients - Pro, Go, and WebDirect

0105 - Product Positioning
12:32

Whats new in FileMaker 14

Android Support

Script Workspace

Lots of additional cool features

0106 - New Feature Brain Dump for New and Intermediate Users
11:06

What do I need to know...

Plugins now need to be 64 bit... for Windows and Mac. 32 bit plugs won't work anymore. Keep in mind that I think that there is a 32 bit version of Pro available for Windows. For this... 32 bit Plug-ins should be fine.

FileMaker Server has been 64 bit since FileMaker 13.

0108 - Upgrading 12 or 13 Solutions to FM14
10:36

How do I host a file?

Basic outline of peer to peer hosting and FileMaker Server hosting... concepts and benefits of using FileMaker Server.

0109 - Basics of Sharing a Database
10:07

Pro Advanced is for Developers...

If you need to turn on encryption, debug a script that's going sideways, or import a script, table, or field from another file... then you will need FileMaker Pro Advanced. There are an additional 8 or 9 other extra features as well.

0110 - FM Pro Vs. Pro Advanced
02:37

License Requirements for Server

FileMaker Inc. changed the licensing requirements for connecting "Free" clients to FileMaker Server, and this video covers the details regarding connection licenses. Concurrent connections are required for FM Go clients as well as WebDirect clients.

0111 - Concurrency Licenses for access to FMS
13:20
+
0200 - FM Starting Point Walkthrough
14 Lectures 02:37:37

Beginning Technical Walk through

Beginning of our technical walkthrough series, discussing the Preferences table, which has ONE RECORD. We do not show the status area when displaying layouts. Adding records to the preferences table is bad, and will result in erratic behavior of FMSP.

Preview 19:03

Desktop, iPad and WebDirect

Get the inside scoop on how and why RCC organized the FileMaker layouts the way we did, plus how we can support the devices that we support. For example, there is minimal support the for the iPhone. Why? Watch and find out.

0202 - FMSP Device Support & Layout Organization
06:53

Learn our organizational secret for Scripts in FMSP

Well, it's not really a secret. It's pretty straightforward, but new developers never think to do this. We start you out on the "right foot" with FMSP.

0203 - Script Numbering and Organization
04:33

Complexity is Banned in FMSP... violators will be banished

I want FMSP to be understood by new FileMaker users... power users... or by "junior level" developers. More experienced FileMaker developers who write complex advanced scripts prevent new FileMaker users from understanding a database... and as a result... prevent them from making useful customizations.

0204 - FMSP Complexity Theory
06:46

Technical Walk through

Accounts are really companies or organization. Does your new project really need the accounts module? If not, you can remove it. FMSP key fields have prefixes. We also walk through the various sections and secondary navigation modules.

0205 - FMSP Account & Contacts Walkthrough
18:31

Technical Walk through for Invoices

Includes instructions on how to customize Invoice Status. Also what fields may be removed... depending upon the structure of your database. Also there is a limited inventory tracking system built in.

0206 - FMSP Invoice Walkthrough
12:47

Technical Walk through

Email Template automated system... for quick selection of emails.

0207 - FMSP Contacts Email Template Walk Through
05:17

Technical Walk through

The features here have been in use for a long time... and people really like it. The 2nd half of the video is a technical under-the-hood look.

0208 - FMSP Sales Followups
15:12

Discussion of Feature - Transactional Model

We discuss... our deployment of a "transactional model" within FMSP. We don't do this that often... but we need to here... because the FMSP Invoice Starter solution has a serious defect.

0209 - FMSP Invoice - New Line Items - Advanced
14:26

Also in Estimates

Margin and Markup are totally different formulas... so don't let their similarity fool you.

0210 - FMSP Estimate to Invoice Transfer Button - Customize it!
12:36

Also in Estimates

Margin and Markup are totally different formulas... so don't let their similarity fool you.

0211 - FMSP Calculating Margin and Markup in Invoices
09:37

0212 - FMSP Unlimited Related Digital Document Upgrade
09:08

Super-Advanced Conversation on Calendar

The Calendar Displays makes use of 3 Layers of data that project through each other to make a functional calendar. Medical Warning...your head may explode...if you watch this video.

0213 - Understanding the FMSP Calendar - Part 1 - ***Advanced ***
09:50

Advanced Conversation about how the FMSP Calendar Works

The Calendar projects data from the Activity Notes...and from the related Tasks.

0214 - Understanding the FMSP Calendar - Part 2 - ***Advanced ***
12:58
+
0300 - Fundamentals & Basics
8 Lectures 49:25

Basic video overview

Collections of Similar types of information goes into Tables. Fields are individual data elements. What are outside examples of a database? Ebay is one! Database = Template = Solution. The FileMaker platform uses the .fmp12 file format. FileMaker uses screens, called Layouts.

Preview 06:02

Basic video overview

Files, Tables, Fields, and Layouts... and now we have relationships. Relationships are driven by key fields. Relationships allow data from multiple tables to be displayed on a single layout at one time. Scripts are little computer programs that can help automate activities in FileMaker.

0302 - What is a Database - Part 2
04:41

Browse, Find, Preview, and Layout

Browse mode is for using the database and editing the data. Layout mode is for customizing the look of the database. Find mode is for executing a Search in the database. Preview is for "previewing" how a print job will look if the print command is run... or if a PDF is created from the current layout. The menu bar changes based upon the mode you are in.

0303 - Modes in FileMaker
05:59

Basic database usage by end users

Super basic video that might be good for people who have no previous exposure to FileMaker. Navigating between fields, Browse mode, flipping between records. Deleting records is not necessarily a good thing, so think about that carefully.

0304 - Browse Mode, and the Delete menu item
06:48

Yah... its totally automatic.

FileMaker saves pretty much everything automatically.

0305 - Saving Data
02:14

Upgrading a DB from FileMaker 7, 8 , 9, 10, and 11 to 13

Pretty straightforward... but a couple of "gotcha's" and FYI's.

0306 - Converting from .fp7 to .fmp12 file formats
08:15

Upgrading a DB from FileMaker 4 or 5 to the FM 7 format...

If you have a simple database, then this can be a simple process. But if you have a large complex solution, then this can be an ugly process. You will need MetaDataMagic to help analyze the .fp5 format to determine all the issues that have to be mitigated.

You might want to weigh the cost of migration, versus the cost of a total rebuild. A number of companies opt to go with the rebuild.

0307 - Converting from .fp5 to .fp7 file formats
10:04

Use a custom sort order to sort BC and AD date fields.

Use a custom sort order to sort BC and AD date fields.

0308 - How to make a Copy of a FM Database
05:22
+
0400 - Performing Finds & Sorts
8 Lectures 57:36

Search, Queries... FInds in FIleMaker

"Found sets" are collections of records that match a particular find request. Find mode focuses all user activities on the "found set." Default searches in FileMaker are wild card searches that search the first part of each word.

Preview 05:59

"and & "or" searches in FileMaker

Learning to do finds for various items at one time as an "and" find... or as an "or" find is an important skill to learn.

0402 - Finding - Multiple Requests
11:04

Hunt down ranges of records based on a date

Performing a range search in FileMaker is one of the most useful skills to use, and to teach other FileMaker users.

0403 - Finding Ranges of Dates
04:37

Reserve characters can help Finds.

Special operators... i.e. reserved characters can do magical things when in FileMaker find mode. Search for an empty field, email addresses, exact searches, or other wild card searches.

0404 - Finds with Special Operators
08:50

Where the rubber meets the road...

Understanding Indexes is the key to understanding how to make your finds run fast. Make sure that fields that users will search on will be indexed. If they are not indexed, expect SLOW performance.

Stored Calcs... will perform FINDS much faster.

Unstored Calcs ... cannot be indexed, resulting in slow searches.

0405 - Finds and Indexing and Performance, Stored Calcs
06:26

95% of FileMaker users never use this.

Extending and Constraining a found set are super helpful skills to help figure out more complex finds... especially where multiple requests need to be worked out. Unless you're a rocket scientist and you can do everything in your head, you will want to learn this skill set to help build complex finds.

0406 - Finds Constrain and Extend
04:52

Fundamental Basic Skill Set

Sorts are limited to the current found set. Keep in mind, that added sorts will cause a performance hit on the database when you do it. So automatic scripted sorts should only be used for those sorts that you actually need. We haven't talked about scripting yet... but for now remember to limit sorts to perform only when needed. Not just for fun... especially for shared databases on the internet.

0407 - Sorting Records
07:54

Sorting AD and BC date fields.

Sorts sound simple, until you have AD and BC dates.

0408 - Custom Sort Orders
07:54
+
0500 - Working on Fields & Layouts
30 Lectures 05:08:38

Overview of Layout Menu Bar

Basics of the layout tools for building and editing layouts. Detailed discussion of the tool bar in layout mode.

Preview 11:23

4 panels of goodness

Understanding all the panels of the inspector is important, and will come with time as you start building solutions in FileMaker. FM12 only had 3 panels, but FM13 and 14 both have 4 panels. We talk about the POSITION panel more in a later video on object alignment. This is more of a well rounded summary.

Short discussion about naming objects

0502 - Tour of the Inspector
13:42

Formatting fields - Adjusting Currency... etc.

Adding new fields; finding space on an FMSP layout for new fields; introduction to Tab Objects; introduction to locking objects; Aligning objects; format painter tool; formatting number field for financial currency data type; reordering tab panels.

0503 - Intro to Adding Fields to Database (Text and Number)
12:24

Basics of Defining Calc fields and Hiding Objects.

Introduction to calculation fields and hidden objects.

*** We do NOT discuss Unstored Calc fields yet.

0504 - Added Calc fields and Hiding Objects
12:02

Defining fields, and Custom Formatting of Fields

Creating fields for a survey is easy. Creating an easy-to-use survey takes more work. Formatting the fields for easy data entry is the trick. We will need to find a section in FMSP to build our pet survey. We will need to delete some existing fields to make some room.

0505 - Creating a Survey & Tab Panels & Value Lists
14:53

How Value Lists really work - Basic Value list setup

Radio buttons and check boxes gone wild... in FileMaker. These tools can auto enter data into normal text fields which can be super handy. Radio buttons and checks boxes can also obscure actual data in the field... if the actual data in the field does not match an approved value for the value list.

0506 - Value Lists - Under the hood
09:40

Also Managing Objects Layers in FileMaker

Deleting objects on a layout without affecting the database structure, managing object layers, and customizing Tab Controls which are made up of individual tab panels. More advanced Object layering with hidden objects and conditional formatting of text blocks.

0507 - Hiding Objects & Conditional Formatting
13:48

What do you do with funky formatted text?

Users frequently copy and paste text from other sources into a FileMaker database. This creates local styling which can override your nice pretty layouts. You need to clean the text and learn how to format text fields. Selecting multiple objects in layout mode.

0508 - Text Fields & User Formatting Issues
11:37

Add Dynamic data to a Text block

Seamlessly adding dynamic data in the form of fields, tightly mixed with blocks of text data is best handled by Merge fields, which cannot be manually edited in BROWSE mode.

0509 - Merge Fields
04:46

Performance and Update Issues

Sometimes you have a choice between using a Stored Calc, and an Unstored Calc. But often, FileMaker will FORCE you to use a unstored calc... because of the contents of the formula.

3 Things That can Make a Stored Calculation Field Reevaluate:

(1) When you First Define the Field... (Duh)

(2) Make a new record. FileMaker will reevaluate the Calculation

(3) If LOCAL referenced data Changes (Local... Not related data). Variables are NOT considered Locally referenced data. They are nothing. Not Local data and not referenced data.

Stored Calc cannot handle variables at all... and will not evaluate reliably. Think of Variables like transient Get functions. Always in flux and changing. For that reason... if your connecting a variable to a calculation filed, make sure it is unstored.

Unstored Calcs have the Same Dependencies, plus one additional One:

* If the Unstored Calc is drawn on screen... it will reevaluate

----------------------------------

FileMaker forces a Calc to be Unstored if:

(1) Reference Related Data

(2) Reference Global Field

(3) Reference Summary Field

(4) Reference another Unstored Calc (in case you're trying to cheat)

0510 - Stored Vs Unstored Calculations
12:29

Summary of Button Options

Use conditional formatting to control Glyph Color.

0511 - 3 Types of Buttons and One Glyph - Icon
09:48

Button Bar used in a Very Clever Fashion

Thanks to FileMaker's Nick Hunter for showing this technique to me.

0512 - Button Bar as New Data Input Control Style
04:30

Understand these layout objects

Slide Controls were added in FileMaker 13 and sometimes developers get confused as to the proper deployment for Tab Controls... as opposed to Slide Controls.

0515 - Tabs vs. Slide Controls
07:32

Popovers quickly display additional info

Popovers may seem cute and cuddly, but they have some serious short comings for both the FileMaker Go and WebDirect platforms. For FileMaker Pro... Popovers provide another awesome option for providing data, adding navigational controls, etc. Record locking is discussed.

0516 - Popovers and New Window Command
10:46

Lots of options of auto populating data into fields

Auto enter options can fire upon creation of a record, upon modification, or upon trigger of a calculation, etc. They are extremely powerful. They are used to form the "backbone" of the automatic processes that drive FileMaker. My opinion... is that they are still useful... but more complex situations would probably be better suited by leveraging script triggers, which are new tool with exponentially more precision and power.

0517 - Auto Enter Options for Fields
08:16

Digital Document Storage

Starting with the release of FM 12, and improved in 13 and 14... Digital Document Management is now built into the base FileMaker Platform... without the need for 3rd party add-ons.

0518 - Container Field Introduction
11:59

Understanding streaming, Scripting etc

Selecting "Interactive Content" can hose performance... for a hosted solution. Plus we wrote some scripts to allow for easy opening of the container content. We also show how FM Go shows "Interactive" containers. We also show how to script the export of the container, into a temporary folder, and then have the operating system open it.

0519 - Advanced Container Field Kung-Fu
12:05

0520 - Containers in FMSP
06:53

Major concept for Developers

Understanding how FileMaker files behave when shared with multiple users is an important skill... if you do much work in FileMaker. Understanding record locking, sorts, find, and Global fields... are all important to successfully deploying a shared solution. Of course FMSP already is designed to be shared... so we thought this out in advance... but you will want to learn this if you do much development.

0521 - Introduction to Single-User vs. Multi-User databases
09:35

Unique tools...one value for every record

Globals are a great tool for scripting or other unique data organization. Globals have different properties. One value ... for the table... but essentially accessible anywhere in the file through a relationship.

0522 - Global Fields
10:59

Popup text by mouse hovering

A user can add a text description to various objects in Layout mode. This text will then pop-up when a user hovers their mouse over the corresponding object. This has limited uses... largely due to the lack of controls provided by FMI.

0523 - Tooltips
07:19

Lots of features means lots of little icons

Part of learning to develop in FileMaker is learning all the little icons that may be assigned to an object in layout mode.

0524 - Object Flags, or Badges
07:50

Aligning Objects and Misc features

Learning the various methods for aligning objects, and learning what works for YOU as a developer is an important step in your development. We will also spend some time in the VIEW menu item and also the POSITION panel of the inspector. Multiple Inspectors, Grid system, & customizing toolbar is "User Specific" so changes are not shared with other people. Also learn about: Unlimited number levels of undos and Grouping and Ungrouping objects.

0525 - Object Alignment tools
12:34

Managing Stencils for all the iOS Devices

In addition to customizing a prebuilt FileMaker template like FM Starting Point, you can create a layout from scratch. You can specify a custom layout size in the Stencil. When you create a layout, you can also specify a custom layout size. Please reference the 2 cheat sheets in the work files for this training course.

0526 - Creating a new iOS Layout from Scratch - Stencils
07:33

Old school field Validations...that apply at the field definition level

WordCount allows you to count the number of words.

0527 - Field Validation Options
13:19

When I was your age...I walked 10 miles to school...barefoot...in the snow!

Before FileMaker 3... we needed repeating fields... and the LOOKUP functionality to make basic databases in FileMaker. Now... we use repeating fields sparingly. FM Starting Point uses repeating fields to help manage containers. In the mathematics and engineering fields... these are essential arrays... 1-D arrays.

0528 - Repeating Fields
10:33

Stay in Layout mode...and understand the badges...

No more drilling down for conditional formatting, etc, etc. FileMaker 14 has Layout level tooltips... to tell you all the attributes for an object. Very cool!

0530 - Layout Badge Tooltips
03:09

Managing Portals and Invoices...

By modifying your portal you can create a multi-page invoice. It is simple, yet powerful.

0531 - Multiple Page Invoices - Portal Management
11:21

Inside the Event Management Starter Solution...

The Event Management Starter Solution demonstrates some cool new menus and labels

0532 - Hamburger Menus & Inline Text Labels
09:54

Container fields in FileMaker will act different depending on whether they are set with interactive content or not.

0533 - Interactive Containers in FileMaker
15:59
+
0600 - Advanced Layout Techniques
15 Lectures 02:48:35

Shared Styles and Themes Part 1

Most legacy layouts will have the "Classic" theme, and that is very wasteful and slow when compared to other themes. Using a custom theme and shared Styles, like what we did for ALL layouts in FMSP 4, will make layouts load twice as fast. Before we start customizing a theme, we should remove unnecessary objects from the layouts... to minimize network traffic from the server to the client.

Preview 08:45

Shared Styles and Themes Part 2

Learn to make a layout load twice as fast. This video is one of the most critical videos to watch if you want to learn how to lighten your layouts and make the load 200% faster. No Joke. This is a new technique in FileMaker 13 and optimized in 14.

0602 - 200% faster Part 2 - Performance
08:51

Shared Styles and Themes Part 3

Learn not to blow up your hard work of shared styles. Avoid the format painter tool because it creates it own blocks of CSS... AKA a "local CSS override." Be careful about copying objects from one layout, to another layout that uses a different theme.

0603 - 200% faster Part 3 - Performance
03:07

Massive Performance Improvements

This is a super clever process that I learned from Nicholas Hunter at FileMaker Inc. This saves a ton of processing time and effort if you have a number of hidden objects with the same formula. This can be a factor in performance improvements.

0604 - Grouping with Slide Panels to Hide Objects
05:58

Scanning for hidden objects...

This Get function is handy for determining if something is actually hidden... without using a big long calculation.

0605 - Get Object Attribute for Hidden Objects
03:06

With Great Power Comes Great Responsibility!

OnWindowFirstOpen, OnWindowOpen, OnWindowClose, and OnWindowLastClose.

0608 - Script Triggers - Intro
04:33

Pre Trigger and Post Trigger Execution, and Layout Targeted Triggers

OnLayoutEnter, OnModeEnter, OnRecordLoad. OnLayoutSizeChange is pretty much targeted at FileMaker Go users, so we cover this trigger in our $29.95 FileMaker Go video course... in detail.

0609 - Script Triggers - Layout Specific
10:16

Stopping Pre Trigger Events...with a Script Parameter

OnObjectEnter, OnObjectKeystroke, OnLayoutKeystroke, OnPanelSwitch... for Tab or Slide Panels.

0610 - Script Triggers - Object Specific
08:03

Managing field validations and workflow

OnObjectModify, OnObjectValidate, OnObjectSave, OnObjectExit. Some of the most used script triggers!

New content dealing with more subtle issues of the script triggers. We also discuss Directed Workflow... for workflow management.

0611 - Script Triggers - Field Validations
10:25

Exiting Objects, Records and Layouts

OnRecordCommit, OnRecordRevert, OnViewExit, OnModeExit, OnLayoutExit, OnWindowClose, InstallOnTimer.

InstallOnTimer is an automatic Window Script activator tool.

0612 - Script Triggers - More Layouts controls
06:37

*** Super Advanced Topic ***

Advanced discussion, covering the use of OnRecordLoad Script Trigger, Get (NthRecord), Get(RecordNumber). Cartesian Join, Summary field List field.

0614 - What is a Virtual List? *** Advanced ***
14:26

*** Super Advanced Topic *** Uses Virtual List...

You need to have mastered the previous video on virtual list prior to watching this video.

Sample files available from http://www.newleafdata.com

0615 - Hierarchical Portal for Navigation *** Advanced ***
17:01

*** Semi Advanced Topic ***

How to jump from one record... to another through a relationship. Also covers how this interacts with Anchor Buoy, and the design methodology of FMSP.

Also covers error trapping error 101, and the option of setting up Portals to add records by clicking on a new line... i.e. "Cascading adds"

0620 - Go to Related Record - GTRR
20:43

*** Semi Advanced Topic ***

Richard Carlton and Michael Wallace go under the hood of the RCC FileMaker Layout Optimizer. From analyzing scripts to discussion of the Base Elements plugin, there is a lot of great info to be learned!

To download the RCC FileMaker Layout Optimizer: http://rcconsulting.com/downloads.html

0621 - RCC Layout Optimizer
23:59

You need to hack SVG's to get them to work with FileMaker

Featuring Claus Lavendt of DataManix... who explains what an SVG is... how its different that a PNG... and how to hack the SVG to get it to work with FM14. Unless it is hacked, FMI won't be able to control the color the icon dynamically. The helper tool assists with this.

0622 - FileMaker 14 SVG Icon Helper Tool
22:45
+
0700 - Emailing, Imports and Exports
15 Lectures 02:22:45

FileMaker can be the center of your digital world

Importing, Exporting, generating Excel spreadsheets, PDFs, etc. Manual or automated activities. Email generation. We plan on touching on WebDirect and Barcode management in this section as well.

Preview 03:15

Basics of manually importing data into FileMaker tables...

FileMaker reads lots of different file formats, including Tab Delimited, Comma Delimited, Excel, Merge, etc. FileMaker will not directly read a PDF or Word document without the aid of a 3rd party plug-in. 360Works has a Plugin that assists in have FileMaker integrate directly with MS word.

0702 - Importing Data
15:02

Basics of manually exporting data out of FileMaker...

Export data into Tab Delimited, Comma Delimited, Excel File, etc.

0703 - Exporting Data
08:16

Save your Ad-hoc Imports and Exports by Creating a Script

Power users and new developers forget to "save their work" when doing Ad-hoc imports or exports. This will cause a lot of wasted time reproducing the import or export a 2nd or 3rd time... from scratch.

Also, we cover a couple of additional import dialog options.

0704 - Scripting Import & Exports - Basics
04:43

Recurring Imports, Scripted on a Robot, Scripted on a Server


0705 - Automating Imports or Exports - Robots and Servers
08:47

What is SMTP...basics...and then more advanced skills

Learn the basics before getting into deep email Kung-Fu. We have a sample file to learn and play with the SendMail script step. You can get this file as part of our "pack" of work files... in a Zip... on the RCC website.

http://rcconsulting.com/Downloads/Work%20Files.zip

*** Important *** I failed to mention that the emails FileMaker sends are plain text... and NOT HTML based emails... which is unfortunate.

0706 - Send Email Script Step
11:32

Use Lee LukeHard SMTP Interrogator tool to hunt for your settings


0707 - Finding Your SMTP Settings
04:40

Digging through FMSP Code in detail

Passing script parameters, looping records, SMTP settings, and IF THEN decision trees. Substitute function to customize the body of email with custom values from each specific record. We didn't have to use the let function, but my developer got overly cute.

0708 - Automating outbound emails
11:31

How far can you go... shooting mass emails out of FileMaker?

Once people figure out that FileMaker can blast out emails... they want to shoots emails out to everyone for sales and marketing. Is this a good idea? Maybe. You need to know the rules, and also understand what your SMTP email server expects... or will allow. Your outbound email provider will only allow "so much" outbound email traffic to be sent to them. You will probably need to pick up the phone and talk to them on the phone, to establish a "real" relationship, so they know who you are.

0709 - Spamming with FileMaker
04:23

Firing off emails to people with attached PDF reports...

We discuss FileMaker access to directories. FileMaker has access to a temporary directory, and a documents directory. These techniques also work great for email exports from a table... or the Excel spreadsheet you exported.

0710 - Automating Emailing of Exports, Like a PDF
08:29

How to Delete a File without a Plug in...Very Cool!

Just use the techniques you have learned previously, but make sure when you create the file... you have a found set of ZERO records.

0711 - Scripting FileMaker to Delete a File
02:11

Breakout the Relational Kung Fu!

You can only import data into a single table at a time! Common scenario... Excel file which needs to be imported into Accounts and Contacts... so we need to do multiple import passes... against the same Excel file. Pay special attention to when you turn ON auto-import options during the FileMaker Import!

0712 - Multi-Table Imports... Complex Imports
12:10

A step by step process on importing multiple tables in FMSP

This is how to upgrade from FMSP 3 to 4, etc, etc.

0713 - Upgrading Copies of FMSP
23:19

We need to import into a temp table first

This requires some thought and scripts.... but it is pretty straightforward. Good for updating contacts, or updating products with the latest prices, etc, etc.

0714 - Updating data in a FileMaker table from an Excel File
09:29

A step by step process on how to setup

HTML emails cannot be generated or processed directly out of FileMaker without the help of a plugin. Here is a good one for making great looking emails.

0720 - Using 360Works Email Plugin to Send HTML Emails
14:58
+
0800 - Integration
18 Lectures 02:40:21

Overview video... with some additional content...

https://www.geistinteractive.com/products/filemaker-barcode/?giref=1

Preview 12:35

Copy and Paste Two Scripts...and then reconnect one more...

Installing Geist Interactive's Barcode Creator software into FM Starting Point is a snap. Make sure you have at least FMSP 4.2 or better... for easy setup.

0802 - Installing the Barcode Creator into FMSP
06:06

Adding Line items to a Invoice with a Scan Gun... Very Fast!

Scanning items into FileMaker can be made to work very quickly with some scripting, a bit of hardware, and an understanding of how barcodes work.

0803 - Scanning Items into Invoices with Barcodes
02:40

How does the Mac/Window layout scan barcode for invoices....

How we built the functionality for adding line items to invoices and estimate... for the desktop and laptop screen... for Mac and Windows Computers. Assumes you are using a Laser barcode gun, connected via USB or equivalent.

0804 - Under-the-hood with Scanner Barcodes In FMSP Part 1
07:33

How does the iPad layout scan barcode for invoices....

How we built the functionality for adding line items to invoices and estimate... for the built in camera on an iPad. Discusses single document interface restrictions and the InsertFromDevice command that is specific to FileMaker Go.

0805 - Under-the-hood with Scanner Barcodes In FMSP Part 2
08:51

How to customize your script to create your own Barcodes...

If you have purchased your own copy of the Geist Interactive's Barcode Creator... then this is a short discussion about how to create your own scripts... and tie those into FMSP... AFTER you have followed the instructions in video #0802.

0806 - Under-the-hood with Scanner Barcodes In FMSP Part 3
13:05

You like my gun? The Adesso NuScan 3200u.

The Adesso NuScan 3200u. We talk about the suffix or termination character... and how you go about programming barcode guns... which is kind of cool. You can zap barcodes right out of the printed manual.

0807 - USB Barcodes Gun We're Using
04:17

We have label printers... they probably won't work for you...

Printer layouts in FileMaker are somewhat finicky... and these will need to be customized and fixed by you once you get the printer you want to use and you get your printer drivers installed. Also... a trick for keeping your users from running wild with their scan guns.

0808 - Setup Up Printer Labels & Users Scanning the Wrong Barcode
06:37

Troubleshooting Barcodes... and some Q&A

The Test Barcode File is part of the work files which can be downloaded from this web page:

http://rcconsulting.com/downloads.html

0809 - Viewer Questions & trouble shooting Barcodes
07:17

Awesome Laser barcode readers....

URL Protocol allows FileMaker Go to talk the iLinea app, which you need too have installed on your iOS device.

0810 - Infinite Peripherals Barcode Hardware for iPhone & iPad
12:19

FMS won't Generate PDFs, so it needs help from Pro!!!

There are several ways of doing this, including using a plugin from 360works... Remote Scripter. Also... introducing Perform Script on Client... PSOC.

0814 - Getting FileMaker Server to Generate PDFs - PSOC
09:37

Do you need a Robot... where do you hire one???

A dedicated computer with FileMaker Pro is still the best tool for most jobs. The robot can explode into little tiny bits.... and the FileMaker Server is unaffected. SASE... is the Server Activated Script Execution... which is basically a backup schedule system in FMS that doesn't run a backup... but runs a FileMaker Script. SASE is limited.

0815 - What is a FileMaker Robot?
08:58

You need a Plug-in....and this is a good one...

A sit down and overview with 360Work's awesome plugin. HTML Emails, and a brief intro to Amazon's Simple Email Service (ASES) or just (SES). Plus the Plugin can send out SMS messages and IM messages. Very cool!!!

0820 - Intro to Sending HTML emails and SMS messages
07:28

Progress Bars look really cool in your solution...

Andy Persons, from Excelisys, has created an amazing free tool that helps you easily add Progress Bars to your FileMaker solutions.

Download the free sample file here:

http://www.excelisys.com/blog/2014/08/28/filemaker-pro-13-tip-n-trick-v3-filemaker-pro-progress-bar/

0830 - Building a Progress Bar in FileMaker
13:16

Are your emails valid? Or are they getting rejected?

Making sure the emails that you are sending from FileMaker are valid is very important for your organization and to your email provider.

0831 - Validating Emails with a Service
08:51

Get actual driving distance...and drive time...not as the bird flies.

This is a very cool service... that is essentially free come Google. It will output XML... so you may want to watch the video on XML parsing.

0832 - Getting Driving Distance From Google
09:08

Dialing Phone Calls from FileMaker... Real Easy.

You will need to Leverage URL Protocal capabilities to talk with SIP. We also leverage Vonage, and X-Lite in this video.

0835 - Dialing VOIP Phone with SIP & X-Lite
10:44

Sending SMS messages without a Plugin....

This technology works on any of FileMaker's clients and is VERY cool. Sample file is included in the Work Files, but before you can use it... you will need to setup an account at Twilio.

0840 - Sending SMS with Twilio
10:59
+
0900 - Writing Scripts
32 Lectures 04:51:53

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

Totally new in 14... and it's heavily loaded with Keyboard shortcuts.

0902 - Intro to Script Workspace
06:22

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


0903 - Workspace Keyboard Shortcuts
07:15

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
17:12

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:43

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:29

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

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 non-advanced FileMaker Pro." This tool is a like a leash for your dog... or "3 year old." Whatever works for you. Its great!

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

0920 - Script Debugger - Part 1
21:06

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 realtime... 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 that problem... so we made this video to walk you through the steps. Easy! 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

0931 - UI Indicators for Database Activity
11:10

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. We have given you a good start in the right direction with FM Starting Point 4.5. This video provides a bit more direction on the topic.

0941- Making Scalable Databases
11:47

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

0943 - Perform Script on Server - PSOS
20:21

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:42

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"

Advanced 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:21

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:08

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, your going to accidentally turn it loose... and it's going to start eating people.

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

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:25

Beware of accidental script trigger detonation...


0953 - Landmines in FileMaker
10:04

Before running a big script that does important reporting, etc, make sure that critical records the script needs to edit... are not locked...and in use by another user. This is another video on capturing scripting errors... as discussed earlier in another video. If two users try to edit the same record at the same time, FileMaker generates a Lock Sync Error.

0955 - Error Capture - Lock Sync Error Testing
07:52

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 a number / Trim Function
05:29
+
1000- Calculations
17 Lectures 02:24:28

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:33

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

Middle (text), PatternCounts, and Position Functions

Isolating an Email address ... How To

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.

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

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

1020 - Get Functions Walkthrough - Part 1
09:03

A high speed walk through....


1021 - Get Functions Walkthrough - Part 2
07:28

A high speed walk through....


1022 - Get Functions Walkthrough - Part 3
03:51

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


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:24

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:12

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...
10:25

Extract the exact block of text...you need... with this cool technique

Frequently, Google and other online services will send you data formatted in XML. You will need some additional skills to quickly chop on this block of text... to get what you want.

1045 - Parsing XML
16:53
7 More Sections
About the Instructor
Richard Carlton
4.4 Average rating
286 Reviews
3,673 Students
5 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.