Boolean calculations and truthiness in FileMaker

Intermediate

Understand how FileMaker evaluates truth and falseness in calculations, and write concise Boolean expressions that work correctly in all contexts.

What you'll learn

FileMaker's truthiness rules for numbers, text, and empty values
How to write concise Boolean conditions without explicit = 1 comparisons
How And, Or, and Not behave in calculation expressions
How to store and use Boolean flags in Number fields

FileMaker does not have a dedicated Boolean type -- every value can be evaluated as true or false based on simple rules. Understanding these rules lets you write cleaner calculations, avoid redundant comparisons, and correctly chain Boolean logic using And, Or, and Not.

1/4

FileMaker truthiness rules

In a Boolean context, FileMaker evaluates: non-zero numbers as true, zero and empty numbers as false, non-empty text as true, empty text as false.

FileMaker Script

// These all evaluate as true in an If() condition:
If ( 1 ; "true" ; "false" )          // -> "true"
If ( -5 ; "true" ; "false" )         // -> "true"  (non-zero)
If ( "hello" ; "true" ; "false" )    // -> "true"  (non-empty text)

// These evaluate as false:
If ( 0 ; "true" ; "false" )          // -> "false"
If ( "" ; "true" ; "false" )         // -> "false" (empty)
If ( "0" ; "true" ; "false" )        // -> "false" (text "0" is falsy)

Number formatting: dollar amounts, percentages, and display ExecuteSQL advanced patterns