BEG006 - FileMaker Calculation Fundamentals - Doug Gardner

Document created by communitymanager on Jun 2, 2017Last modified by DougGardner on Jul 25, 2017
Version 4Show Document
  • View in full screen mode

Doug Gardner (Exoteric Inc.)

Session Description

Over a quarter of the script steps in FileMaker take advantage of calculations. So do field validation, auto-entry of data, controlling record-level access in Privilege Sets, as well as some menu commands like Replace Field Contents and Send Mail.

 

This session tours FileMaker Pro via the calculation engine. We will look at most of the places calculations can be used and along the way discover types of functions and their appropriate uses with real-world solutions that can be put to use immediately.

What you should know

A basic familiarity with setting up tables, fields and layouts in FileMaker.

Products & Technologies

  • Pro/Advanced

Session Materials

  • Please see the attachment(s) below.

What You Will Learn

  • How calculations rely on context
  • How to use operators and functions
  • Using calculations in a variety of scripts
  • Using related data in calculations and calculating the costs

Attachments

Outcomes