ISO FileMaker Magazine

For some of us, one of the most enjoyable aspects of programming is the fact that we get to feel so "in control" over every single aspect of how something works. You are the God of your own universe and it's either as bad or as good as you make it.

Our human shortcoming, however, is that fact that we don't just know it all - we have to learn the various ways of doing things. Knowing how to use FileMaker's functions, and when they are useful, is a key aspect to creating well functioning software.

This video is a walk through of the ever critical logical functions. Without them, none of us would be making any software. So, sit back and relax for the well covered topic of FileMaker's Logical Functions.

When first learning about database development, and how to store large files such as media, archives and documents, I was introduced to the concept of a BLOB (Binary Large OBject).

At that time, I wasn't using FileMaker Pro as of yet but a database called FoxPro. The concept of FileMaker's Container fields, as places to store BLOBs, came so much easier than having to convert a file into another format which can be stored within a SQL data store - which is what you have to do with some other database systems.

In today's modern computing world you need to be familiar with how to encrypt things and how to transfer them between various services. This video will overview the Base64 encoding functions, the Crypt functions and all the other Container related functions. If you'd like to understand how and where the container functions will help you out with working with containers then you'll likely find what you need in this video.

If you're the type of person who's into Math, then you probably know when you need to use Factorial() versus Exp() versus Div(). Inevitably, you're a better mathematician than I. My use of the Number functions extends to how useful they can be when you're creating your FileMaker user interface and solving workflow related problems.

When it comes to FileMaker's Number functions, there are number of tricks I've picked up over the years from those who are much smarter at the "math part" than I am. For the most part, the functions are there when you need them and are obviously useful when your required solution deals with math.

In this video, I go through the Number functions and talk about when and how I've used them. Which ones I've used the most and what you can do with them.

When you're learning a new skill or programming language, you don't always know what you might need to know. Such was the case when I received an email asking me to go through the various groups of FileMaker functions. I thought to myself, "In most of my videos, I showcase the use of certain functions, but, I've never really gone through each function one by one."

So, in this video, I do exactly that. I relay my experience and exposure to each of the various FileMaker functions. Starting with the Text group, I walk through each of the functions, or function types, and talk about their use and what I consider their frequency of use to be in daily FileMaker development.

Granted, each solution built in FileMaker is always different and where some solutions may need more math and numbers, others may just store and manipulate data, it's a great thing to know about all the possible functions you can use. And, that's exactly what this video is about!