English

FileMaker Overview: Logical Functions

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.

Tags:

FileMaker Overview: Aggregate Functions

So, what's the point of collecting all that data if you're not going to determine what it's telling you? Well, a lot of those burning questions are often answered with the power of the Aggregate functions.

Whether you simply need some total using the Sum() function or if you're an advanced developer writing crazy scripted loops using the List() function, you need to know how to use the Aggregate functions to achieve the desired results.

There are a few peculiarities about using the Aggregate functions, but once you've got them down you can decide how you want your database to behave. Using the Aggregate functions, you can store your aggregate data and move in the direction of better performance in favor of FileMaker figuring it out for you all the time. Or, you can just use FileMaker in the same way you've always been doing and simply take advantage of its easy power. Either way, it's all covered in this video about the Aggregate functions.

Tags:
AttachmentSize
AggregateFunctions.zip20.39 KB

FileMaker Overview: Container 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.

Tags:

FileMaker Overview: Date & Time Functions

Knowing how FileMaker's Date and Time functions actually work is quite a big help when you're creating anything related to time based data.

When I first started learning FileMaker, I was pleased to see how easy it was to use the date and time functions. However, I didn't quite know how things worked underneath the hood. It wasn't until I tried creating my first calendar within FileMaker that I had to really get into the guts of what was going on.

Once I learned how the functions really worked, I was able to easily achieve the results desired. This video goes through the insides of how the date and time functions really work. This is what you really need to know in order to get the most out of FileMaker's date and time capabilities.

Tags:

FileMaker Overview: Number Functions

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.

Tags:

FileMaker Overview: Text Formatting Functions

While placing fields and merge text onto a layout is a simple matter of adding the elements to the layout, the formatting you apply to onscreen data can only go so far. Sure, we can use Conditional Formatting in order to achieve all kinds of great looking layouts, but, what if there were a way to go beyond these straight-forward layout tools and leverage even more control.

What about dynamically displaying colored and formatted text without having to create calculated fields? Well, all of this, and more, can be accomplished when you take advantage of FileMaker's Text Formatting functions.

This will video will walk you through what you need to know about the Text Formatting functions and how they can be used to give your layouts a much more impactful presence.

Tags:

FileMaker Overview: Text Functions

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!

Tags:

Top 5 Reasons to know the Let() function

I can certainly understand why the Let function isn’t the first thing newer FileMaker developers decide to learn. First, it’s a very complex looking function, and it isn’t inherently obvious in terms of the benefits you’ll receive for knowing it. And, second, it likely just doesn’t show up on the “must-know” radar until you see it used in an effective way.

However, the second you realize its true value, it becomes a must use function. I actually can’t see how someone would develop in FileMaker Pro without using it. It’s the ultimate code organizer. It makes things clean and provides so many opportunities to keep your overall code base much smaller.

In this video, we take a look at the Let function and my top 5 reasons for why you should know and use it. If you’ve got more reasons, then please add comments on the article page!

Tags: