© Mark Conway Munro 2021
M. C. MunroLearn FileMaker Pro 19https://doi.org/10.1007/978-1-4842-6680-9_13

13. Exploring Built-in Functions

Mark Conway Munro1  
(1)
Lewisburg, PA, USA
 
FileMaker includes a library of over 300 built-in functions that can be used in formulas to perform common functionality. This chapter explores many essential built-in functions, covering the following topics:
  • Working with numbers, dates, and times

  • Working with text

  • Working with value lists

  • Introducing Get functions

  • Accessing fields

  • Aggregating data

  • Using statement functions

Note

Although most examples show literal values used as parameters, remember these can be variables, field references, nested expressions, and even nested calls to other functions.

Working with Numbers, Dates, ...

Get Learn FileMaker Pro 19: 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.