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.

Logic functions: The If function

Logic functions: The If function - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Logic functions: The If function

“

- [Instructor] The logical function group contains some of the most interesting and powerful functions available in FileMaker, but by far the most useful one is something that's called the If function. Actually you're going to go into File, Manage, Database and I'm going to go into this Commission field that's already giving us the subtotal times 5%. Now, how would the If function work in here? Well, If, in short, actually introduces conditions learn one thing in this whole course, I hope you take away how the If function that can be used in many different ways. So let me talk about that specifically. if this test is true then do one result, Now in plain English you might think of it as, if it's raining outside, that would be our test, then bring an umbrella. But if it's false, if it's not raining, then wear your sunglasses. So let's say in this specific example with commission, have a 5% commission, instead what we want to do So that test is if the invoice subtotal is over 1000. Now…

Contents