Learning Claris FileMaker

When most people think about custom-built software for business, they think of a single application with a single purpose, like a CRM or an email client. 

We can understand why most businesses would not look for custom software solutions for such applications—why spend that money when there are so many options from which to choose already on the market? 

But the kinds of projects we typically engage in here at Skeleton Key aren’t single-purpose custom applications. 

We are often building software that runs entire businesses—or at least, that runs many of their core operations. 

 So the question of whether or not your business needs custom software solutions isn’t answered by thinking in terms of typical apps, but rather by thinking in terms of another type of software: ERP systems and ERP modules. 

So ask yourself: Do you love your current ERP?

Among FileMaker Pro’s many functions, the Let function stands out as one of, if not the most, powerful among them. 

This article attempts to demystify the FileMaker Let function and demonstrate examples of its practical use. 

Purpose of the Let Function: Explained 

Why use the Let Function? 

How to Format the Let Function 

Multiple Variable Assignments (include square brackets) 

Single Variable Assignment (no square brackets) 

Let Function Variable Types 

Basic Use 

Use Let to Avoid Nesting Use 

Let to Avoid Repetition Nesting 

Let Functions Dynamic Variable Creation

Chad Adams from Skeleton Key presents and leads a discussion about FileMaker Pro's Card Window functionality. 

Review the basics Learn how to use Card Windows and some advanced uses that you may not have considered until now.