Chapter 12: Writing Formulas

Chapter 12 starts the exploration of using formulas and functions by presenting the basics of writing calculation formulas.


The material in this chapter is organized into the following sections:

  • Introducing Formulas
    • How Formulas Work
  • Defining Formula Components
    • Comments
    • Constants
    • Field References
    • Functions
    • Operators
    • Reserved Words
    • Variables
  • Exploring the Calculation Interface
    • Exploring the Specify Calculation Dialog
  • Writing Formulas
    • Getting Started with Simple Formulas
    • Inserting Components into Formulas
    • Creating Repeating Calculation Fields
    • Using Space to Your Advantage
  • Adding Calculations to the Learn FileMaker File
    • Company Contact Count
    • Contact Address Label