ISO FileMaker Magazine

Once you understand the logical branching of an If() statement, it's easy to start combining a bunch of chunks of text for the purpose of data display. The problem, however, is things get really convoluted when you start to combine a variety of fields for consolidated output. You end up with a larger collection of many If statements and things become harder to read.

On the upside, one of the more enjoyable aspects of coding is discovering the elegance of concise and efficient code by using various functions in order to arrive at your desired output - without having the overhead and complex looking code.

The List function is one of those powerful functions which can be used to combine a bunch of text and then manipulate it into the desired output.

In this video, I showcase a starting point which has a number of conditional If statements and break this down into using just a few List functions.

I also show you how to leverage the list function in order to extract aggregate data which might otherwise add a good amount of overhead to the complexity of your solution.

If saving table occurrences and relationships is part of your solution agenda, then this video will have some useful information.