© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_21

21. Logical Functions

Mark Conway Munro1 

(1)Lewisburg, Pennsylvania, USA

Logical functions are used to test conditions to produce variable results and perform other evaluative functions.

Logical Function Reference

FileMaker provides the following built-in logical functions :

  • Case

  • Choose

  • Evaluate

  • EvaluationError

  • ExecuteSQL

  • GetAsBoolean

  • GetAVPlayerAttribute

  • GetField

  • GetFieldName

  • GetLayoutObjectAttribute

  • GetNthRecord

  • If

  • IsEmpty

  • IsValid

  • IsValidExpression

  • Let

  • Lookup

  • LookupNext

  • Self

Case

The Case function evaluates one or more expressions, in order, and returns a result corresponding to the first expression to return a true ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial