From the course: FileMaker Pro Essential Training (2019)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Recursion in calculations

Recursion in calculations - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Recursion in calculations

to iterate a task over and over. Very similar to the way a loop script step works. And in both cases, the iteration will continue until some exit condition is reached. This can be very useful in your calculations because it enables functions to contain complex logic such as sorting lines of information, modifying data within a larger block of information, and so on. One aspect that distinguishes recursive functions in FileMaker Pro 18 Advanced is that recursive functions can reference themselves. Prior to FileMaker Pro 18 Advanced, only custom functions could reference themselves. But now we have a function that's called the While function. It's named this way because it repeats its logic while a condition is true and then returns a result, thus allowing recursion without a custom function. Let's take a look at an example where I'm going to be using recursion. You see this exercise file contains an asset table that has a description of the asset in the bottom left-hand corner. It also…

Contents